Querying local DuckDB databases and files
MotherDuck seamlessly integrates with DuckDB allowing you to use its full power to explore data on your laptop.
Explore any DuckDB file as an attached database:
- CLI
--Querying a data stored in a local duckdb database
> ATTACH 'local_path.db' AS a_duck_db;
SELECT * FROM a_duck_db.local_table;
DuckDB can also directly query many of your favorite file formats:
- CLI
--Querying stored in csv
> SELECT * FROM '/path/to/local_file.csv';
--Querying a parquet file
> SELECT * FROM '/path/to/local_file.parquet';
--Query a json file
> SELECT * FROM '/path/to/local_file.json';
DuckDB can also directly query Python pandas dataframes and Apache Arrow datasets:
- Python pandas
- Python Arrow
import duckdb
import pandas as pd
test_df = pd.DataFrame.from_dict({"i":[1, 2, 3, 4], "j":["one", "two", "three", "four"]})
duckdb.sql('SELECT * FROM test_df').fetchall()
import duckdb
import pyarrow as pa
test_pa_table = pa.Table.from_pydict({"i":[1, 2, 3, 4], "j":["one", "two", "three", "four"]})
duckdb.sql('SELECT * FROM test_pa_table').fetchall()