DAI(Data & AI)
Showing posts from 2025Show All
Data Engineering Real-Time Scenario - For Practice

Data Engineering Real-Time Scenario - For Practice

Sreenu Y September 07, 2025

Data Engineering Project Scenario   In this post, I will share a real-time project scenario designed for practice …

Read more
dbt var add in model yml file

dbt var add in model yml file

Sreenu Y August 29, 2025

dbt variable  A dbt variable is a value you define once and can reuse across many models and macr…

Read more
dbt Pre-Hooks and Post-Hooks: A Complete Tutorial with Example and Execution

dbt Pre-Hooks and Post-Hooks: A Complete Tutorial with Example and Execution

Sreenu Y August 13, 2025

dbt pre hook & post hook   1.      What is dbt pre-hook and post-hook? In dbt (data build tool), pre-hooks and po…

Read more
Convert the stno values into a 6-digit string with leading zeros using Oracle, MySQL, PostgreSQL, MySQLServer

Convert the stno values into a 6-digit string with leading zeros using Oracle, MySQL, PostgreSQL, MySQLServer

Sreenu Y July 14, 2025

#SqlInterviewquestions   Convert the stno values into a 6-digit string with leading zeros using Oracle, MySQL, Postgre…

Read more
Data Build Tool- Seeds complete details

Data Build Tool- Seeds complete details

Sreenu Y July 08, 2025

DBT Seeds   1.       The dbt seed command will load CSV file located in the seeds path directory of dbt project 2…

Read more