Hi @smpa011,

Metric views work on both SQL warehouse and classic clusters, but the cluster must be running DBR 17.2 or above. The error you are getting is because you may be using DBR version below 17.2 or so. try upgrading your DBR version or use SQL warehouse(classic, pro or serverless). check prerequisites in below link.

Regarding you 2nd question i think current there metric views don't offer ERD -style graphical visualization of yaml structure itself but the closest you get is lineage graph showing upstream/downstream dependencies.

Hope this clarifies!

Use SQL to create and manage metric views | Databricks on AWS