harmanbhatia101@gmail.com

Snowflake Dynamic Tables: Materializing Results for Warehouse Cost Reduction

Leave a Comment /

Picture this: You have a query, and you want to materialize its results in a table. Instead of going through the hassle of creating a separate target table, writing transformation code, and manually updating the data, Snowflake’s dynamic tables come to the rescue. What are Dynamic tables in Snowflake? Dynamic tables serve as a remarkable …

Snowflake Dynamic Tables: Materializing Results for Warehouse Cost Reduction Read More »

Postgres to Snowflake — Migrate Real-time and Historical data

Leave a Comment /

Cloud data warehouse like Snowflake is designed for scalable business intelligence and analytics. There are various reasons to move from a traditional data warehouse to a cloud-based data warehouse, such as to handle big data and improve speed and performance. However, Our major reason for this migration was to accommodate end users. We want our …

Postgres to Snowflake — Migrate Real-time and Historical data Read More »

Snowflake Best Practices

Leave a Comment /

1- Introduction Snowflake is one of the few enterprise-ready cloud data warehouses that brings simplicity without sacrificing features. It automatically scales, both up and down, to get the right balance of performance vs. cost. Snowflake’s claim to fame is that it separates compute from storage. This is significant because almost every other database, Redshift included, …

Snowflake Best Practices Read More »