---
title: "POST /memberships/{membershipIdentifier}/intermediateTables/{intermediateTableIdentifier}/populate"
method: POST
path: "/memberships/{membershipIdentifier}/intermediateTables/{intermediateTableIdentifier}/populate"
---

# POST /memberships/{membershipIdentifier}/intermediateTables/{intermediateTableIdentifier}/populate

`POST /memberships/{membershipIdentifier}/intermediateTables/{intermediateTableIdentifier}/populate`

Executes the stored query of an intermediate table to materialize data into managed storage. With this operation, you can perform initial population and subsequent refreshes. Each call creates a new version. The returned analysis ID can be tracked using <code>GetProtectedQuery</code>. Only the intermediate table owner can call this operation.

## Path parameters

- `intermediateTableIdentifier` string, required
- `membershipIdentifier` string, required

## Request body

- object
  - `parameters` object — The runtime parameter values that override the defaults in the stored query.
  - `computeConfiguration` object — The compute configuration for an intermediate table population operation.
    - `queryComputeConfiguration` WorkerComputeConfiguration — The configuration of the compute resources for workers running an analysis with the Clean Rooms SQL analytics engine.
      - `type` 'CR.1X' | 'CR.4X' — The worker compute configuration type.
      - `number` integer — <p> The number of workers.</p> <p>SQL queries support a minimum value of 2 and a maximum value of 400. </p> <p>PySpark jobs support a minimum value of 4 and a maximum value of 128.</p>
      - `properties` unknown
  - `analysisPayerAccountId` string — The account ID of the member that pays for the analysis compute costs.

## Response `200`

Success

- PopulateIntermediateTableOutput
  - `analysisId` string, required — The identifier for the protected query execution. Use this value with <code>GetProtectedQuery</code> to track the population progress.
  - `analysisType` 'QUERY', required — The type of analysis performed to populate the intermediate table.
  - `versionId` string, required — The unique identifier of the version created by this population operation.

## Other responses

- `480` — ConflictException
- `481` — ServiceQuotaExceededException
- `482` — ResourceNotFoundException
- `483` — InternalServerException
- `484` — ValidationException
- `485` — ThrottlingException
- `486` — 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)