Forum Discussion
Problem loading Lakehouse file/table into warehouse
Hello, I'm facing issues loading data from Fabric Lakehouse Table/File to Fabric Warehouse. Below is my notebook code. Im using pyspark lakehouse_table_path = f"{lakehouse_path}/Tables/{...
Thanks for the reply. i can't use copy activity becuase im writing dynamic pipeline using notebook. All i need is a way to push Lakhouse table data into Warehouse.
Hi westf
You may check the data type of the datetime column in the Pandas dataframe. In my testing, I got the following datetime64. It may be not compatible with the datetime2 type in the destination warehouse. I guess this might be the cause of the error. Not sure if this data type could be converted to meet the target. You may research this further.
Best Regards,
Jing