Load Data into Databend

Databend's powerful ETL capabilities allow for efficient data loading from a variety of sources and formats. This guide provides detailed instructions on how to import data into Databend.

Data Import and Export

Parquet

• Load Parquet into table
• Export table to Parquet
• Query Parquet directly

CSV

• Load CSV into table
• Export table to CSV
• Query CSV directly

TSV

• Load TSV into table
• Export table to TSV
• Query TSV directly

NDJSON

• Load NDJSON into table
• Export table to NDJSON
• Query NDJSON directly

ORC

• Load ORC into table
• Query ORC directly

Avro

• Load Avro into table
• Query Avro directly

Load Data from Different Sources

Loading from Stage

• Loading from Stage

Loading from Bucket (S3)

• Loading from Bucket

Loading from Local File

• Loading from Local File

Loading from Remote File (HTTP/HTTPS)

• Loading from Remote File

Loading Data from External Systems

MySQL Data to Databend

• Sync MySQL Data via Databend Cloud Data Integration (Recommended for Databend Cloud users)
• Load Full MySQL Tables
• Sync MySQL Changes (Full & Incremental)

PostgreSQL Data to Databend

• Sync PostgreSQL Changes (Full & Incremental)

Oracle Data to Databend

• Sync Oracle Changes (Full & Incremental)

Flink Data to Databend

• Sync Flink Data

Kafka Data to Databend

• Kafka Data Ingestion