get_configured_table_analysis_rule

get_configured_table_analysis_rule(**kwargs)

Retrieves a configured table analysis rule.

See also: AWS API Documentation

Request Syntax

response = client.get_configured_table_analysis_rule(
    configuredTableIdentifier='string',
    analysisRuleType='AGGREGATION'|'LIST'
)

Parameters

• configuredTableIdentifier (string) --

  [REQUIRED]

  The unique identifier for the configured table to retrieve. Currently accepts the configured table ID.

• analysisRuleType (string) --

  [REQUIRED]

  The analysis rule to be retrieved. Configured table analysis rules are uniquely identified by their configured table identifier and analysis rule type.

Return type

dict

Returns

Response Syntax

{
    'analysisRule': {
        'configuredTableId': 'string',
        'configuredTableArn': 'string',
        'policy': {
            'v1': {
                'list': {
                    'joinColumns': [
                        'string',
                    ],
                    'listColumns': [
                        'string',
                    ]
                },
                'aggregation': {
                    'aggregateColumns': [
                        {
                            'columnNames': [
                                'string',
                            ],
                            'function': 'SUM'|'SUM_DISTINCT'|'COUNT'|'COUNT_DISTINCT'|'AVG'
                        },
                    ],
                    'joinColumns': [
                        'string',
                    ],
                    'joinRequired': 'QUERY_RUNNER',
                    'dimensionColumns': [
                        'string',
                    ],
                    'scalarFunctions': [
                        'TRUNC'|'ABS'|'CEILING'|'FLOOR'|'LN'|'LOG'|'ROUND'|'SQRT'|'CAST'|'LOWER'|'RTRIM'|'UPPER'|'COALESCE',
                    ],
                    'outputConstraints': [
                        {
                            'columnName': 'string',
                            'minimum': 123,
                            'type': 'COUNT_DISTINCT'
                        },
                    ]
                }
            }
        },
        'type': 'AGGREGATION'|'LIST',
        'createTime': datetime(2015, 1, 1),
        'updateTime': datetime(2015, 1, 1)
    }
}

Response Structure

• (dict) --

  • analysisRule (dict) --

    The entire analysis rule output.

    • configuredTableId (string) --

      The unique ID for the configured table.

    • configuredTableArn (string) --

      The unique ARN for the configured table.

    • policy (dict) --

      The policy that controls SQL query rules.

      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 (dict) --

        Controls on the query specifications that can be run on a configured table.

        Note

        This is a Tagged Union structure. Only one of the following top level keys will be set: list, aggregation. 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'}
        

        • list (dict) --

          Analysis rule type that enables only list queries on a configured table.

          • joinColumns (list) --

            Columns that can be used to join a configured table with the table of the member who can query and another members' configured tables.

            • (string) --

          • listColumns (list) --

            Columns that can be listed in the output.

            • (string) --

        • aggregation (dict) --

          Analysis rule type that enables only aggregation queries on a configured table.

          • aggregateColumns (list) --

            The columns that query runners are allowed to use in aggregation queries.

            • (dict) --

              Column in configured table that can be used in aggregate function in query.

              • columnNames (list) --

                Column names in configured table of aggregate columns.

                • (string) --

              • function (string) --

                Aggregation function that can be applied to aggregate column in query.

          • joinColumns (list) --

            Columns in configured table that can be used in join statements and/or as aggregate columns. They can never be outputted directly.

            • (string) --

          • joinRequired (string) --

            Control that requires member who runs query to do a join with their configured table and/or other configured table in query

          • dimensionColumns (list) --

            The columns that query runners are allowed to select, group by, or filter by.

            • (string) --

          • scalarFunctions (list) --

            Set of scalar functions that are allowed to be used on dimension columns and the output of aggregation of metrics.

            • (string) --

          • outputConstraints (list) --

            Columns that must meet a specific threshold value (after an aggregation function is applied to it) for each output row to be returned.

            • (dict) --

              Constraint on query output removing output rows that do not meet a minimum number of distinct values of a specified column.

              • columnName (string) --

                Column in aggregation constraint for which there must be a minimum number of distinct values in an output row for it to be in the query output.

              • minimum (integer) --

                The minimum number of distinct values that an output row must be an aggregation of. Minimum threshold of distinct values for a specified column that must exist in an output row for it to be in the query output.

              • type (string) --

                The type of aggregation the constraint allows. The only valid value is currently COUNT_DISTINCT.

    • type (string) --

      The type of configured table analysis rule. Valid values are AGGREGATION and LIST.

    • createTime (datetime) --

      The time the configured table analysis rule was created.

    • updateTime (datetime) --

      The time the configured table analysis rule was last updated.

Exceptions

• CleanRoomsService.Client.exceptions.ResourceNotFoundException
• CleanRoomsService.Client.exceptions.InternalServerException
• CleanRoomsService.Client.exceptions.ValidationException
• CleanRoomsService.Client.exceptions.ThrottlingException
• CleanRoomsService.Client.exceptions.AccessDeniedException