𝐖𝐚𝐫𝐞𝐡𝐨𝐮𝐬𝐞 𝐚𝐧𝐝 𝐓 𝐒𝐐𝐋 𝐬𝐮𝐩𝐩𝐨𝐫𝐭 - Improve features and avoid limitations
𝐖𝐚𝐫𝐞𝐡𝐨𝐮𝐬𝐞 𝐚𝐧𝐝 𝐓 𝐒𝐐𝐋 𝐬𝐮𝐩𝐩𝐨𝐫𝐭
✔️ Any news about T-SQL DDL ==>
- alter table add/remove column
- Identity Columns
- Primary keys
- RECORD Columns (store nested fields like json structures)
- temporary tables (useful on store...
STATUS DETAILSNew
𝐏𝐨𝐰𝐞𝐫 𝐁𝐈 𝐰𝐨𝐫𝐤𝐥𝐨𝐚𝐝 - Import mode - Improve this workload
6) 𝐏𝐨𝐰𝐞𝐫 𝐁𝐈 𝐰𝐨𝐫𝐤𝐥𝐨𝐚𝐝
✔️ Improve direct query to semantic model robustness
- Architecture & governance : DQ to semantic model or another way to offer perspectives to datacitizens from official PBI data products
✔️ Permit to creat...
𝐌𝐢𝐫𝐫𝐨𝐫𝐢𝐧𝐠 to anothers databases & systems
8) 𝐌𝐢𝐫𝐫𝐨𝐫𝐢𝐧𝐠
✔️ Differentiate behaviors and services offered (SQL ERP data or Snowflake BI data)
- Not sure politically and governance speaking it's a "good idea" to offer the SQL end point on Fabric to Snowflake BI data products ( read only or allow transfor...
STATUS DETAILSNew
𝐒𝐞𝐦𝐚𝐧𝐭𝐢𝐜 𝐦𝐨𝐝𝐞𝐥 𝐨𝐯𝐞𝐫 𝐋𝐀𝐊𝐄𝐇𝐎𝐔𝐒𝐄 𝐒𝐐𝐋 𝐞𝐧𝐝𝐩𝐨𝐢𝐧𝐭 𝐥𝐢𝐦𝐢𝐭𝐚𝐭𝐢𝐨𝐧s
✔️ Stop limitations and allow access on SEMANTIC MODEL sourcing to SQL views & CTAS tables :
- 𝐋𝐚𝐤𝐞𝐡𝐨𝐮𝐬𝐞 𝐒𝐐𝐋 𝐯𝐢𝐞𝐰𝐬 𝐭𝐨 direct lake 𝐒𝐐𝐋 𝐭𝐚𝐛𝐥𝐞𝐬 (created via LH SQL end point)
- and 𝐂𝐓𝐀𝐒 (𝐜𝐫𝐞𝐚𝐭𝐞 𝐭𝐚𝐛𝐥𝐞 𝐚𝐬 𝐬𝐞𝐥𝐞𝐜𝐭 .. 𝐟𝐫𝐨𝐦 𝐝𝐞𝐥𝐭�...
STATUS DETAILSNew
𝐃𝐁𝐓 , "𝐊𝐈𝐍𝐆" 𝐨𝐧 𝐒𝐐𝐋 𝐠𝐨𝐥𝐝/𝐝𝐢𝐦𝐞𝐧𝐬𝐢𝐨𝐧𝐚𝐥 𝐦𝐨𝐝𝐞𝐥 𝐭𝐫𝐚𝐧𝐬𝐟𝐨𝐫𝐦𝐚𝐭𝐢𝐨𝐧𝐬 𝐬𝐮𝐩𝐩𝐨𝐫𝐭 𝐨𝐧 𝐅𝐀𝐁𝐑𝐈𝐂
10) 𝐃𝐁𝐓 , "𝐊𝐈𝐍𝐆" 𝐨𝐧 𝐒𝐐𝐋 𝐠𝐨𝐥𝐝/𝐝𝐢𝐦𝐞𝐧𝐬𝐢𝐨𝐧𝐚𝐥 𝐦𝐨𝐝𝐞𝐥 𝐭𝐫𝐚𝐧𝐬𝐟𝐨𝐫𝐦𝐚𝐭𝐢𝐨𝐧𝐬 𝐬𝐮𝐩𝐩𝐨𝐫𝐭 𝐨𝐧 𝐅𝐀𝐁𝐑𝐈𝐂
✔️ A native data pipeline (orchestrator) task to RUN DBT cloud jobs
(DBT cloud connection and a command (run model(s) / build mo...
𝐂𝐨𝐫𝐞 𝐭𝐨𝐩𝐢𝐜 - 𝐃𝐞𝐩𝐥𝐨𝐲𝐦𝐞𝐧𝐭 𝐩𝐢𝐩𝐞𝐥𝐢𝐧𝐞 𝐚𝐥𝐨𝐧𝐠𝐬𝐢𝐝𝐞 𝐄𝐍𝐕
𝐂𝐨𝐫𝐞 𝐭𝐨𝐩𝐢𝐜 - 𝐃𝐞𝐩𝐥𝐨𝐲𝐦𝐞𝐧𝐭 𝐩𝐢𝐩𝐞𝐥𝐢𝐧𝐞 𝐚𝐥𝐨𝐧𝐠𝐬𝐢𝐝𝐞 𝐄𝐍𝐕. 𝐰𝐨𝐫𝐤𝐬𝐩𝐚𝐜𝐞𝐬 𝐧𝐞𝐞𝐝 𝐭𝐨 𝐨𝐧𝐥𝐲 𝐮𝐩𝐝𝐚𝐭𝐞 𝐦𝐞𝐭𝐚𝐝𝐚𝐭𝐚 / 𝐩𝐚𝐫𝐚𝐦𝐞𝐭𝐞𝐫𝐬 / 𝐜𝐨𝐧𝐧𝐞𝐜𝐭𝐢𝐨𝐧𝐬 (𝐧𝐞𝐯𝐞𝐫 𝐃𝐀𝐓𝐀)
- Trying to deploy a Warehouse T SQL table with 2 new ...
STATUS DETAILSNeeds Votes