Snowflake integration - VIEWS | Community
Skip to main content
ParthaSarathy
Community Advisor
ParthaSarathyCommunity Advisor
Community Advisor
September 5, 2022
Solved

Snowflake integration - VIEWS

  • September 5, 2022
  • 1 reply
  • 1407 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.
Best answer by ParthaSarathy

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 )

1 reply

Manoj_Kumar
Community Advisor
Manoj_KumarCommunity Advisor
Community Advisor
September 5, 2022

Hello @parthasarathy 

 

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

 

 

Manoj  | https://themartech.pro
    ParthaSarathy
    Community Advisor
    ParthaSarathyCommunity AdvisorAuthorAccepted solution
    Community Advisor
    September 12, 2022

    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
      Manoj_Kumar
      Community Advisor
      Manoj_KumarCommunity Advisor
      Community Advisor
      September 13, 2022

      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.

      Manoj  | https://themartech.pro
      Terms & ConditionsAccessibility statement

      Loading footer...