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

• How to load Parquet file into a table
• How to export a table to Parquet file
• How to query directly on Parquet file

CSV

• How to load CSV file into a table
• How to export a table to CSV file
• How to query directly on CSV file

TSV

• How to load TSV file into a table
• How to export a table to TSV file
• How to query directly on TSV file

NDJSON

• How to load NDJSON file into a table
• How to export a table to NDJSON file
• How to query directly on NDJSON file

ORC

• How to load ORC file into a table
• How to query directly on ORC file

HTTP(S), S3, and More

• Understanding Stages
• Loading from Stage
• Loading from Bucket
• Loading from Local File
• Loading from Remote File

Loading Data From Other Databases

MySQL Data to Databend

• How to Load Full MySQL Tables into Databend
• How to Sync Full and Incremental MySQL Changes into Databend

PostgreSQL Data to Databend

• How to Sync Full and Incremental PostgreSQL Changes into Databend

Oracle Data to Databend

• How to Sync Full and Incremental Oracle Changes into Databend