Skip to main content
Microsoft Idea

Synapse

New

DO NOT REMOVE QUERIES FROM SQL ENDPOINT

Vote (1) Share
Alex Blake's profile image

Alex Blake on 05 Mar 2024 03:39:40

I have a lakehouse with a couple of tables and a couple of SQL queries referencing 2 tables that I later delete. After re-loading the data and recreating the same tables with the same names but not the same schema, all the SQL queries I had before the table delete are now gone. Poof! Disappeared in the ether.


Would be nice if this didn't happen and SQL queries were endowed with immortality because as you learn how to use the various Fabric services, you are bound to screw up, and redo your work, in which case there is no real need to change table names and so on. And thus you might need the same SQL queries as before, once you adjusted some table schema, for ex.

Comments (1)
Alex Blake's profile image Profile Picture

Alex Blake on 05 Mar 2024 03:49:14

RE: DO NOT REMOVE QUERIES FROM SQL ENDPOINT

Nevermind. The SQL queries suddenly all appeared as the UI populated the query tree in one sudden shot!