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...
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
In questa pagina del sito puoi guardare il video online DBT Tutorial: Project and Environment variables della durata di ore minuti seconda in buona qualità , che l'utente ha caricato Anirvan Decodes 17 febbraio 2024, condividi il link con amici e conoscenti, su youtube questo video è già stato visto 3,281 volte e gli è piaciuto 52 spettatori. Buona visione!
