Custom field data mismatch in Snowflake

[RowvillBh1]

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]

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?

[RowvillBh1]

Yes. This issue/limitation is after considering the 4 hour time lag.

[kautuk_sahni]

@RowvillBh1 Just checking in — were you able to resolve your issue? We’d love to hear how things worked out. If the suggestions above helped, marking a response as correct can guide others with similar questions. And if you found another solution, feel free to share it — your insights could really benefit the community. Thanks again for being part of the conversation!