Databricks Community

SethParker

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 ...

SethParker · 11-14-2023

We have an intermittant issue where occasionally a partition in our Power BI Import Dataset times out at 5 hours. When I look at Query History in Databricks SQL, I see a query that failed with the following error message: "Query has been timed out ...

SethParker

Thank you! I will submit that request.In case anyone else stumbles upon this post, here is a function you can add that will return the view definition from information_schema, unformatted with an ALTER statement at the top:DROP FUNCTION IF EXISTS <c...

SethParker

Thank you again for looking into it! I agree that this is likely expected behavior. I just wish there was a way to turn it off. I love nearly everything about Databricks, but Views could use quite a bit of work.

SethParker

Hello Walter,Thank you for your time. In Databricks, I navigate to the Catalog tab, then to the view I want to look at. Then on the Overview tab, in the Definition section we copy the view definition out. This used to hold whatever format we used ...

SethParker · 01-02-2024

The only solution we have been able to come up with was to create a Notebook in Databricks that uses the Power BI API to check the status of a Refresh. We schedule it a bit after we expect the Refresh to complete. If it is still running, we kill th...

Databricks Community

User Stats

User Activity

SQL View Formatting in Catalog - Can you turn it off?

Power BI Import Model Refresh from Databricks SQL Whse - Query has been timed out due to inactivity

Re: SQL View Formatting in Catalog - Can you turn it off?

Re: SQL View Formatting in Catalog - Can you turn it off?

Re: SQL View Formatting in Catalog - Can you turn it off?

Re: Power BI Import Model Refresh from Databricks SQL Whse - Query has been timed out due to inactiv