Skip to content
Login
Try for free
Login
Try for free
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;

Product documentation

COPY FROM

COPY TO

cr-quote-image

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.

Blog

How to import data to your CrateDB cluster

May 12, 2023
In this tutorial, we'll walk you through three different approaches to importing data into your CrateDB Cloud cluster.

Need help with importing data in CrateDB?