WEweld
ELT Destinations

Add ELT Destination

Changed on

Beta. Add an ELT Destination on a Connection, so ELT Syncs can load into it next to the data warehouse. A Connection can back several ELT Destinations. Available to accounts with the multi-destination ELT feature.

post/elt_destinations

Request

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

Request body

connection_idstring required

The ID of a Connection whose integration is an ELT destination. The data warehouse Connection is refused, since every ELT Sync already loads into it.

labelstring required

Names the ELT Destination. Unique among the account's ELT Destinations.

settingsobject required

The ELT Destination's settings, answering the schema from GET /elt_destinations/settings_schema for the Connection. A setting the schema gives a default may be left out and takes that default. An integration whose schema has no properties takes an empty object.

use_for_new_syncsboolean

Whether ELT Syncs created without additional_destinations also load into this ELT Destination. ELT Syncs that already exist are not changed. Refused when another ELT Destination on the same Connection already is.

Example request

{
  "label": "Snowflake analytics",
  "settings": {
    "database": "ANALYTICS",
    "uppercaseIdentifiers": true
  }
}

Response

idstring required

The ID of the ELT Destination.

labelstring required

Names the ELT Destination. Unique among the account's ELT Destinations.

connection_idstring required

The ID of the Connection the ELT Destination loads into.

integration_idstring required

The integration of the Connection.

settingsobject required

The ELT Destination's settings, answering the schema from GET /elt_destinations/settings_schema for its Connection. Empty when the integration's schema has no properties, or the destination was added before it had one.

use_for_new_syncsboolean required

Whether ELT Syncs created without additional_destinations also load into this ELT Destination. ELT Syncs that already exist are not changed.

history_tables_supportedboolean required

Whether this destination keeps a history table for a stream.

soft_deletes_supportedboolean required

Whether full syncs into this destination can keep the rows the source no longer returns.

cdc_deletes_supportedboolean required

Whether this destination applies the deletes a Postgres change data capture run reports.

created_atstring date-time required

When the ELT Destination was added.

Example response

{
  "id": "k3XbP9qLm2Rt7a",
  "label": "Snowflake analytics",
  "connection_id": "Vb3kQ9xLm2Pt7a",
  "integration_id": "snowflake",
  "settings": {
    "database": "ANALYTICS",
    "uppercaseIdentifiers": true
  }
}

Changes

  • 1f8c53229872Revision changes
    • breaking

      added the new required request property

    • breaking

      added the new required request property

    • warning

      removed the request property

    • warning

      removed the optional property from the response with the status

    • info

      added the new optional request property

    • info

      added the required property to the response with the status

    • info

      added the required property to the response with the status

    • info

      added the required property to the response with the status

  • 8a78fb25b1abRevision changes
    • warning

      removed the request property

    • warning

      removed the optional property from the response with the status