DBT Macro | DBT Real Time Use Cases | Regexp Macro
DBT Macro :
DBT Real Time Scenario:
CREATE OR REPLACE TABLE EMP_T(EMP_ID VARCHAR(20),
NAME VARCHAR(50));
INSERT INTO EMP_T VALUES('1234','PRAVEEN');
INSERT INTO EMP_T VALUES('12AG3%5','KUMAR');
INSERT INTO EMP_T VALUES('12AG3%6* ','RAM');
INSERT INTO EMP_T VALUES(' 1_237*# ','RAVI');
Data Build Tool
Used for Data Transformation
Not a ETL Tool
ELT = T
Raw Data = DBT =Transformed Data
Advantages of DBT:
Easy Testing
Reusable Code (Macros & JINJA )
CI CD Integration
Data Lineage
Documentation
Prerequisites:
Snowflake Account
DBT cloud Account
Snowflake Database
Snowflake Schema
Snowflake Tables
#dbtcloud#databuildtool #dbtsnowflake #learningdbt #dbtdemovideos
#dbtwithsnowflake#snowflakeanddbt #dbtinterviewquestions
#snowflakewithdbt#snowflakedbtcloud #databuildtoolforsnowflake
#setupsnowflakewithdbt #etl #elt #dbtlink
#dbtmodels#dbtseeds #dbtwithairflow #airflow #airflowdbt
#dbtmacros#dbtanalysis #datalineagewithdbt #dags #dbtdags
#dbtincrementals #dbtscds#dbtmaterilizations #dbtmacros #macros #macrosindbt
#dbtcloud #dbtcore #dbtcloud #dbtwithsnowflake #snowflakewithdbt #dbtincrementals
