Snowflake optimization – use Cluster Keys when a dominate access path is known
This will colocate data often queried together into the same or adjacent micro-partitions. This will expedite retrieval and reduce warehouse […]
This will colocate data often queried together into the same or adjacent micro-partitions. This will expedite retrieval and reduce warehouse […]
Search optimization is a premium product available with enterprise version of Snowflake and up. https://docs.snowflake.com/en/user-guide/search-optimization-service https://docs.snowflake.com/en/user-guide/search-optimization-service#label-search-optimization-maintenance-billing Search optimization expedites queries
copy into <table-name> from <stage-name> storage_integration = <integration-name> Here is a step by step on how to setup the storage
To display a list of shortcut keys relevant to Windows do this: control-shift-? To display a list of shortcut keys
The really nice feature of Snowflake’s materialized views is that they are automatically kept in sync with their underlying SQL.
alter session set use_cached_result = false;
The blog outlines one method for handling Slowly Changing Dimensions – probably the most popular method referred to as type
// Use the table function “TASK_HISTORY()” select * from table(information_schema.task_history()) order by scheduled_time desc; // See results for a specific
There are rules about the order or resumption, that make resuming parent and child task a pain, but here is
Imperative (aggregated changes) versus Declarative (by declaring end state intention – e.g. Terraform Style) A couple of popular examples of