Monitoring

This page covers how to set up operational monitoring for your Marketplace listings and Delta Sharing activity. For details on the underlying system tables, see Listing analytics and Audit logs.

Alerting

The following are examples of monitoring queries you can build. Use them as SQL Alerts, embed in dashboards, power AI agents, or run in scheduled notebooks.

You can also monitor programmatically using the Databricks SDK or REST API to list shares, recipients, and permissions. See Workflow and automation for examples.

For exact column names and schema details, see Audit log system table, Marketplace system tables, and Information Schema.

Token expiration

Alert before open sharing tokens expire. Uses the RECIPIENT_TOKENS information schema view:

SELECT
  recipient_name,
  expiration_time,
  DATEDIFF(expiration_time, CURRENT_DATE) AS days_until_expiration
FROM system.information_schema.recipient_tokens
WHERE DATEDIFF(expiration_time, CURRENT_DATE) < 30
ORDER BY days_until_expiration ASC;

Recipients without recent activity

List all recipients and their token status. Useful for identifying candidates for cleanup:

SELECT
  recipient_name,
  created,
  expiration_time
FROM system.information_schema.recipient_tokens
ORDER BY created DESC;

Share inventory

Audit all shares and their contents using the SHARES and SHARE_OBJECTS information schema views:

SELECT
  s.share_name,
  s.created,
  s.comment,
  COUNT(so.name) AS object_count
FROM system.information_schema.shares s
LEFT JOIN system.information_schema.share_objects so
  ON s.share_name = so.share_name
GROUP BY s.share_name, s.created, s.comment
ORDER BY s.created DESC;

Recipient permissions

Review which recipients have access to which shares using SHARE_RECIPIENT_PRIVILEGES:

SELECT
  share_name,
  recipient_name,
  privilege_type,
  inherited_from
FROM system.information_schema.share_recipient_privileges
ORDER BY share_name, recipient_name;

Dashboards

Provider Console dashboard

The Marketplace Dashboard in the Provider Console provides:

• Listing views and impressions
• Access requests and fulfillment rates
• Active recipients
• Conversion metrics

Custom dashboards

For deeper analysis, build dashboards on system tables using Databricks SQL:

Metric	Source table
Listing funnel	system.marketplace.listing_funnel_events
Access requests	system.marketplace.listing_access_events
Share usage	system.access.audit

See Marketplace system tables and Audit logs for schema details.

Scheduling alerts

Use Databricks SQL Alerts to run monitoring queries on a schedule:

1. Create a SQL query with your monitoring logic
2. Set the alert condition (e.g., "rows returned > 0")
3. Configure notification destination (email, Slack, webhook)
4. Set refresh schedule (hourly, daily)

See SQL Alerts for setup instructions.

What's next

• Review the operations runbook for governance best practices
• Learn about access management for fulfillment workflows
• See listing analytics for funnel metrics