Zoom Logs connector reference

Important

This feature is in Beta. Workspace admins can control access to this feature from the Previews page. See Manage Azure Databricks previews.

This page has reference information for the managed Zoom Logs connector, including supported source tables and destination table schemas.

Supported source tables

The Zoom Logs connector supports the following source tables, all under the default source schema:

Source table	Primary key	Description	Sync mode	Cursor field
activity_logs	lw_id	User sign-in and sign-out activity for users in your Zoom account.	Incremental	time
operation_logs	lw_id	Admin and user activity, including adding users, changing account settings, and deleting recordings.	Incremental	time

The connector liquid clusters both destination tables on the time column for efficient time-range queries.

Destination table schemas

activity_logs

Field	Data type
lw_id	string
time	timestamp
type	string
email	string
ip_address	string
client_type	string
version	string

operation_logs

Field	Data type
lw_id	string
time	timestamp
operator	string
category_type	string
action	string
operation_detail	string

For more information about each field, see the Sign In/Sign Out Activity Report and Operation Log Report API references.

Required OAuth scopes

The connector requires the following Zoom granular OAuth scopes:

Scope	Required for
report:read:user_activities:admin	activity_logs
report:read:operation_logs:admin	operation_logs

Required Zoom account permissions

The Zoom user account used to create the OAuth app must have the following role permissions. Verify them on the Zoom roles page by clicking Admin to view Role Settings.

Permission	Required for
Usage reports view	Baseline access to Zoom report APIs.
Admin Activity Logs view	operation_logs
Sign In/Sign Out view	activity_logs