AWS CLI Command Reference

Note:

You are viewing the documentation for an older major version of the AWS CLI (version 1). To view this page for the AWS CLI version 2, click here.

We announced the upcoming end-of-support for the AWS CLI v1. For dates, additional details, and information on how to migrate, please refer to the linked announcement. For more information see the AWS CLI version 2 installation instructions and migration guide.

[ aws . cleanrooms ]

get-intermediate-table

Description

Retrieves an intermediate table. Returns the full details of the intermediate table, including schema, table dependencies, inherited constraints, child resources, and status. Only the intermediate table owner can call this operation.

See also: AWS API Documentation

Synopsis

  get-intermediate-table
--intermediate-table-identifier <value>
--membership-identifier <value>
[--cli-input-json <value>]
[--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>]
[--v2-debug]

Options

--intermediate-table-identifier (string)

The unique identifier of the intermediate table to retrieve.

--membership-identifier (string)

The unique identifier of the membership that contains the intermediate table.

--cli-input-json (string) Performs service operation based on the JSON string provided. The JSON string follows the format provided by --generate-cli-skeleton. If other arguments are provided on the command line, the CLI 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.

--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. If provided with the value output, it validates the command inputs and returns a sample output JSON for that command.

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. If automatic pagination is disabled, the AWS CLI will only make one call, for the first page of results.

--output (string)

The formatting style for command output.

  • json
  • text
  • table

--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.

--v2-debug (boolean)

Enable AWS CLI v2 migration assistance. Prints warnings if the command would face a breaking change after swapping AWS CLI v1 for AWS CLI v2 in the current environment. Prints one warning for each breaking change detected.

Output

intermediateTable -> (structure)

The intermediate table retrieved.

id -> (string)

The unique identifier of the intermediate table.

arn -> (string)

The Amazon Resource Name (ARN) of the intermediate table.

name -> (string)

The name of the intermediate table.

description -> (string)

The description of the intermediate table.

membershipArn -> (string)

The Amazon Resource Name (ARN) of the membership that contains the intermediate table.

membershipId -> (string)

The unique identifier of the membership that contains the intermediate table.

collaborationArn -> (string)

The Amazon Resource Name (ARN) of the collaboration that contains the intermediate table.

collaborationId -> (string)

The unique identifier of the collaboration that contains the intermediate table.

childResources -> (list)

The child resources that depend on this intermediate table.

(structure)

Contains information about a child resource of a given resource in a collaboration.

resourceId -> (string)

The unique identifier of the child resource.

resourceType -> (string)

The type of the child resource.

resourceName -> (string)

The name of the child resource.

ownerAccountId -> (string)

The Amazon Web Services account ID of the member who owns the child resource.

resourceStatus -> (string)

The current status of the child resource.

createTime -> (timestamp)

The time the intermediate table was created.

updateTime -> (timestamp)

The time the intermediate table was last updated.

status -> (string)

The current status of the intermediate table.

statusReason -> (string)

The reason for the current status of the intermediate table.

kmsKeyArn -> (string)

The Amazon Resource Name (ARN) of the KMS key used to encrypt the intermediate table data.

populationAnalysisConfiguration -> (tagged union structure)

The analysis configuration that defines the query used to populate the intermediate table.

Note

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

sqlParameters -> (structure)

The SQL parameters for the population analysis, including the query string or analysis template ARN.

queryString -> (string)

The SQL query string used to populate the intermediate table. Maximum length of 500,000 characters.

analysisTemplateArn -> (string)

The Amazon Resource Name (ARN) of the analysis template to use for populating the intermediate table.

retentionInDays -> (integer)

The number of days that populated data is retained before expiring.

tableDependencies -> (list)

The list of base tables that this intermediate table depends on.

(structure)

Contains information about a base table that an intermediate table depends on.

id -> (string)

The unique identifier of the dependency table.

name -> (string)

The name of the dependency table.

type -> (string)

The type of the dependency table.

parentType -> (string)

Whether the dependency is direct or indirect. A direct dependency is a table explicitly referenced in the stored query, while an indirect dependency is referenced through another intermediate table.

creatorAccountId -> (string)

The Amazon Web Services account ID of the member who owns the dependency table.

intermediateTableVersion -> (structure)

The details of the currently active version of the intermediate table.

versionId -> (string)

The unique identifier of the active version.

analysisId -> (string)

The identifier of the protected query that created this version.

analysisType -> (string)

The type of analysis that created this version.

kmsKeyArn -> (string)

The Amazon Resource Name (ARN) of the KMS key used to encrypt this version’s data.

parameters -> (map)

The runtime parameters that were used when populating this version.

key -> (string)

value -> (string)

inheritedConstraints -> (structure)

The privacy constraints inherited from parent tables at the time this version was populated.

additionalAnalyses -> (structure)

The inherited additional analyses constraint.

value -> (string)

The effective additional analyses setting inherited from parent tables.

sources -> (list)

The list of parent tables that contribute to this inherited constraint.

(structure)

Contains information about a parent table that contributes an additional analyses constraint.

name -> (string)

The name of the parent table.

id -> (string)

The unique identifier of the parent table.

type -> (string)

The type of the parent table.

value -> (string)

The additional analyses setting defined on the parent table.

sourceAccountId -> (string)

The Amazon Web Services account ID of the member who owns the parent table.

allowedAdditionalAnalyses -> (structure)

The inherited allowed additional analyses constraint.

value -> (list)

The effective list of allowed additional analyses inherited from parent tables.

(string)

sources -> (list)

The list of parent tables that contribute to this inherited constraint.

(structure)

Contains information about a parent table that contributes an allowed additional analyses constraint.

name -> (string)

The name of the parent table.

id -> (string)

The unique identifier of the parent table.

type -> (string)

The type of the parent table.

value -> (list)

The allowed additional analyses defined on the parent table.

(string)

sourceAccountId -> (string)

The Amazon Web Services account ID of the member who owns the parent table.

allowedResultReceivers -> (structure)

The inherited allowed result receivers constraint.

value -> (list)

The effective list of Amazon Web Services account IDs allowed to receive results, inherited from parent tables.

(string)

sources -> (list)

The list of parent tables that contribute to this inherited constraint.

(structure)

Contains information about a parent table that contributes an allowed result receivers constraint.

name -> (string)

The name of the parent table.

id -> (string)

The unique identifier of the parent table.

type -> (string)

The type of the parent table.

value -> (list)

The allowed result receiver account IDs defined on the parent table.

(string)

sourceAccountId -> (string)

The Amazon Web Services account ID of the member who owns the parent table.

disallowedOutputColumns -> (structure)

The inherited disallowed output columns constraint.

value -> (list)

The list of column names that are disallowed from appearing in query output, inherited from parent tables.

(string)

columnLineage -> (list)

The lineage information that traces each disallowed output column back to its source in a parent table.

(structure)

Contains column lineage information that traces a disallowed output column back to its source in a base table.

column -> (string)

The name of the column in the intermediate table.

sourceColumn -> (string)

The name of the column in the source table.

sourceName -> (string)

The name of the source table.

sourceId -> (string)

The unique identifier of the source table.

sourceType -> (string)

The type of the source table.

sourceAccountId -> (string)

The Amazon Web Services account ID of the owner of the source table.

expirationTime -> (timestamp)

The time when this version expires based on the retention period.

analysisRuleTypes -> (list)

The types of analysis rules associated with the intermediate table.

(string)

schema -> (structure)

The schema of the intermediate table, containing column definitions. Available after the table has been successfully populated.

columns -> (list)

The list of columns in the intermediate table schema.

(structure)

A column within a schema relation, derived from the underlying table.

name -> (string)

The name of the column.

type -> (string)

The type of the column.