Transforms

Bulk create transforms

Changed on

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

  • Base URL
    https://connect.weld.app
  • URL
    https://connect.weld.app/transforms/bulk
  • Auth
    API key in header x-api-key

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 * * *",
      "partition_expression": "DATE(created_at)",
      "clustering_columns": [
        "customer_id"
      ]
    }
  ]
}

Response

Example response

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

Changes

    • info

      added the new optional request property //

    • info

      added the new optional request property //

    • info

      added the new optional request property //