📣
TiDB Cloud Premium is now in public preview. Unlimited growth, instant elasticity, advanced security for enterprise workloads. Try it out →
​
Sign InStart for Free
AI
Developer
Best Practices
API
​
Sign InStart for Free

Loading from Files

TiDB Cloud Lake offers simple, powerful commands to load data files into tables. Most operations require just a single command. Your data must be in a supported format.

Data Loading and Unloading Overview

Supported File Formats

FormatTypeDescription
CSV, TSVDelimitedText files with customizable delimiters
NDJSONSemi-structuredJSON objects, one per line
ParquetSemi-structuredEfficient columnar storage format
ORCSemi-structuredHigh-performance columnar format
AvroSemi-structuredCompact binary format with schema

Loading by File Location

Select the location of your files to find the recommended loading method:

Data SourceRecommended ToolDescriptionDocumentation
Staged Data FilesCOPY INTOFast, efficient loading from internal/external stages or user stageLoading from Stage
Cloud StorageCOPY INTOLoad from Amazon S3, Google Cloud Storage, Microsoft AzureLoading from Bucket
Local FilesLakeSQLTiDB Cloud Lake's native CLI tool for local file loadingLoading from Local File
Remote FilesCOPY INTOLoad data from remote HTTP/HTTPS locationsLoading from Remote File

Was this page helpful?