Custom field data mismatch in Snowflake

Question

I recently used WF Data connect and setup a reader account on Snowflake. We are making an API call to the snowflake tables to get Custom project data. The problem we are facing is that the changes we do on custom form dropdown options do net get retroactively updated on the snowflake table.

For e.g. on the project level, there is a Custom dropdown field "Region" with the following dropdown options - "APAC" , "EMEA", "Americas"

Let's say we changed the option "APAC" to "APAC and NZ". In Workfront, this will mean that all the projects with the option "APAC" selected will update to "APAC and NZ" automatically.

However, the snowflake table does not consider this change and reflects "APAC" for any projects where this field was filled prior to the change. Am I missing something?

- Rowvill

skyehansen · Answer

I'm seeing that there's a four hour lag here:https://experienceleague.adobe.com/en/docs/workfront/using/reporting/data-lake/data-dictionary Is that something you've taken into consideration?

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded