📣

TiDB Cloud Premium is now in public preview. Unlimited growth, instant elasticity, advanced security for enterprise workloads. Try it out →

Loading Semi-structured Data

Semi-structured data contains tags or markers to separate semantic elements while not conforming to rigid database structures. TiDB Cloud Lake efficiently loads these formats using the COPY INTO command, with optional on-the-fly data transformation.

Supported File Formats

File Format	Description	Guide
Parquet	Efficient columnar storage format	Loading Parquet
CSV	Comma-separated values	Loading CSV
TSV	Tab-separated values	Loading TSV
NDJSON	Newline-delimited JSON	Loading NDJSON
ORC	Optimized Row Columnar format	Loading ORC
Avro	Row-based format with schema definition	Loading Avro

Loading Semi-structured Data

Supported File Formats

Was this page helpful?