Skip to main content

From Your Local Machine

Single CSV, JSON, or parquet file​

You can upload a local CSV, JSON, or parquet file to create a new table in MotherDuck using the Add Files button in the top left of the UI. See the Getting Started Tutorial for details.

Other file types​

To upload multiple files at once, or data in other formats supported by DuckDB, you can use the DuckDB CLI. For example:

Connect to MotherDuck if you haven't already by doing the following:

ATTACH 'md:';    
CREATE DATABASE test01;  
INSERT INTO test01 SELECT * FROM 'customers.csv';
use test01;     
CREATE OR REPLACE TABLE orders as SELECT * from 'orders.csv';

You can also upload DuckDB files from your local machine into MotherDuck.

ATTACH 'localdb.db';
CREATE DATABASE cloud_db from 'localdb';
CREATE DATABASE cloud_db2 from 'localdb2.db';