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

Snowflake integration - VIEWS

  • September 5, 2022
  • 1 reply
  • 1404 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_
_Manoj_Kumar_
New Participant
September 5, 2022

Hello @parthasarathy 

 

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

 

 

     Manoj     Find me on LinkedIn
    ParthaSarathy
    ParthaSarathyAuthorAccepted solution
    New Participant
    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_
      _Manoj_Kumar_
      New Participant
      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     Find me on LinkedIn
      Terms & ConditionsAccessibility statement

      Loading footer...