Vector Search System Tables Queries

Databricks Vector Search billing and audit information in Unity Catalog System Tables. The following queries show how to obtain this information

Billing Queries

Retrieving "search" usage (DBUs) per endpoint

• This query uses the system.billing.usage table to retrieve the number of dbus used per Vector Search endpoint in the last 30 days

Retrieving "ingestion" usage (DBUs) per DLT pipeline

• This query uses the system.billing.usage table to retrieve the number of dbus used per Ingestion DLT pipeline id in the last 30 days

Audit Queries

Action audited

• The following query show the Vector Search actions audited

Create Endpoint Action

• This query retrieves the endpoint creation events of the last 30 days

Delete Endpoint Action

• This query retrieves the endpoint deletion events of the last 30 days

Create Index Action

• This query retrieves the index creation events of the last 30 days

Delete Index Action

• This query retrieves the index deletion events of the last 30 days