Forum Discussion
Advocate IIDataflow Gen2 :Unable to create a table on the Lakehouse SQL catalog due to metadata refresh failure
Hi mandania ,
Based on the error message and the information provided, the issue appears to be related to a failed metadata refresh when attempting to create a table in the Lakehouse SQL Catalog.
The error message instructs TridentLakeClientUserException that if you already have the table in Lakehouse, then simply drag and drop it and recreate it. You must have the exact same schema, or if the schema of the data source has changed, then you may need to update the mapping of the dataflow to reflect the new structure.
Best Regards,
Adamk Kong
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Advocate IIUnfortunately i had to create a new workspace and recreate everything from the beginning. Dropping and recreating the tables was not an option since i was not able to do it. I sincerely hope that Fabric team fixes this issue because its not a very good experience for us.
Hi mandania ,
Thank you very much for your feedback, we will take this under advisement and get this back to the product team!
Best regards,
Adamk Kong