Bamakus Montreuil on 08 Jul 2024 19:28:16
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 transformations)
- Limit SQL endpoints in case of attachment to a 𝐒𝐍𝐎𝐖𝐅𝐋𝐀𝐊𝐄 "𝐨𝐟𝐟𝐢𝐜𝐢𝐚𝐥 𝐜𝐨𝐦𝐩𝐚𝐠𝐧𝐲" 𝐝𝐚𝐭𝐚 𝐩𝐫𝐨𝐝𝐮𝐜𝐭, avoiding to create "political SQL architecturals problems "(governance / SQL data products)
- Mainly promote semantic model (on direct lake mode) access here
- Mirroring to SQL server (an ERP) it is very different and SQL transformations are tolerated .. and recommended