Snowflake integration - VIEWS | Community
Skip to main content
ParthaSarathy
New Participant
Sep 5, 2022 1:21 PM UTC
Solved

Snowflake integration - VIEWS

Hi,

Created a snowflake integration with classic and integration is working fine. We have tables and views in snowflake.

When I try to Access the TABLES from snowflakes, the fields in snowflake tables are auto-populated in Campaign schema as <attribute/>

.

But when I try to access VIEWS of snowflake, We can see only <element/> and not the fields as attributes.

 

How to get the attribute auto-populated while creating schema using snowflake's VIEWS.

 

Regards,
ParthaSarathy

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
ParthaSarathy
ParthaSarathyAccepted solution
New Participant
Sep 12, 2022 9:21 AM UTC

Hi @_manoj_kumar_ ,

Thanks for the response! We had raised a support ticket and got the below response,

 

"With Snowflake, you can select here your views if the database user has been granted the correct privileges. Note that when using views, Adobe Campaign will not be able to automatically generate the XML schema, you will have to create it yourself."

 

( 3rd point in this document )

 ~  ParthaSarathy S~  Click here to join ADOBE CAMPAIGN USER GROUP for Quarterly In-person | Hybrid | Virtual Meetups

3 replies

_Manoj_Kumar_
New Participant
Sep 5, 2022 1:33 PM UTC

Hello @parthasarathy 

 

This is a known bug. Raise a support  ticket with Adobe and they will fix it for you.

 

 

Translate
     Manoj     Find me on LinkedIn
ParthaSarathy
ParthaSarathyAuthorAccepted solution
New Participant
Sep 12, 2022 9:21 AM UTC

Hi @_manoj_kumar_ ,

Thanks for the response! We had raised a support ticket and got the below response,

 

"With Snowflake, you can select here your views if the database user has been granted the correct privileges. Note that when using views, Adobe Campaign will not be able to automatically generate the XML schema, you will have to create it yourself."

 

( 3rd point in this document )

Translate
 ~  ParthaSarathy S~  Click here to join ADOBE CAMPAIGN USER GROUP for Quarterly In-person | Hybrid | Virtual Meetups
_Manoj_Kumar_
New Participant
Sep 13, 2022 4:40 AM UTC

Hello @parthasarathy 

 

This is interesting. I am able to create a schema from a snowflake view.

 

Initially, I could not even view the columns from the Snowflake view, then I raised a support ticket and now Snowflake views work just like a table.

Translate
     Manoj     Find me on LinkedIn