What you will learn
π₯ Loading raw CSV data into Snowflake using Airbyte, configuring a file connector, and setting up a manual refresh for data loading.
π How Airbyte loads data into a JSON variant column, making it more resilient to schema changes.
π Creating initial YAML and SQL files using dbt coves by inspecting available tables in Snowflake.
π§© Transforming raw data into structured models using the dbt_utils.surrogate_key macro to create a primary key.
π₯ Materializing data in Snowflake, running dbt models in VS Code, and previewing the transformed data.
π Overview of Datacoves as a turnkey solution for modern data stack tools such as dbt, Airbyte, and Airflow, with flexibility for other tool integrations.