One way to resolve this could be to ensure your connection values in are surrounded by quotes.
host: "hostname.databricks.com" # Requiredhttp_path: "/sql/1.0/warehouses/aaaabbbccc"
You can use System Tables, now available in Unity Catalog metastore, to create the views you described. https://docs.databricks.com/en/admin/system-tables/index.html
