Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Did you hear? There's a new SQL AI Developer certification (DP-800). Start preparing now and be one of the first to get certified. Register now

AntonioPineda

CopyJob Query as Source

Submitted by on ‎09-11-2025 12:23 PM

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!

Status: Completed

Use query as source has been added in Copy job.  See details in Truncate Destination, Queries and Multiple Folders – Simplifying Data Ingestion with Copy Job | Micr...

See more ideas labeled with:
4 Comments (4 New)
Comments
yexu
Microsoft Employee
Microsoft Employee
‎09-11-2025 10:44 PM
Status changed to: Needs Votes
 
Miwa1
Microsoft Employee
Microsoft Employee
‎12-11-2025 01:08 AM
Query is already supported for the following connectors and we're expanding it to more. Lakehouse AzureSql AzureSqlMI FabricSql SqlServer AzureSQLDatawarehouse Snowflake Google BigQuery Oracle Kusto
AntonioPineda
Regular Visitor
‎12-11-2025 04:51 AM
YES! We noticed it is added now. Thanks a lot!
yexu
Microsoft Employee
Microsoft Employee
‎02-05-2026 09:05 PM
Status changed to: Completed

Use query as source has been added in Copy job.  See details in Truncate Destination, Queries and Multiple Folders – Simplifying Data Ingestion with Copy Job | Micr...