Forum Discussion
Advocate IISynapse Datawarehouse to Fabric Warehouse Data Load
Well we have tested this scenerio by creating tabular mapping and directly loading parquet file from data lake into the lakehouse using ADF and then moving that data into warehouse through stored procedure works; without any staging and it works, somehow staging in onelake does not allow us to move the data into warehouse.
This will be an actual solution for the problemetic data types, or someone who is directly looking to copy data to test fabric warehouse/lakehouse performance and test one time migration.
Community SupportHi AnmolGan81 ,
Thank you for sharing your findings. Loading data directly from the Lakehouse and bypassing the automatic staging step seems like a good approach, especially if tabular mapping preserves the FLOAT data type. Considering the staging limitations, this could serve as an effective workaround.
I look forward to hearing about your results after you try it.
Thank You.
Advocate IIwe have an upcoming migration to other enviorment will let you know how it goes.
- V-yubandi-msft
Thanks for your workaround.
- V-yubandi-msft
Thank you for the update. I hope the migration to the new environment goes smoothly. When you've had a chance to test everything, please let me know how it works out.
- V-yubandi-msft
Could you please let us know the ETA by when you upcoming migration to other enviorment ? This will help us to know when we can follow up. If you encounter any challenges during implementing the provided solution, please inform us and we’ll be glad to assist.
- AnmolGan81
Well we have tested this scenerio by creating tabular mapping and directly loading parquet file from data lake into the lakehouse using ADF and then moving that data into warehouse through stored procedure works; without any staging and it works, somehow staging in onelake does not allow us to move the data into warehouse.
This will be an actual solution for the problemetic data types, or someone who is directly looking to copy data to test fabric warehouse/lakehouse performance and test one time migration.