Tag: ETL
DBT : Explain on DBTs models, snapshots, seeds, tests, macros, docs, sources, exposures, metrics, analysis
In this article, we’ll dive into the key concepts of DBT, including models, snapshots, seeds, tests, macros, docs, sources, exposures,…
DBT : Concatenating two or more arrays into a single array in DBT macro.
DBT macros are reusable code snippets that can be used to create custom functions for SQL transformations. In this article,…
DBT : How do you use DBT to document your data pipeline?
DBT helps maintain a clear and detailed documentation of the entire data pipeline, making it easier for team members to…
DBT : How do you use DBT to version and deploy your models
With DBT, you can automate the process of transforming raw data into business insights, and version and deploy those models…
How do you use DBT to manage your data lineage?
Data lineage refers to the history of data as it moves from its source to its destination, including transformations and…
DBT : Automate selection of different table name in development and production in DBT using macro
Macros are a powerful tool in dbt (Data Build Tool) that allow you to reuse code and make your SQL…
DBT : How to manage multiple environments in DBT ?
When working with data, it’s often necessary to manage multiple environments, such as development, testing, and production, in order to…
DBT : Using Python how can we get the upstreaming and downstream models in DBT ?
In DBT, it is possible to write Python code to perform custom operations on data models, such as finding the…
DBT : How to extract artifacts like manifest, catalog, run-results and sources files in DBT ?
DBT (Data Build Tool) allows you to extract artifacts from your database, including the manifest, catalog, run-results, and sources files….
DBT : How to clean up removed models from your production schema ?
DBT (Data Build Tool) is a powerful open-source tool used for data transformation and analysis. As your data model evolves,…