Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Nondescript error when copying data from on prem SQL to Fabric LH using ADF Connector

Trying to copy data from on-prem SQLServer to Fabric LH via ADF SHIR Lakehouse Linked Service Connection...   Source table has 5 rows and uses varchar(1024), datetime, and bigint datatypes. There i...
Need Help
pipelines
  • Anonymous's avatar
    Anonymous
    2 years ago

    I figured it out! My source query was incorrectly adding the same column twice when copying from on prem to Fabric LH in Azure Data Factory.

     

    So this error was just saying "invalid schema" 

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Tried changing the Unique Cluster Index to Nonclustered and still getting this error.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Anonymous ,

Thanks for using Fabric Community.
Can you please help me understand which data factory are you using? Is it Azure Data Factory or Fabric Data Factory?