Forum Discussion
Getting Error while pulling data from fabric lakehouse table: Error code 21446 Details Invalid table
Hi Sachin_Patel07,
Just following up to see if the solution provided was helpful in resolving your issue. Please feel free to let us know if you need any further assistance.
Best regards,
Prasanna Kumar
Hi Sachin_Patel07,
The best solution is to avoid using the Copy Activity with the Fabric Lakehouse Table connector for now, since it's likely misinterpreting internal system columns like _change_type, causing the error. Instead, use a Fabric Notebook to read the table (which works fine, as you've confirmed) and then write the data directly to your ADLS Gen2 storage in Parquet format using a simple Spark command. This approach bypasses the Copy Activity issue completely and gives you full control over the schema and data handling.
Regards,
Prasanna Kumar
Thanks Anonymous So I will have to create a Notebook in Fabric Workspace and then need to push the table with required columns to the ADLS gen 2 storage ccount container, but the connectivity needs to be established then only I would be able to push data to the ADLS gen 2.
And is there a possibility to create a new table in the lakehouse with the required column and push the data to this table and use copy activity from synapse pipeline to get the data from this table, I know it's a long route but just thinking whether it is possible.
