CleanRoomsService / Client / get_configured_table

get_configured_table#

CleanRoomsService.Client.get_configured_table(**kwargs)#

Retrieves a configured table.

See also: AWS API Documentation

Request Syntax

response = client.get_configured_table(
    configuredTableIdentifier='string'
)
Parameters:

configuredTableIdentifier (string) –

[REQUIRED]

The unique ID for the configured table to retrieve.

Return type:

dict

Returns:

Response Syntax

{
    'configuredTable': {
        'id': 'string',
        'arn': 'string',
        'name': 'string',
        'description': 'string',
        'tableReference': {
            'glue': {
                'tableName': 'string',
                'databaseName': 'string'
            },
            'snowflake': {
                'secretArn': 'string',
                'accountIdentifier': 'string',
                'databaseName': 'string',
                'tableName': 'string',
                'schemaName': 'string',
                'tableSchema': {
                    'v1': [
                        {
                            'columnName': 'string',
                            'columnType': 'string'
                        },
                    ]
                }
            },
            'athena': {
                'workGroup': 'string',
                'outputLocation': 'string',
                'databaseName': 'string',
                'tableName': 'string'
            }
        },
        'createTime': datetime(2015, 1, 1),
        'updateTime': datetime(2015, 1, 1),
        'analysisRuleTypes': [
            'AGGREGATION'|'LIST'|'CUSTOM',
        ],
        'analysisMethod': 'DIRECT_QUERY',
        'allowedColumns': [
            'string',
        ]
    }
}

Response Structure

  • (dict) –

    • configuredTable (dict) –

      The retrieved configured table.

      • id (string) –

        The unique ID for the configured table.

      • arn (string) –

        The unique ARN for the configured table.

      • name (string) –

        A name for the configured table.

      • description (string) –

        A description for the configured table.

      • tableReference (dict) –

        The table that this configured table represents.

        Note

        This is a Tagged Union structure. Only one of the following top level keys will be set: glue, snowflake, athena. If a client receives an unknown member it will set SDK_UNKNOWN_MEMBER as the top level key, which maps to the name or tag of the unknown member. The structure of SDK_UNKNOWN_MEMBER is as follows:

        'SDK_UNKNOWN_MEMBER': {'name': 'UnknownMemberName'}

        • glue (dict) –

          If present, a reference to the Glue table referred to by this table reference.

          • tableName (string) –

            The name of the Glue table.

          • databaseName (string) –

            The name of the database the Glue table belongs to.

        • snowflake (dict) –

          If present, a reference to the Snowflake table referred to by this table reference.

          • secretArn (string) –

            The secret ARN of the Snowflake table reference.

          • accountIdentifier (string) –

            The account identifier for the Snowflake table reference.

          • databaseName (string) –

            The name of the database the Snowflake table belongs to.

          • tableName (string) –

            The name of the Snowflake table.

          • schemaName (string) –

            The schema name of the Snowflake table reference.

          • tableSchema (dict) –

            The schema of the Snowflake table.

            Note

            This is a Tagged Union structure. Only one of the following top level keys will be set: v1. If a client receives an unknown member it will set SDK_UNKNOWN_MEMBER as the top level key, which maps to the name or tag of the unknown member. The structure of SDK_UNKNOWN_MEMBER is as follows:

            'SDK_UNKNOWN_MEMBER': {'name': 'UnknownMemberName'}

            • v1 (list) –

              The schema of a Snowflake table.

              • (dict) –

                The Snowflake table schema.

                • columnName (string) –

                  The column name.

                • columnType (string) –

                  The column’s data type. Supported data types: ARRAY, BIGINT, BOOLEAN, CHAR, DATE, DECIMAL, DOUBLE, DOUBLE PRECISION, FLOAT, FLOAT4, INT, INTEGER, MAP, NUMERIC, NUMBER, REAL, SMALLINT, STRING, TIMESTAMP, TIMESTAMP_LTZ, TIMESTAMP_NTZ, DATETIME, TINYINT, VARCHAR, TEXT, CHARACTER.

        • athena (dict) –

          If present, a reference to the Athena table referred to by this table reference.

          • workGroup (string) –

            The workgroup of the Athena table reference.

          • outputLocation (string) –

            The output location for the Athena table.

          • databaseName (string) –

            The database name.

          • tableName (string) –

            The table reference.

      • createTime (datetime) –

        The time the configured table was created.

      • updateTime (datetime) –

        The time the configured table was last updated

      • analysisRuleTypes (list) –

        The types of analysis rules associated with this configured table. Currently, only one analysis rule may be associated with a configured table.

        • (string) –

      • analysisMethod (string) –

        The analysis method for the configured table. The only valid value is currently DIRECT_QUERY.

      • allowedColumns (list) –

        The columns within the underlying Glue table that can be utilized within collaborations.

        • (string) –

Exceptions