Skip to main content
ParthaSarathy
Community Advisor
ParthaSarathyCommunity Advisor
Community Advisor
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
Community Advisor
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
View in thread

3 replies

Manoj_Kumar
Community Advisor
Manoj_KumarCommunity Advisor
Community Advisor
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  | https://themartech.pro
    ParthaSarathy
    Community Advisor
    ParthaSarathyCommunity AdvisorAuthorAccepted solution
    Community Advisor
    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
      Community Advisor
      Manoj_KumarCommunity Advisor
      Community Advisor
      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  | https://themartech.pro
      Terms & ConditionsAccessibility statement

      Loading footer...