---
title: "GET /configuredTables/{configuredTableIdentifier}"
method: GET
path: "/configuredTables/{configuredTableIdentifier}"
---

# GET /configuredTables/{configuredTableIdentifier}

`GET /configuredTables/{configuredTableIdentifier}`

Retrieves a configured table.

## Path parameters

- `configuredTableIdentifier` string, required

## Response `200`

Success

- GetConfiguredTableOutput
  - `configuredTable` object, required — The retrieved configured table.
    - `id` string, required — The unique ID for the configured table.
    - `arn` string, required — The unique ARN for the configured table.
    - `name` string, required — A name for the configured table.
    - `description` string — A description for the configured table.
    - `tableReference` object, required — The table that this configured table represents.
      - `glue` object — If present, a reference to the Glue table referred to by this table reference.
        - `region` 'us-west-1' | 'us-west-2' | 'us-east-1' | 'us-east-2' | 'af-south-1' | 'ap-east-1' | 'ap-south-2' | 'ap-southeast-1' | 'ap-southeast-2' | 'ap-southeast-3' | 'ap-southeast-5' | 'ap-southeast-4' | 'ap-southeast-7' | 'ap-south-1' | 'ap-northeast-3' | 'ap-northeast-1' | 'ap-northeast-2' | 'ca-central-1' | 'ca-west-1' | 'eu-south-1' | 'eu-west-3' | 'eu-south-2' | 'eu-central-2' | 'eu-central-1' | 'eu-north-1' | 'eu-west-1' | 'eu-west-2' | 'me-south-1' | 'me-central-1' | 'il-central-1' | 'sa-east-1' | 'mx-central-1' | 'ap-east-2' — The Amazon Web Services Region where the Glue table is located. This parameter is required to uniquely identify and access tables across different Regions.
        - `tableName` string, required — The name of the Glue table.
        - `databaseName` string, required — The name of the database the Glue table belongs to.
      - `snowflake` object — If present, a reference to the Snowflake table referred to by this table reference.
        - `secretArn` string, required — The secret ARN of the Snowflake table reference.
        - `accountIdentifier` string, required — The account identifier for the Snowflake table reference.
        - `databaseName` string, required — The name of the database the Snowflake table belongs to.
        - `tableName` string, required — The name of the Snowflake table.
        - `schemaName` string, required — The schema name of the Snowflake table reference.
        - `tableSchema` object, required — The schema of the Snowflake table.
          - `v1` SnowflakeTableSchemaV1[] — The schema of a Snowflake table.
            - `columnName` string, required — The column name.
            - `columnType` string, required — The column's data type. Supported data types: <code>ARRAY</code>, <code>BIGINT</code>, <code>BOOLEAN</code>, <code>CHAR</code>, <code>DATE</code>, <code>DECIMAL</code>, <code>DOUBLE</code>, <code>DOUBLE PRECISION</code>, <code>FLOAT</code>, <code>FLOAT4</code>, <code>INT</code>, <code>INTEGER</code>, <code>MAP</code>, <code>NUMERIC</code>, <code>NUMBER</code>, <code>REAL</code>, <code>SMALLINT</code>, <code>STRING</code>, <code>TIMESTAMP</code>, <code>TIMESTAMP_LTZ</code>, <code>TIMESTAMP_NTZ</code>, <code>DATETIME</code>, <code>TINYINT</code>, <code>VARCHAR</code>, <code>TEXT</code>, <code>CHARACTER</code>.
      - `athena` object — If present, a reference to the Athena table referred to by this table reference.
        - `region` 'us-west-1' | 'us-west-2' | 'us-east-1' | 'us-east-2' | 'af-south-1' | 'ap-east-1' | 'ap-south-2' | 'ap-southeast-1' | 'ap-southeast-2' | 'ap-southeast-3' | 'ap-southeast-5' | 'ap-southeast-4' | 'ap-southeast-7' | 'ap-south-1' | 'ap-northeast-3' | 'ap-northeast-1' | 'ap-northeast-2' | 'ca-central-1' | 'ca-west-1' | 'eu-south-1' | 'eu-west-3' | 'eu-south-2' | 'eu-central-2' | 'eu-central-1' | 'eu-north-1' | 'eu-west-1' | 'eu-west-2' | 'me-south-1' | 'me-central-1' | 'il-central-1' | 'sa-east-1' | 'mx-central-1' | 'ap-east-2' — The Amazon Web Services Region where the Athena table is located. This parameter is required to uniquely identify and access tables across different Regions.
        - `workGroup` string, required — The workgroup of the Athena table reference.
        - `outputLocation` string — The output location for the Athena table.
        - `databaseName` string, required — The database name.
        - `tableName` string, required — The table reference.
        - `catalogName` string — The catalog name.
    - `createTime` string, date-time, required — The time the configured table was created.
    - `updateTime` string, date-time, required — The time the configured table was last updated
    - `analysisRuleTypes` ConfiguredTableAnalysisRuleType[], required — The types of analysis rules associated with this configured table. Currently, only one analysis rule may be associated with a configured table.
    - `analysisMethod` 'DIRECT_QUERY' | 'DIRECT_JOB' | 'MULTIPLE', required — <p>The analysis method for the configured table.</p> <p> <code>DIRECT_QUERY</code> allows SQL queries to be run directly on this table.</p> <p> <code>DIRECT_JOB</code> allows PySpark jobs to be run directly on this table.</p> <p> <code>MULTIPLE</code> allows both SQL queries and PySpark jobs to be run directly on this table.</p>
    - `allowedColumns` ColumnName[], required — The columns within the underlying Glue table that can be used within collaborations.
    - `selectedAnalysisMethods` SelectedAnalysisMethod[] — The selected analysis methods for the configured table.

## Other responses

- `480` — ResourceNotFoundException
- `481` — InternalServerException
- `482` — ValidationException
- `483` — ThrottlingException
- `484` — AccessDeniedException

---

[API](https://skmtc.net/aws/apis/cleanrooms.md) · [All operations](https://skmtc.net/aws/apis/cleanrooms/llms.txt) · [OpenAPI document](https://skmtc-service-staging.skmtc.workers.dev/v1/apis/aws/cleanrooms/versions/17ce59ba806e/schema)