---
title: "List tables"
method: GET
path: "/api/v2/reference-tables/tables"
tags: ["Reference Tables"]
---

# List tables

`GET /api/v2/reference-tables/tables`

List all reference tables in this organization.

## Query parameters

- `page[limit]` integer
- `page[offset]` integer
- `sort` 'updated_at' | 'table_name' | 'status' | '-updated_at' | '-table_name' | '-status' — Sort field and direction for reference tables. Use field name for ascending, prefix with "-" for descending.
- `filter[status]` string
- `filter[table_name][exact]` string
- `filter[table_name][contains]` string

## Response `200`

OK

- TableResultV2Array — List of reference tables.
  - `data` TableResultV2Data[], required — The reference tables.
    - `attributes` TableResultV2DataAttributes — Attributes that define the reference table's configuration and properties.
      - `created_by` string — UUID of the user who created the reference table.
      - `description` string — Optional text describing the purpose or contents of this reference table.
      - `file_metadata` TableResultV2DataAttributesFileMetadata — Metadata specifying where and how to access the reference table's data file. For cloud storage tables (S3/GCS/Azure): - sync_enabled and access_details will always be present - error fields (error_message, error_row_count, error_type) are present only when errors occur For local file tables: - error fields (error_message, error_row_count) are present only when errors occur - sync_enabled, access_details are never present
        - `access_details` TableResultV2DataAttributesFileMetadataOneOfAccessDetails — Cloud storage access configuration for the reference table data file.
          - `aws_detail` TableResultV2DataAttributesFileMetadataOneOfAccessDetailsAwsDetail — Amazon Web Services S3 storage access configuration.
            - `aws_account_id` string — AWS account ID where the S3 bucket is located.
            - `aws_bucket_name` string — S3 bucket containing the CSV file.
            - `file_path` string — The relative file path from the S3 bucket root to the CSV file.
          - `azure_detail` TableResultV2DataAttributesFileMetadataOneOfAccessDetailsAzureDetail — Azure Blob Storage access configuration.
            - `azure_client_id` string — Azure service principal (application) client ID with permissions to read from the container.
            - `azure_container_name` string — Azure Blob Storage container containing the CSV file.
            - `azure_storage_account_name` string — Azure storage account where the container is located.
            - `azure_tenant_id` string — Azure Active Directory tenant ID.
            - `file_path` string — The relative file path from the Azure container root to the CSV file.
          - `gcp_detail` TableResultV2DataAttributesFileMetadataOneOfAccessDetailsGcpDetail — Google Cloud Platform storage access configuration.
            - `file_path` string — The relative file path from the GCS bucket root to the CSV file.
            - `gcp_bucket_name` string — GCP bucket containing the CSV file.
            - `gcp_project_id` string — GCP project ID where the bucket is located.
            - `gcp_service_account_email` string — Service account email with read permissions for the GCS bucket.
        - `error_message` string — The error message returned from the last operation (sync for cloud storage, upload for local file).
        - `error_row_count` integer — The number of rows that failed to process.
        - `error_type` 'TABLE_SCHEMA_ERROR' | 'FILE_FORMAT_ERROR' | 'CONFIGURATION_ERROR' | 'QUOTA_EXCEEDED' | 'CONFLICT_ERROR' | 'VALIDATION_ERROR' | 'STATE_ERROR' | 'OPERATION_ERROR' | 'SYSTEM_ERROR' — The type of error that occurred during file processing. This field provides high-level error categories for easier troubleshooting and is only present when there are errors.
        - `sync_enabled` boolean — Whether this table is synced automatically from cloud storage. Only applicable for cloud storage sources.
      - `last_updated_by` string — UUID of the user who last updated the reference table.
      - `row_count` integer — The number of successfully processed rows in the reference table.
      - `schema` TableResultV2DataAttributesSchema — Schema defining the structure and columns of the reference table.
        - `fields` TableResultV2DataAttributesSchemaFieldsItems[], required — The schema fields.
          - `name` string, required — The field name.
          - `type` 'STRING' | 'INT32', required — The field type for reference table schema fields.
        - `primary_keys` string[], required — List of field names that serve as primary keys for the table. Only one primary key is supported, and it is used as an ID to retrieve rows.
      - `source` 'LOCAL_FILE' | 'S3' | 'GCS' | 'AZURE' | 'SERVICENOW' | 'SALESFORCE' | 'DATABRICKS' | 'SNOWFLAKE' — The source type for reference table data. Includes all possible source types that can appear in responses.
      - `status` string — The processing status of the table.
      - `table_name` string — Unique name to identify this reference table. Used in enrichment processors and API calls.
      - `tags` string[] — Tags for organizing and filtering reference tables.
      - `updated_at` string — When the reference table was last updated, in ISO 8601 format.
    - `id` string — Unique identifier for the reference table.
    - `type` 'reference_table', required — Reference table resource type.

## Other responses

- `403` — Forbidden
- `429` — Too many requests

---

[API](https://skmtc.net/datadog/apis/api-v2.md) · [All operations](https://skmtc.net/datadog/apis/api-v2/llms.txt) · [OpenAPI document](https://skmtc-service-staging.skmtc.workers.dev/v1/apis/datadog/api-v2/versions/da68bf029e4c/schema)