topic Metric Tables not created automatically in Get Started Discussions

Metric Tables not created automatically

yatharth — Mon, 19 Feb 2024 16:21:24 GMT

I was trying the new lakehouse monitoring feature for one of my unity tables, and when I create a monitoring dashboard for my table, the 2 metric tables({output_schema}.{table_name}_profile_metrics and {output_schema}.{table_name}_drift_metrics) are not getting created automatically in the specified path. Am i doing something wrong?

Steps followed:

1.Made sure I was the owner of the table
2.Clicked on the quality tab and get started
3.Chose snapshot profile as Profile type
4.Schedule: Refresh manually
5.Metric tables schema name: catalog_name.output_schema_name, output_schema_name was different from where my table was, but catalog was identical
6.Create dashboard
After this i noticed the 2 metric tables were not created automatically and the dashboard could not be created as these metric tables were missing from the specified path

Re: Metric Tables not created automatically

Cas — Thu, 22 Feb 2024 16:10:53 GMT

Any success/workaround on this topic? I have the same issue

Re: Metric Tables not created automatically

yatharth — Thu, 22 Feb 2024 16:16:46 GMT

For me getting the admin access for the unity catalog solved it, as only admins can create tables, hence if tables are not getting created automatically, I'll suggest to check if you have permission to create any sort of table manually using the UI or code