What is Cortex Code and Why Does it Matter?
Cortex Code is Snowflake’s AI coding agent that understands your schemas, roles, and pipelines, helping teams write, debug, and optimize SQL, dbt, and Airflow faster while staying aligned with governance and cost best practices.
How to Deploy Snowflake Streamlit Apps: The Easiest Method Explained Using dbt
Learn how to seamlessly integrate Snowflake Streamlit Apps with your dbt project for streamlined deployments, combining the power of Snowflake with dbt’s modular workflows.
Why Should you Codify your Best Practices in dbt?
This blog explores the importance of codifying best practices in dbt and provides practical guidance on the “why” and “how” of implementation.
phData Awarded dbt Labs’ 2024 Partner of the Year
phData wins dbt Labs 2024 Partner of the Year!! Learn more about this prestigious award and what it means to phData in this blog.
How to Create a dbt Custom Materialization
Learn step-by-step how to leverage dbt’s flexibility to tailor materialization methods to your specific data needs.
Accelerating and Scaling dbt for the Enterprise
Learn how to effectively scale dbt for enterprise use while adhering to best practices in this whitepaper. Read today!
How to Achieve Source Freshness and Stateful Selection with Cosmos API + dbt Core
Cosmos API is a great tool to orchestrate dbt tasks through Airflow. It generates/renders DAG based on the dbt code. Using this tool together with
How to Automate Database and Schema Names in dbt
dbt is a data transformation tool that helps data analysts and data engineers transform data in cloud data warehouses with loaded features and flexibility. With
How to Ace dbt with Jinja
dbt’s SQL-based approach democratizes data transformation. However, python and other programming languages edge out SQL with its metaprogramming capabilities. dbt’s Jinja integration bridges the gap
How to Slowly Change Dimensions with Snapshots in dbt
In this blog, we will explore Slowly Changing Dimensions (SCDs) and the magic of dbt snapshots. Specifically, we’ll show how to create dbt snapshots and
