Forum Discussion
Best Practice for Lakehouse Table & View Deployments?
Hi jochenj ,
Thanks for reaching out to the Microsoft fabric community forum.
Cosider this as a workaround and try it once. Create a notebook in your development workspace that automatically extracts metadata for all:- Lakehouse tables (Delta format)
- SQL views (from the Lakehouse SQL endpoint)
- semPy library use get_lakehouse_tables() to retrieve table definitions
- SQL query SELECT * FROM INFORMATION_SCHEMA.VIEWS to get view definitions
You can serialize the output (e.g., as .json or .sql files) and store them in the Files section of your Lakehouse or in a dedicated folder within OneLake. This makes the metadata portable and ready for deployment to other environments.
If I misunderstand your needs or you still have problems on it, please feel free to let us know.
Best Regards,
Menaka.
Community Support Team
Hi jochenj ,
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.
Hi jochenj ,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution so that other community members can find it easily.
Thank you.
Hi jochenj ,
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you