Metric Tables not created automatically
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-19-2024 08:21 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-22-2024 08:10 AM
Any success/workaround on this topic? I have the same issue
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-22-2024 08:16 AM
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

