databricks-demos / dbdemos

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

uc-04-system-tables: Dashboards not getting created #48

Closed ankurmitujjain closed 11 months ago

ankurmitujjain commented 11 months ago

I have premium databricks workspace and is able to install uc-04-system-tables demo without dashboard by below command. dbdemos.install('uc-04-system-tables', use_current_cluster = True, overwrite= True, skip_dashboards = True)

I have to install it outside of main catalog (Not accessible), so had skipped dashboard creation, how can I create dashboard after installation? Is it possible to have queries + dashboard available as resources? which I can import?

Demo installation stops when I run below command... dbdemos.install('uc-04-system-tables', use_current_cluster = True, overwrite= False, skip_dashboards = False) image

ankurmitujjain commented 11 months ago

@QuentinAmbard is it possible to provide a zip of dashboard/sql queries?

QuentinAmbard commented 11 months ago

dashboard.zip

here there are, if you have the preview enabled for import/export you can use it to load the dashboard by importing ab3b5298-e09e-4998-8ef3-ae456a7b888d_import_api.json the other one is what we use with dbsqlclone waiting for the import/export to go public preview.

You can open the job to see the error in more details? you have the link here:

image
ankurmitujjain commented 11 months ago

w

Job doesnt fails, but continue to run for infinite period... job query expects table to be available in main catalog, which in my case I had changed to a different catalog...

QuentinAmbard commented 11 months ago

Hey, we did a new release, could you try again see if it works better now? If not can you share where the job is stuck? You can send it by email if you don't want to share it directly here: quentin.ambard@databricks.com

ankurmitujjain commented 11 months ago

Thanks @QuentinAmbard I tested it.. and it really worked like a charm... I was able to create and share cost mgmt dashboard with our other colleagues...