Do you know if you can use spark streaming from a mirrored Azure SQL data warehouse? If you try and enable change data feed via a notebook in the lakehouses where the mirrored database is shortcutted from it errors out saying unavailable from shortcut. And yet SET TBL PERMISSIONS is not supported trying to enable change data feed via the SQL endpoint in the data warehouse.
Do you know if you can use spark streaming from a mirrored Azure SQL data warehouse? If you try and enable change data feed via a notebook in the lakehouses where the mirrored database is shortcutted from it errors out saying unavailable from shortcut. And yet SET TBL PERMISSIONS is not supported trying to enable change data feed via the SQL endpoint in the data warehouse.