Databricks System Tables — An Introduction

System tables in Databricks serve as an analytical repository for operational data related to your account. They offer historical observability and can be highly useful for tracking various aspects of your Databricks environment. Currently, Databricks provides system tables for audit logs, billable usage logs, as well as table and column lineage. The audit logs can be accessed at <code>system.access.audit</code>, billable usage logs at <code>system.billing.usage</code> with associated list pricing available at <code>system.billing.list_prices</code>, and the table and column lineage information is available in tables under <code>system.access</code>. These system tables provide valuable insights into the activities, resource utilization, and data lineage within your Databricks account and can be used for historical KPI tracking, monitoring and alerting, and forecasting expected usage for an intelligent Lakehouse. <a href="https://medium.com/@24chynoweth/databricks-system-tables-an-introduction-e11a06872405">Website</a>