latestOpenAPI 3.0.02026-08-137192110.1 KB

75294f591cc2

Transforms

Bulk create transforms

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.

post/transforms/bulk

Request body

Example request

{
  "transforms": [
    {
      "name": "marketing_attribution",
      "folder_path": "analytics/marketing",
      "sql_template": "SELECT * FROM {{raw.stripe.payments}} WHERE created_at > CURRENT_DATE - 30",
      "materialization": "view",
      "documentation": "Calculates marketing attribution from ad spend and conversions.",
      "cron_expression": "0 6 * * *"
    }
  ]
}

Response

Example response

{
  "results": [
    {
      "name": "my_transform",
      "success": true,
      "id": "OoORhGXUVjsqFG"
    }
  ]
}