latestOpenAPI 3.0.02026-08-137192110.1 KB

75294f591cc2

Transforms

List transforms

List all transforms (models) in pages sorted by creation date.

get/transforms

Query parameters

starting_afterstring

Example:ewK8sDoLNI4CFR

The cursor to use in pagination. Use the value of the next_cursor field from the response of a previous list request.

limitinteger

The number of items to return in a single page.

status'draft' | 'published'

Filter by status.

namestring

Filter by name (case-insensitive substring match).

folder_pathstring

Filter by folder path (e.g. "analytics/marketing").

Response

has_moreboolean required

Indicates whether there are more items to be fetched in the subsequent pages.

next_cursorstring

The cursor to use in pagination. Use this value as starting_after to get the next page.

Example response

{
  "has_more": true,
  "next_cursor": "VeN1GjhVIq1D9h",
  "data": [
    {
      "id": "OoORhGXUVjsqFG",
      "name": "marketing_attribution",
      "folder_path": "analytics/marketing",
      "status": "published",
      "materialization": "view",
      "sql_template": "SELECT * FROM {{raw.stripe.payments}} WHERE created_at > CURRENT_DATE - 30",
      "parameters": [
        {
          "weld_tag": "raw.stripe.payments",
          "type": "raw_view",
          "dw_item_id": "stripe_schema.payments"
        }
      ],
      "documentation": "Calculates marketing attribution.",
      "materialization_status": "completed",
      "materialization_error": "Column \"foo\" not found in table \"bar\".",
      "orchestration_workflow_id": "3LIw2FdxoByya9",
      "cron_expression": "0 6 * * *",
      "created_at": "2020-01-01T00:00:00.000Z",
      "updated_at": "2020-01-01T00:00:00.000Z"
    }
  ]
}