DBT Tutorial: Project and Environment variables
🚀 Welcome to Anirvan Decodes! 🚀
In this video we will learn how to enhance dbt code with project and environment variables
🎓 Ready to master DBT? Hit the subscribe button and turn on notifications to stay updated on our latest tutorials and tips!
sql statements
use database dbt_tutorial;
CREATE or REPLACE TABLE raw.sales_data (
employee_id INT,
sales_amount DECIMAL(10, 2),
transaction_date DATE
);
-- Inserting sales data
INSERT INTO raw.sales_data (employee_id, sales_amount, transaction_date)
VALUES
(1, 5000, '2024-01-01'),
(1, 7000, '2024-01-02'),
(1, 8500, '2024-01-03'),
(2, 6000, '2024-01-04'),
(2, 9000, '2024-01-05'),
(2, 9500, '2024-01-06'),
(3, 8000, '2024-01-07'),
(3, 12000, '2024-01-08'),
(3, 11000, '2024-01-09'),
(4, 10000, '2024-01-10'),
(4, 7500, '2024-01-11'),
(4, 8500, '2024-01-12'),
(5, 5500, '2024-01-13'),
(5, 6500, '2024-01-14'),
(5, 7000, '2024-01-15'),
(6, 5000, '2024-01-16'),
(6, 9000, '2024-01-17'),
(6, 9500, '2024-01-18'),
(7, 7000, '2024-01-19'),
(7, 8500, '2024-01-20'),
(7, 11000, '2024-01-21'),
(8, 8000, '2024-01-22'),
(8, 7500, '2024-01-23'),
(8, 8500, '2024-01-24'),
(9, 5000, '2024-01-25'),
(9, 7000, '2024-01-26'),
(9, 7500, '2024-01-27'),
(10, 6000, '2024-01-28'),
(10, 8000, '2024-01-29'),
(10, 8500, '2024-01-30');
select * from raw.sales_data;
select * from DBT_TUTORIAL.INTERMEDIATE.INT__SALES_REPORT
#DBT #DataEngineering #DataAnalytics #Tutorial #DataTransformation #DataOps #DBTTutorial #Variables #EnvironmentVariables #ProjectVariables #DataManagement #DataWarehousing #DataScience #YouTubeTutorial #TechTutorial #OpenSource #DataModeling #ETL #ELT #DataIntegration #SQL #Analytics #DataProcessing #DataPipeline #DataEngineeringTutorial #DataWarehouseManagement #DataAnalysisTutorial
create dbt project,dbt labs,dbt,dbt tutorial,dbt training,intro to dbt,data build tool dbt,what is dbt,dbt core,how to install dbt,github environment variables,dbt and git,dbt virtual environment,dbt directories,dbt and snowflake,using variables in your project,start a new project in dbt,install dbt in a virtual environment,install dbt,dbt set variable,dbt project tutorials,learn dbt,dbt project,dbt set project,dbt best practices
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Music: Inspire 2 by Wavecont
https://protunes.net
Video Link: • Wavecont - Inspire 2 (Background Music For...
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬