Features
Data Import
There are multiple ways to import data in CrateDB. Depending on whether you're using CrateDB Cloud or CrateDB Self-managed, they are different options to consider:
- Import from URL (CrateDB Cloud only)
- By specifying a source URL, data format, and compression.
- CSV, JSON, and Parquet files with Gzip compression.
- Import from file (CrateDB Cloud only)
- CSV, JSON, and Parquet formats.
- Manual import through queries, from the Admin UI
- INSERT commands
INSERT INTO customer_data (customerid,gender,profession) SELECT 3000,'Male','Software Engineer';
-
- COPY FROM cvs/json lines/gzip
COPY customer_data FROM '/tmp/Customers.csv' RETURN SUMMARY;
Additional resources
On-demand workshop
Inserting and Querying Data
Timestamp: 12:10 – 21:12
Video Tutorial
Fundamentals: Importing and Exporting Data in CrateDB
August 8, 2022
This tutorial shows the basics of COPY FROM and COPY TO in CrateDB in a video format.
Community Tutorial
Importing and Exporting Data in CrateDB
March 28, 2023
This tutorial presents the basics of
COPY FROM
and COPY TO
in CrateDB.