𝐃𝐁𝐓 , "𝐊𝐈𝐍𝐆" 𝐨𝐧 𝐒𝐐𝐋 𝐠𝐨𝐥𝐝/𝐝𝐢𝐦𝐞𝐧𝐬𝐢𝐨𝐧𝐚𝐥 𝐦𝐨𝐝𝐞𝐥 𝐭𝐫𝐚𝐧𝐬𝐟𝐨𝐫𝐦𝐚𝐭𝐢𝐨𝐧𝐬 𝐬𝐮𝐩𝐩𝐨𝐫𝐭 𝐨𝐧 𝐅𝐀𝐁𝐑𝐈𝐂

10) 𝐃𝐁𝐓 , "𝐊𝐈𝐍𝐆" 𝐨𝐧 𝐒𝐐𝐋 𝐠𝐨𝐥𝐝/𝐝𝐢𝐦𝐞𝐧𝐬𝐢𝐨𝐧𝐚𝐥 𝐦𝐨𝐝𝐞𝐥 𝐭𝐫𝐚𝐧𝐬𝐟𝐨𝐫𝐦𝐚𝐭𝐢𝐨𝐧𝐬 𝐬𝐮𝐩𝐩𝐨𝐫𝐭 𝐨𝐧 𝐅𝐀𝐁𝐑𝐈𝐂

✔️ A native data pipeline (orchestrator) task to RUN DBT cloud jobs

(DBT cloud connection and a command (run model(s) / build model(s) /test/snapshot) + CICD environment : Targeted Fabric DWH + CICD environment variables for code : sourcing )

✔️ Warehouse T SQL functions DBT compiler engine would like to use :

• Type 1 upsert ==> merge (useful UPSERT on stored proc or for engine DBT compiler)
• Row snapshot , Type 2 versioning ==> merge with OUTPUT $action (useful UPSERT + CREATION new current row in case of update) on storec proc or for engine DBT compiler)
• Full refresh ==> truncate table (useful on stored proc or for DBT engine compiler)