𝐂𝐨𝐫𝐞 𝐭𝐨𝐩𝐢𝐜 - 𝐃𝐞𝐩𝐥𝐨𝐲𝐦𝐞𝐧𝐭 𝐩𝐢𝐩𝐞𝐥𝐢𝐧𝐞 𝐚𝐥𝐨𝐧𝐠𝐬𝐢𝐝𝐞 𝐄𝐍𝐕

𝐂𝐨𝐫𝐞 𝐭𝐨𝐩𝐢𝐜 - 𝐃𝐞𝐩𝐥𝐨𝐲𝐦𝐞𝐧𝐭 𝐩𝐢𝐩𝐞𝐥𝐢𝐧𝐞 𝐚𝐥𝐨𝐧𝐠𝐬𝐢𝐝𝐞 𝐄𝐍𝐕. 𝐰𝐨𝐫𝐤𝐬𝐩𝐚𝐜𝐞𝐬 𝐧𝐞𝐞𝐝 𝐭𝐨 𝐨𝐧𝐥𝐲 𝐮𝐩𝐝𝐚𝐭𝐞 𝐦𝐞𝐭𝐚𝐝𝐚𝐭𝐚 / 𝐩𝐚𝐫𝐚𝐦𝐞𝐭𝐞𝐫𝐬 / 𝐜𝐨𝐧𝐧𝐞𝐜𝐭𝐢𝐨𝐧𝐬 (𝐧𝐞𝐯𝐞𝐫 𝐃𝐀𝐓𝐀)

• Trying to deploy a Warehouse T SQL table with 2 new columns , empty the targeted table <== certainly due to T SQL alter table limitation
• Warn we need to perform a FULL refresh again (& stop refresh) in case of schema change detection for incremental loads
• Perimeter ? ==> SQL tables & power bi semantic models tables
• Which tool manage incremental ? ==> Data factory data pipeline & DFGEN2 (see point 3) and Power BI semantic model settings
• Where ? ==> A warning icon on Lakehouse & DWH SQL end point or on power bi service