---
title: "Bulk create transforms"
method: POST
path: "/transforms/bulk"
tags: ["Transforms"]
---

# Bulk create transforms

`POST /transforms/bulk`

Create multiple transforms in a single request. Each transform is processed independently; failures on individual items do not affect others. Maximum 50 transforms per request.

## Request body

- TransformBulkCreateRequestDto
  - `transforms` TransformCreateRequestDto[], required — Array of transforms to create. Maximum 50 transforms per request.
    - `name` string, required — The name of the transform.
    - `folder_path` string — The folder path for the transform. Intermediate folders will be auto-created if they do not exist.
    - `sql_template` string, required — The SQL template with {{weldTag}} parameter references.
    - `materialization` 'view' | 'table' — The materialization type. Defaults to "view".
    - `documentation` string — Documentation for the transform.
    - `publish` boolean — If true, the transform will be published (materialized to DWH) immediately after creation.
    - `cron_expression` string — Cron expression (UTC) defining the transform's own materialization schedule, applied once it has been published. Requires publish=true and materialization "table". Omit for a transform that should only be materialized on demand.
    - `wait_for_completion` boolean — If true, the API will wait for table materialization to complete before returning, up to a configured timeout (default ~45 seconds; may differ per environment). Only relevant when publishing with materialization set to "table". If the materialization does not complete within the timeout, the response will still succeed with materialization_status "running".

## Response `200`

- TransformBulkCreateResponseDto
  - `results` TransformBulkResultItemDto[], required — Results for each transform in the request.
    - `name` string, required — The name of the transform from the request.
    - `success` boolean, required — Whether the operation succeeded.
    - `id` string, nullable — The ID of the created transform, if successful.
    - `error` string, nullable — Error message if the operation failed.

---

[API](https://skmtc.net/weld/apis/weld-rest-api.md) · [All operations](https://skmtc.net/weld/apis/weld-rest-api/llms.txt) · [OpenAPI document](https://skmtc-service-staging.skmtc.workers.dev/v1/apis/weld/weld-rest-api/revisions/75294f591cc2/schema)