AWS CLI Command Reference

[ aws . cleanrooms ]

create-configured-table-analysis-rule

Description

Creates a new analysis rule for a configured table. Currently, only one analysis rule can be created for a given configured table.

See also: AWS API Documentation

Synopsis

  create-configured-table-analysis-rule
--configured-table-identifier <value>
--analysis-rule-type <value>
--analysis-rule-policy <value>
[--cli-input-json | --cli-input-yaml]
[--generate-cli-skeleton <value>]
[--debug]
[--endpoint-url <value>]
[--no-verify-ssl]
[--no-paginate]
[--output <value>]
[--query <value>]
[--profile <value>]
[--region <value>]
[--version <value>]
[--color <value>]
[--no-sign-request]
[--ca-bundle <value>]
[--cli-read-timeout <value>]
[--cli-connect-timeout <value>]
[--cli-binary-format <value>]
[--no-cli-pager]
[--cli-auto-prompt]
[--no-cli-auto-prompt]

Options

--configured-table-identifier (string)

The identifier for the configured table to create the analysis rule for. Currently accepts the configured table ID.

--analysis-rule-type (string)

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

Possible values:

  • AGGREGATION

  • LIST

--analysis-rule-policy (tagged union structure)

The entire created configured table analysis rule object.

Note

This is a Tagged Union structure. Only one of the following top level keys can be set: v1.

v1 -> (tagged union structure)

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 can be set: list, aggregation.

list -> (structure)

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

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.

(structure)

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.

(structure)

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.

JSON Syntax:

{
  "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": integer,
          "type": "COUNT_DISTINCT"
        }
        ...
      ]
    }
  }
}

--cli-input-json | --cli-input-yaml (string) Reads arguments from the JSON string provided. The JSON string follows the format provided by --generate-cli-skeleton. If other arguments are provided on the command line, those values will override the JSON-provided values. It is not possible to pass arbitrary binary values using a JSON-provided value as the string will be taken literally. This may not be specified along with --cli-input-yaml.

--generate-cli-skeleton (string) Prints a JSON skeleton to standard output without sending an API request. If provided with no value or the value input, prints a sample input JSON that can be used as an argument for --cli-input-json. Similarly, if provided yaml-input it will print a sample input YAML that can be used with --cli-input-yaml. If provided with the value output, it validates the command inputs and returns a sample output JSON for that command. The generated JSON skeleton is not stable between versions of the AWS CLI and there are no backwards compatibility guarantees in the JSON skeleton generated.

Global Options

--debug (boolean)

Turn on debug logging.

--endpoint-url (string)

Override command’s default URL with the given URL.

--no-verify-ssl (boolean)

By default, the AWS CLI uses SSL when communicating with AWS services. For each SSL connection, the AWS CLI will verify SSL certificates. This option overrides the default behavior of verifying SSL certificates.

--no-paginate (boolean)

Disable automatic pagination.

--output (string)

The formatting style for command output.

  • json

  • text

  • table

  • yaml

  • yaml-stream

--query (string)

A JMESPath query to use in filtering the response data.

--profile (string)

Use a specific profile from your credential file.

--region (string)

The region to use. Overrides config/env settings.

--version (string)

Display the version of this tool.

--color (string)

Turn on/off color output.

  • on

  • off

  • auto

--no-sign-request (boolean)

Do not sign requests. Credentials will not be loaded if this argument is provided.

--ca-bundle (string)

The CA certificate bundle to use when verifying SSL certificates. Overrides config/env settings.

--cli-read-timeout (int)

The maximum socket read time in seconds. If the value is set to 0, the socket read will be blocking and not timeout. The default value is 60 seconds.

--cli-connect-timeout (int)

The maximum socket connect time in seconds. If the value is set to 0, the socket connect will be blocking and not timeout. The default value is 60 seconds.

--cli-binary-format (string)

The formatting style to be used for binary blobs. The default format is base64. The base64 format expects binary blobs to be provided as a base64 encoded string. The raw-in-base64-out format preserves compatibility with AWS CLI V1 behavior and binary values must be passed literally. When providing contents from a file that map to a binary blob fileb:// will always be treated as binary and use the file contents directly regardless of the cli-binary-format setting. When using file:// the file contents will need to properly formatted for the configured cli-binary-format.

  • base64

  • raw-in-base64-out

--no-cli-pager (boolean)

Disable cli pager for output.

--cli-auto-prompt (boolean)

Automatically prompt for CLI input parameters.

--no-cli-auto-prompt (boolean)

Disable automatically prompt for CLI input parameters.

Output

analysisRule -> (structure)

The entire created analysis rule.

configuredTableId -> (string)

The unique ID for the configured table.

configuredTableArn -> (string)

The unique ARN for the configured table.

policy -> (tagged union structure)

The policy that controls SQL query rules.

Note

This is a Tagged Union structure. Only one of the following top level keys can be set: v1.

v1 -> (tagged union structure)

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 can be set: list, aggregation.

list -> (structure)

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

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.

(structure)

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.

(structure)

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

The time the configured table analysis rule was created.

updateTime -> (timestamp)

The time the configured table analysis rule was last updated.

© Copyright 2018, Amazon Web Services. Created using Sphinx.