---
title: "List ELT Streams"
method: GET
path: "/elt_streams"
tags: ["ELT Streams"]
---

# List ELT Streams

`GET /elt_streams`

List all ELT Streams in pages sorted by their creation date.

## Query parameters

- `elt_sync_id` string
- `starting_after` string
- `limit` integer

## Response `200`

- PagedEltStreamDto
  - `has_more` boolean, required — Indicates whether there are more items to be fetched in the subsequent pages.
  - `next_cursor` string — The cursor to use in pagination. Use this value as `starting_after` to get the next page.
  - `data` EltStreamDto[], required — List of ELT Streams
    - `id` string, required — The Id of the ELT Stream.
    - `elt_sync_id` string, required — The Id of the ELT Sync that the ELT Stream belongs to.
    - `name` string, required — The name of the ELT Stream
    - `incremental_primary_key_name` string[] — The name of the primary key field used for incremental sync. Most commonly used for database incremental syncs.
    - `incremental_pointer_id` string — The name of the field used for incremental sync cursor.
    - `full_sync_at_midnight` boolean, required — Indicates whether the full sync should be performed at midnight.
    - `full_sync_always` boolean, required — Indicates whether the full sync should always be performed.
    - `protected_from_full_sync` boolean, required — Indicates whether the stream is protected from full sync.
    - `created_at` string, date-time, required — The datetime when the ELT Stream was created.
    - `updated_at` string, date-time, required — The datetime when the ELT Stream was last updated.
    - `excluded_substreams` string[], required — Excluded substreams from syncing.
    - `enabled_history_table` boolean, required — Whether history table(s) are enabled for this stream
    - `sync_interval` string, nullable — Custom cron schedule for this stream. When set, the stream is pulled out of its ELT Sync (orchestration or schedule) and runs on its own schedule. Null means it follows the parent ELT Sync.

---

[API](https://skmtc.net/weld/apis/weld-rest-api.md) · [All operations](https://skmtc.net/weld/apis/weld-rest-api/llms.txt) · [OpenAPI document](https://skmtc-service-staging.skmtc.workers.dev/v1/apis/weld/weld-rest-api/revisions/75294f591cc2/schema)