Prioritising Data Quality with dbt-expectations: A Practical Approach to Building Reliable Data Pipelines Discover how dbt-expectations enhances data quality checks within dbt pipelines, ensuring reliable analytics and streamlined workflows. Read more
Supercharge your Data Validation: Using CTEs and Pandas to seamlessly compare CSV data with Postgres RDS Learn to use CTEs and Pandas to efficiently compare CSV data with a PostgreSQL database without loading all data into memory. Read more
Dynamic Table Usage in Snowflake: Implementing Type 2 Slowly Changing Dimensions (SCD) with Flexibility and Efficiency We explore how AWS CloudWatch math metrics provide a powerful way to derive insights and take automated actions based on custom calculations. Read more