--- title: "PATCH /memberships/{membershipIdentifier}/intermediateTables/{intermediateTableIdentifier}" method: PATCH path: "/memberships/{membershipIdentifier}/intermediateTables/{intermediateTableIdentifier}" --- # PATCH /memberships/{membershipIdentifier}/intermediateTables/{intermediateTableIdentifier} `PATCH /memberships/{membershipIdentifier}/intermediateTables/{intermediateTableIdentifier}` Updates an intermediate table. You can update the description, KMS key ARN, and column types of existing columns. Only the intermediate table owner can call this operation. ## Path parameters - `intermediateTableIdentifier` string, required - `membershipIdentifier` string, required ## Request body - object - `description` string — A new description for the intermediate table. - `kmsKeyArn` string — The Amazon Resource Name (ARN) of the customer-managed KMS key to use for encrypting future population data. - `columns` IntermediateTableColumn[] — The list of columns with updated type definitions. Only the type of existing columns can be updated. - `name` string, required — The name of the column. - `type` string, required — The data type of the column. ## Response `200` Success - UpdateIntermediateTableOutput - `intermediateTable` object, required — The updated intermediate table. - `id` string, required — The unique identifier of the intermediate table. - `arn` string, required — The Amazon Resource Name (ARN) of the intermediate table. - `name` string, required — The name of the intermediate table. - `description` string — The description of the intermediate table. - `membershipArn` string, required — The Amazon Resource Name (ARN) of the membership that contains the intermediate table. - `membershipId` string, required — The unique identifier of the membership that contains the intermediate table. - `collaborationArn` string, required — The Amazon Resource Name (ARN) of the collaboration that contains the intermediate table. - `collaborationId` string, required — The unique identifier of the collaboration that contains the intermediate table. - `childResources` ChildResource[] — The child resources that depend on this intermediate table. - `resourceId` string — The unique identifier of the child resource. - `resourceType` 'INTERMEDIATE_TABLE', required — The type of the child resource. - `resourceName` string, required — The name of the child resource. - `ownerAccountId` string, required — The Amazon Web Services account ID of the member who owns the child resource. - `resourceStatus` 'CREATED' | 'POPULATE_STARTED' | 'POPULATE_SUCCESS' | 'POPULATE_FAILED' | 'DISALLOWED_BY_DATA_PROVIDER' | 'BASE_TABLE_REMOVED' | 'RETENTION_PERIOD_EXPIRED' — The current status of the child resource. - `createTime` string, date-time, required — The time the intermediate table was created. - `updateTime` string, date-time, required — The time the intermediate table was last updated. - `status` 'CREATED' | 'POPULATE_STARTED' | 'POPULATE_SUCCESS' | 'POPULATE_FAILED' | 'DISALLOWED_BY_DATA_PROVIDER' | 'BASE_TABLE_REMOVED' | 'RETENTION_PERIOD_EXPIRED', required — 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` object, required — The analysis configuration that defines the query used to populate the intermediate table. - `sqlParameters` object — 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` IntermediateTableDependency[] — The list of base tables that this intermediate table depends on. - `id` string, required — The unique identifier of the dependency table. - `name` string, required — The name of the dependency table. - `type` 'TABLE' | 'INTERMEDIATE_TABLE' | 'ID_MAPPING_TABLE', required — The type of the dependency table. - `parentType` 'DIRECT' | 'INDIRECT', required — 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, required — The Amazon Web Services account ID of the member who owns the dependency table. - `intermediateTableVersion` object — The details of the currently active version of the intermediate table. - `versionId` string, required — The unique identifier of the active version. - `analysisId` string, required — The identifier of the protected query that created this version. - `analysisType` 'QUERY', required — 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` object — The runtime parameters that were used when populating this version. - `inheritedConstraints` object, required — The privacy constraints inherited from parent tables at the time this version was populated. - `additionalAnalyses` object — The inherited additional analyses constraint. - `value` 'ALLOWED' | 'REQUIRED' | 'NOT_ALLOWED', required — The effective additional analyses setting inherited from parent tables. - `sources` InheritedAdditionalAnalysesSource[], required — The list of parent tables that contribute to this inherited constraint. - `name` string, required — The name of the parent table. - `id` string, required — The unique identifier of the parent table. - `type` 'TABLE' | 'INTERMEDIATE_TABLE' | 'ID_MAPPING_TABLE', required — The type of the parent table. - `value` 'ALLOWED' | 'REQUIRED' | 'NOT_ALLOWED', required — The additional analyses setting defined on the parent table. - `sourceAccountId` string, required — The Amazon Web Services account ID of the member who owns the parent table. - `allowedAdditionalAnalyses` object — The inherited allowed additional analyses constraint. - `value` AdditionalAnalysesResourceArn[], required — The effective list of allowed additional analyses inherited from parent tables. - `sources` InheritedAllowedAdditionalAnalysesSource[], required — The list of parent tables that contribute to this inherited constraint. - `name` string, required — The name of the parent table. - `id` string, required — The unique identifier of the parent table. - `type` 'TABLE' | 'INTERMEDIATE_TABLE' | 'ID_MAPPING_TABLE', required — The type of the parent table. - `value` AdditionalAnalysesResourceArn[], required — The allowed additional analyses defined on the parent table. - `sourceAccountId` string, required — The Amazon Web Services account ID of the member who owns the parent table. - `allowedResultReceivers` object — The inherited allowed result receivers constraint. - `value` AccountId[], required — The effective list of Amazon Web Services account IDs allowed to receive results, inherited from parent tables. - `sources` InheritedAllowedResultReceiversSource[], required — The list of parent tables that contribute to this inherited constraint. - `name` string, required — The name of the parent table. - `id` string, required — The unique identifier of the parent table. - `type` 'TABLE' | 'INTERMEDIATE_TABLE' | 'ID_MAPPING_TABLE', required — The type of the parent table. - `value` AccountId[], required — The allowed result receiver account IDs defined on the parent table. - `sourceAccountId` string, required — The Amazon Web Services account ID of the member who owns the parent table. - `disallowedOutputColumns` object — The inherited disallowed output columns constraint. - `value` AnalysisRuleColumnName[], required — The list of column names that are disallowed from appearing in query output, inherited from parent tables. - `columnLineage` ColumnLineageEntry[], required — The lineage information that traces each disallowed output column back to its source in a parent table. - `column` string, required — The name of the column in the intermediate table. - `sourceColumn` string, required — The name of the column in the source table. - `sourceName` string, required — The name of the source table. - `sourceId` string, required — The unique identifier of the source table. - `sourceType` 'TABLE' | 'INTERMEDIATE_TABLE' | 'ID_MAPPING_TABLE', required — The type of the source table. - `sourceAccountId` string, required — The Amazon Web Services account ID of the owner of the source table. - `expirationTime` string, date-time — The time when this version expires based on the retention period. - `analysisRuleTypes` IntermediateTableAnalysisRuleType[] — The types of analysis rules associated with the intermediate table. - `schema` object — The schema of the intermediate table, containing column definitions. Available after the table has been successfully populated. - `columns` Column[], required — The list of columns in the intermediate table schema. - `name` string, required — The name of the column. - `type` string, required — The type of the column. ## 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)