The article discusses challenges data engineers face with late or out-of-order data affecting dimensional models. It introduces Snowflake’s Dynamic Tables, which streamline the management of such data issues without requiring complex resets. The author shares a practical demo using JSON records from a CRM to illustrate the effectiveness of Dynamic Tables in processing evolving customer data.
Tag Archives: Data Cloud
From Snowflake to Domo: Setting Up Seamless Read Access
This article guides the setup of Domo for reading Snowflake data using Cloud Amplifier. The process includes integrating Snowflake in the Domo account, configuring essential settings, optimizing performance, and selecting tables to create datasets. The setup enables dynamic data visualization and analysis, with future articles focusing on writeback capabilities.
Snowflake: Table-Driven Row Access Policies
In a previous article, I showed how to set a row access policy on a view to limit the rows returned by a query dependent upon the user’s role in Snowflake. The row access policy had the roles I cared about hard coded into the policy code; however, in a real-world scenario, that isn’t manageableContinue reading “Snowflake: Table-Driven Row Access Policies”
Eric Heilman 