We have a number of use cases for Virtualizing data from #Snowflake. As we get started, we can connect, sync, configure multi-column external id... but Validate and Sync only shows Tables, not Views.
How can we use this Salesforce Connect SQL for Snowflake adapter to virtualize Views, which is our primary way we expose our data in Snowflake?
CC: @Ross Belmont
(PS I thought I posted this yesterday, but I don't see it... sorry of this is a re-post)
7 risposte
@Jonathan Green this is a reasonable request, but we'd need to cross-check with the folks at Snowflake to be sure about the pros and cons. In the meantime, it looks like Dynamic Tables provide a workaround; don't forget to turn off DML since it sounds like they'd be read only.