Hi,
This is generally how dbt profiles.yml works when using it with Databricks Lakeflow Jobs:
When you specify a warehouse, catalog etc, the "Profiles Directory" option is removed because Databricks automatically creates the "profiles.yml" required t...
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