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

# List tables

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

## Request

- Base URL: `https://api.datadoghq.com`
- URL: `https://api.datadoghq.com/api/v2/reference-tables/tables`
- Auth: one of:
  - API key in header `DD-API-KEY` and API key in header `DD-APPLICATION-KEY`
  - OAuth 2
    - Authorization code: `/oauth2/v1/authorize`
    - Token URL: `/oauth2/v1/token`

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.dev/datadog/apis/datadog-api-v2-collection.md) - [All operations](https://skmtc.dev/datadog/apis/datadog-api-v2-collection/llms.txt) - [OpenAPI document](https://skmtc.dev/datadog/apis/datadog-api-v2-collection/revisions/da68bf029e4c?raw)