> ## Documentation Index
> Fetch the complete documentation index at: https://goldrush.dev/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# Destinations Overview

> Overview of destination types available in the GoldRush Pipeline API, including delivery guarantees and pipeline modes.

The GoldRush Pipeline API supports six destination types for delivering processed blockchain data to your infrastructure. Each destination operates in one of two pipeline modes:

* **Structured** - Data passes through normalization, optional ABI decoding, and optional transforms before delivery.
* **Raw** - Bytes are forwarded directly from the source with no processing.

## Destination Routing Table

| Destination Type                                                                 | Pipeline Mode | Delivery Guarantee |
| -------------------------------------------------------------------------------- | ------------- | ------------------ |
| [ClickHouse](/goldrush-pipeline-api/destinations/clickhouse)                     | Structured    | At-least-once      |
| [Postgres](/goldrush-pipeline-api/destinations/postgres)                         | Structured    | At-least-once      |
| [Kafka](/goldrush-pipeline-api/destinations/kafka)                               | Raw           | Exactly-once       |
| [Object Storage (S3/GCS/R2)](/goldrush-pipeline-api/destinations/object-storage) | Structured    | At-least-once      |
| [AWS SQS](/goldrush-pipeline-api/destinations/sqs)                               | Structured    | At-least-once      |
| [Webhook](/goldrush-pipeline-api/destinations/webhook)                           | Structured    | At-least-once      |

## Table Naming Convention

For database destinations (ClickHouse and Postgres), tables are written to `{schema}.{table}` where:

* **schema** is derived from the project name. Hyphens in the project name are converted to underscores (e.g., project `analytics-prod` writes to schema `analytics_prod`).
* **table** is the normalizer output table name.

<Warning>
  Tables don't need to pre-exist in the target database. The pipeline auto-creates tables.
</Warning>

## Available Destinations

<CardGroup cols={2}>
  <Card title="ClickHouse" href="/goldrush-pipeline-api/destinations/clickhouse">
    Batch inserts into ClickHouse with configurable buffer size and flush intervals.
  </Card>

  <Card title="Postgres" href="/goldrush-pipeline-api/destinations/postgres">
    Batch inserts into PostgreSQL with automatic column quoting for reserved words.
  </Card>

  <Card title="Kafka" href="/goldrush-pipeline-api/destinations/kafka">
    Raw byte passthrough to a Kafka topic with exactly-once transactional delivery.
  </Card>

  <Card title="Object Storage" href="/goldrush-pipeline-api/destinations/object-storage">
    Write JSON or Parquet files to S3, GCS, or R2 with time-based partitioning.
  </Card>

  <Card title="AWS SQS" href="/goldrush-pipeline-api/destinations/sqs">
    Deliver records to standard or FIFO SQS queues with built-in deduplication.
  </Card>

  <Card title="Webhook" href="/goldrush-pipeline-api/destinations/webhook">
    HTTP POST delivery with retry logic, backoff, and idempotency keys.
  </Card>
</CardGroup>