- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-04-2024 02:08 PM
It appears as though Databricks now formats SQL View definitions when showing them in the Catalog. Our solution is based on views, and we have comment tags in those views. We format these views so that it is easy for us to find and update parts of the view based on these tags. When this generic formatting is applied, it breaks this process for us.
It looks like Databricks is storing the view correctly, as I get the view in the correct format when SHOW CREATE TABLE <view_name> is returned. But in Catalog, where we have trained people to get the view definition because you can easily copy it, the format is applied.
Has anyone found a way to turn this off?
Example - how it should be formatted:
What the generic formatted in Catalog does: