How to use dbt (data-build-tool) on Fivetran!

Опубликовано: 10 Октябрь 2024
на канале: Kahan Data Solutions

13,563

132

Get my Modern Data Essentials training (for free) & start building more reliable data architectures
https://www.ModernDataCommunity.com

-----

Aside from basic SQL transformations, Fivetran integrates with data build tool (dbt) to power more complex transformations.

Fivetran connects directly to your Git provider and runs your dbt transformations according to your schedule.

This is a great collaboration between two great products in the analytics space.

In this video we will walk through how to set up this integration.

And then get started running dbt models through Fivetran!

What are Fivetran Transforms?
Automated data pipelines land data in your cloud data warehouse. Fivetran Transformations ensures that data is modeled for analytics to maximize its impact across your business.

What is DBT?
dbt is an open-source software that enables you to perform sophisticated data transformations in your destination using simple SQL statements.

Timestamps:
0:00 - Intro
0:28 - Enable DBT Transformations
1:08 - Configure With GitHub
2:27 - Add Deployment.yml
7:27 - Set Schema & Credentials
9:50 - Activate & Run Jobs

Title & Tags:
How to Transform your data on Fivetran | DBT Transformations on Fivetran | Fivetran Tutorial
#kahandatasolutions #dataengineering #fivetran