Data Modeling, Data Warehouse, Databricks Sql, Databricks, Data Governance.
history reveals further details: Relational Model Profile Despite the latter query requiring a join, it’s faster as fewer files have to be scanned. When executing both queries again, one can capitalize on Databricks SQL automatic caching capabilities (see this blog post), effectively reducing