ELT Destinations

Update ELT Destination

Changed on

Beta. Update the label, the settings, or whether new ELT Syncs load into an ELT Destination. While an ELT Sync loads into it, its settings cannot change.

post/elt_destinations/{id}

Request

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

Path parameters

idstring required

The ID of the ELT Destination to update.

Request body

labelstring nullable

Names the ELT Destination. Unique among the account's ELT Destinations. Left out, the label stays as it is.

settingsobject

The ELT Destination's settings, answering the schema from GET /elt_destinations/settings_schema for its Connection. A setting the schema gives a default may be left out and takes that default. Left out, the settings stay as they are. Refused while an ELT Sync loads into the destination, unless they are unchanged.

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. Left out, it stays as it 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