Forum Discussion
Copy Data with VNET gateway error
Hi TK12345
Thank you for the clarification.
Since another pipeline with the same logic is working successfully, this helps narrow the issue specifically to this pipeline/activity configuration or the source table metadata rather than the VNET gateway or Lakehouse itself.
Could you please try the following:
Create a new Copy Activity in the same pipeline and configure the source/destination manually instead of duplicating the existing activity.
Test with a minimal query:
Then test with:
SELECT TOP 10 *
FROM YourTable
If schema mapping is enabled, please remove and re-import the schema mapping.
Also verify whether the source table contains unsupported datatypes or special characters in column names.
This will help determine whether the issue is related to the specific pipeline configuration or the source table metadata.
Hi v-aatheeque,
Thanks for helping.
I've tested your suggestions again (tested it before myself), still the same issue. Created a new pipeline just from the UI, new connection, new lakehouse. Just a select limit 10. Still preview data to see, but same error with target.