Principle:Apache Druid SQL Destination Configuration
| Knowledge Sources | |
|---|---|
| Domains | Data_Ingestion, SQL_Ingestion |
| Last Updated | 2026-02-10 00:00 GMT |
Overview
A destination selection pattern for SQL-based ingestion that configures the target datasource and write mode (INSERT INTO for append, REPLACE INTO for overwrite).
Description
SQL Destination Configuration determines the target of the SQL ingestion statement. Users choose between:
- New table: Creates a new datasource with INSERT INTO
- Append to existing: Adds data to an existing datasource with INSERT INTO
- Replace existing: Overwrites data in an existing datasource with REPLACE INTO ... OVERWRITE
The component shows a list of existing datasources for append/replace modes and a text input for new table names.
Usage
Use this principle after schema configuration to set the target datasource. The destination choice determines the SQL statement type (INSERT vs. REPLACE) and whether the OVERWRITE clause is included.
Theoretical Basis
Destination configuration follows a write mode selection pattern:
Mode 'new' → INSERT INTO "new_table_name" SELECT ...
Mode 'append' → INSERT INTO "existing_table" SELECT ...
Mode 'replace' → REPLACE INTO "existing_table" OVERWRITE ALL SELECT ...
Related Pages
Implemented By
Page Connections
Double-click a node to navigate. Hold to expand connections.
Principle
Implementation
Heuristic
Environment