DBT Models - How to Build Scalable Data Pipelines with data build tool

  Рет қаралды 30,307

Sleek Data

Sleek Data

Жыл бұрын

how to build scalable dbt solutions
How to Override the Default Schema in dbt
building dbt data pipelines
How to Build Scalable Data Pipelines with dbt
dbt Best Practices for Development and Deployment
How to Troubleshoot dbt Schema Overrides
Dbt transformation example
dbt Lineage View A Comprehensive Guide
Macro for dbt schema overide
dbt Interview Questions
what is dbt
dbt models
dbtdata
data build tool
dbt tool
dbt etl
dbt sql
data warehouse data model
warehouse data model
dbt data build tool
data build tool dbt
dbt etl tool
data warehouse sql server
dbt data warehouse
data build tools
dbt data tool
data build tool certification
dbt tool for snowflake
dbt transform
What are models in dbt?
Is dbt an ETL?
What does data build tool do?
Is data build tool free?
dbt modularity
dbt reusability
dbt materializations
dbt views and tables
how to overide default schema with custom schema in dbt
target schema
dbt schema overide not working
dbt lineage view
dbt development best practices
Dbt data build tool models
Data build tool models pdf
Data build tool models explained
data build tool examples
data build tool tutorial
dbt data
dbt transformation example
custom-schemas dbt official link:
docs.getdbt.com/docs/build/custom-schemas
Macro for schema overide:
{% macro generate_schema_name(custom_schema_name, node) -%}
{%- set default_schema = target.schema -%}
{%- if custom_schema_name is none -%}
{{ default_schema }}
{%- else -%}
{{ custom_schema_name | trim }}
{%- endif -%}
{%- endmacro %}

Пікірлер: 21
@subbarangareddy2287
@subbarangareddy2287 7 ай бұрын
Thanks for providing overall view on the usage of DBT
@SleekData
@SleekData 5 ай бұрын
Dear Friend, Glad you like them! To stay updated with our future content, I kindly request you to consider subscribing and liking our videos. If you could share our video/channel with your friends, we would be so grateful! Thank you for your encouragement.
@ramakrishnanvenkatachalam3520
@ramakrishnanvenkatachalam3520 Жыл бұрын
This is a good way to explain, using proper data models and practical approach
@SleekData
@SleekData Жыл бұрын
Dear Friend - Thank you so much for your kind words! I'm happy to hear that you enjoyed the video. Your support means the world to me.
@srbasha74
@srbasha74 3 ай бұрын
Thanks
@SleekData
@SleekData 3 ай бұрын
Dear Friend - Thank you for your kind words! We're delighted to hear that you're enjoying our content. To stay updated with our future videos, consider subscribing and sharing with your friends. Your support means a lot to us. Thanks again for your encouragement!
@mubinshaikh1802
@mubinshaikh1802 4 ай бұрын
Really good examples and Demo, it will be good if you can share Database script along with data which we care restore in snowflake or which module you are referring to pick table and data scripts, i have completed initial 3 modules but did not find anything so far. Please do the needful.
@SleekData
@SleekData 4 ай бұрын
Dear Friend Thanks for the feedback, please check this video description with links for DDL statements for all tables. kzfaq.info/get/bejne/Z8yJZKRpuLjKnH0.html You can simply give This DDL to chat gpt and ask for 10 insert statements for each table. And execute those insert statement in your snowflake. Good luck, to stay updated with our future content, I kindly request you to consider subscribing and liking our videos.
@mubinshaikh1802
@mubinshaikh1802 4 ай бұрын
thanks@@SleekData
@abiodunthorpe8068
@abiodunthorpe8068 7 ай бұрын
At 5:31, I had to use below in dbt_project.yml file to make it work in BQ models: oms_dbt_proj: customers_stg: materialized: view orders_stg: materialized: view orderitems_stg: materialized: view customerrevenue: materialized: table orders_fact: materialized: table
@SleekData
@SleekData 7 ай бұрын
Cheers Dude, to stay updated with our future content, I kindly request you to consider subscribing and liking our videos. If you could share our video/channel with your friends, we would be so grateful!
@SMD_Azhar
@SMD_Azhar 9 күн бұрын
After creating models data will be refreshed automatically? These models have upto date data ?
@phnv
@phnv 6 ай бұрын
Could we leave the profile without a default schema and define the schema on every model instead?
@SleekData
@SleekData 5 ай бұрын
Dear Friend, Yes, you can absolutely leave the profile without a default schema and define the schema on each model individually. Here's how: 1. Omitting the Default Schema in profiles.yml: In your profiles.yml file, locate the profile for your target database. Remove or comment out the schema property under that profile. This ensures no default schema is set. 2. Specifying Schemas in Models: Within model files: Use the schema configuration option within each model's SQL file to specify its desired schema: SQL {{ config(schema="my_schema") }} select * from my_table; Use code with caution. Learn more Using model folders: Organize models into subfolders within your models directory, with each folder representing a schema: models/ my_schema/ my_model.sql another_schema/ another_model.sql In this structure, dbt will automatically use the folder name as the schema for models within that folder. To stay updated with our future content, I kindly request you to consider subscribing and liking our videos. If you could share our video/channel with your friends, we would be so grateful! Thank you for your encouragement.
@user-ff1zc3tk8k
@user-ff1zc3tk8k 10 ай бұрын
How can I enable LINEAGE VIEW tab in the terminal?
@SleekData
@SleekData 9 ай бұрын
Dear Friend - Please refer previous videos and install the plugins, you should automatically get it. Good Luck, we appreciate your support and would love it if you could like and subscribe to our channel to stay updated with our future content.
@sandeshbidave565
@sandeshbidave565 9 ай бұрын
When to use {{ source(tablename)}}?
@SleekData
@SleekData 9 ай бұрын
Dear Friend - is used to reference a source table in a model. select * from {{ source('my_source_name', 'my_table_name') }} In contrast the ref function References another model in a dbt project. I've covered it in this playlist, the entire course is just 1 hour only. Please watch to get better understanding. To stay updated with our future content, I kindly request you to consider subscribing and liking our videos. If you could share our video/channel with your friends, we would be so grateful! Thank you for your encouragement.
@user-rn4gc5vi4q
@user-rn4gc5vi4q 7 ай бұрын
Hello brother, can I get your IG if you don't mind. I have few doubts to clear
@SleekData
@SleekData 7 ай бұрын
Dear Friend, Comments are best place to interact with us, pls add new comment so that we are notified, we do not get notification for replies on existing comments. To stay updated with our future content, I kindly request you to consider subscribing and liking our videos. If you could share our video/channel with your friends, we would be so grateful! Thank you for your encouragement.
What is DBT | Data Build Tool | Real Time Project Flow | Demo
37:17
Praveen Kumar Bommisetty
Рет қаралды 3 М.
A clash of kindness and indifference #shorts
00:17
Fabiosa Best Lifehacks
Рет қаралды 121 МЛН
Heartwarming Unity at School Event #shorts
00:19
Fabiosa Stories
Рет қаралды 21 МЛН
Happy 4th of July 😂
00:12
Alyssa's Ways
Рет қаралды 69 МЛН
- А что в креме? - Это кАкАооо! #КондитерДети
00:24
Телеканал ПЯТНИЦА
Рет қаралды 7 МЛН
Why I think Event data model is the easiest to get started
39:59
Data Pipelines With DBT (Data Build Tool) in Azure
31:54
Valdas Maksimavicius
Рет қаралды 22 М.
ВАЖНО! Не проверяйте на своем iPhone после установки на экран!
0:19
ГЛАЗУРЬ СТЕКЛО для iPhone и аксессуары OTU
Рет қаралды 6 МЛН
Todos os modelos de smartphone
0:20
Spider Slack
Рет қаралды 61 МЛН
ОБСЛУЖИЛИ САМЫЙ ГРЯЗНЫЙ ПК
1:00
VA-PC
Рет қаралды 2,3 МЛН
Опасность фирменной зарядки Apple
0:57
SuperCrastan
Рет қаралды 6 МЛН