search

databricks-demos / dbdemos

Demos to implement your Databricks Lakehouse
Other
255 stars 80 forks source link

Unable to install with skipDashboards= False #112

Open kaur-ivneet opened 3 months ago

kaur-ivneet commented 3 months ago

When running the installation, the process fails when executing widget queries. This is because it creates a serverless sql warehouse, which is prohibited in the enterprise I m working for. There is no option to switch to pro warehouse as the job is not deployed and only job run is recorded.

QuentinAmbard commented 3 months ago

Hey, which demo is it? Can you share a screenshot with the error?

kauriv commented 3 months ago

Apologies, the demo is for the costing and forecasting dashboard (uc04-system-tables)

when installation runs, a job run is kicked off which uses dbdemos-serverless sql warehouse. Since our enterprise blocks any connection to the underlying uc buckets from serverless sql, the job run fails. Since the job is not deployed, I can’t edit the job to change compute configuration. Is there a way to skip installing dashboard, and do that manually afterwards? I can run the full install if I chose to skip dashboard. I am away for couple days, so can’t post a screenshot. Hope the above information is sufficient

QuentinAmbard commented 3 months ago

yes you need skipDashboards=True This is due to some limitation in the previous dashboard and I don't know how to solve it. We're moving to lakeview soon and hopefully it'll solve the issue once and for all!

kauriv commented 3 months ago

In the interim, is it possible to provide the corresponding queries that powers the dashboard, and steps to follow to put it together?

QuentinAmbard commented 3 months ago

Hey, here is a the dashboard in lakeview. I haven't tested it, and you'll need to change the catalog with the forecast where you installed the demo, but it should give you the main queries! Cost Management and Forecasting (powered by UC System Tables) (Lakeview).lvdash.json