---
title: "GET /memberships/{membershipIdentifier}/intermediateTables"
method: GET
path: "/memberships/{membershipIdentifier}/intermediateTables"
---

# GET /memberships/{membershipIdentifier}/intermediateTables

`GET /memberships/{membershipIdentifier}/intermediateTables`

Lists intermediate tables owned by the caller in a membership. We recommend using pagination to ensure that the operation returns quickly and successfully.

## Path parameters

- `membershipIdentifier` string, required

## Query parameters

- `nextToken` string
- `maxResults` integer

## Response `200`

Success

- ListIntermediateTablesOutput
  - `intermediateTableSummaries` IntermediateTableSummary[], required — The list of intermediate table summaries.
    - `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.
    - `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.
    - `retentionInDays` integer — The number of days that populated data is retained before expiring.
    - `analysisRuleTypes` IntermediateTableAnalysisRuleType[] — The types of analysis rules associated with the intermediate table.
  - `nextToken` string — The pagination token that's used to fetch the next set of results.

## 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)