Hi.
We are trying to use the CopyJob to do Merge on some table in order to do incremental loads to a Lakehouse in Fabric from an onpremises SQL Server. Some of the tables we use are not very well constructed so we sometimes have to get rid of some columns in the source for which we use a Query instead of bringing the whole table which sometimes can have more than 100 columns (again not very well constructed table).
On the Copy Activity we have the ability so send a Query or ingest a whole table with all the columns. We would like to see this option available for the CopyJob if at all possible.
Thanks!
mdrakiburrahman
on:
Provide an opinionated and tuned Spark Single Node...
on:
Image upload in Power BI
on:
Support v2 checkpoint policy for delta table short...
Joe_Barry
on:
Get Pro license users list.