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