on
RE:
Is there any update on this feature request?To me, this is a core feature that a production ready system must have.This is currently keeping our company from using Fabric when building solutions.
RE:
With SQLpackage we can't do CI/CD when change the table structure ##[error]*** An error occurred during deployment plan generation. Deployment cannot continue.##[error]Error SQL0: Deployment cannot continue because table changes that require 'ALTER TABLE' are not supported on Synapse Data Warehouse in Microsoft Fabric at this time.##[error]System.Management.Automation.RemoteException##[error]The Azure SQL DACPAC task failed. SqlPackage.exe exited with code 1.Check out how to troubleshoot failures at https://aka.ms/sqlazuredeployreadme#troubleshooting-
RE:
ShortCuts from LakeHouse to Warehouse is important, to get one copy of data. If not is possible technical this point, the I suggest to use CREATE EXTERNAL TABLE to point to the Delta Table in the LakeHouse, and the table will be only read. I think this table types in the warehouse is usually only for read and make relations between warehouse tables and Lakehouse tables. Also is necessary the work with these tables with Direct Lake.
RE:
Request is in high demand.Hop it is added to the Road map in the near future.