ODBC Driver for Claude Compliance

Build 26.0.9770

ComplianceApiAccessed

Returns only compliance_api_accessed activities, which audit use of the Compliance API.

View-Specific Information

Select

This view always requests the compliance_api_accessed activity type. Type is fixed and cannot be changed in the query.

The actor is always an api_actor. Its documented fields are flattened into ActorType, ActorApiKeyId, ActorIpAddress, and ActorUserAgent.

The driver uses the Claude Compliance API to process WHERE clause conditions built with the following columns and operators server-side. The rest of the filter is processed client-side within the driver.

The API processes supported ordering server-side. Unsupported ordering, grouping, and offsets are processed client-side within the driver. Without an ORDER BY clause, the API returns results newest-first.

ColumnSupported Operators
ActorId=, IN
OrganizationId, OrganizationUuid=, IN
CreatedAt>, >=, <, <=

  • ORDER BY CreatedAt ASC or DESC
  • LIMIT

	SELECT Id, CreatedAt, ActorType, ActorApiKeyId FROM ComplianceApiAccessed WHERE CreatedAt >= '2026-01-01T00:00:00Z' LIMIT 100;
	SELECT * FROM ComplianceApiAccessed WHERE OrganizationUuid = 'abcdef01-2345-6789-abcd-ef0123456789' AND ActorId = 'user_123' LIMIT 100;

Columns

Name Type Description
Id [KEY] String The activity Id.
CreatedAt Datetime Activity time. Filterable with created_at ranges.
OrganizationId String Organization Id filterable via organization_ids.
OrganizationUuid String Organization UUID filterable via organization_ids.
ActorType String The actor union discriminator.
ActorApiKeyId String The API key Id for api_actor.
ActorIpAddress String The source IP address for the actor variant.
ActorUserAgent String The source user agent for the actor variant.
Type String Always compliance_api_accessed.
RequestId String Compliance API request Id.
RequestMethod String HTTP request method.
StatusCode Integer HTTP response status code.
Url String Requested API URL.
RequestBody String Request body as JSON when present.

Pseudocolumns

Pseudocolumn fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.

Name Type Description
ActorId String Filters with actor_ids.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9770