Advance Data Warehousing

Query Github Directly

select * from read_parquet('https://github.com/duckdb/duckdb-data/releases/download/v1.0/userdata1.parquet');

select * from read_parquet('https://github.com/duckdb/duckdb-data/releases/download/v1.0/orders.parquet') limit 5;

select * from read_parquet('https://github.com/duckdb/duckdb-data/releases/download/v1.0/city_temperature.parquet') limit 5;

Create DuckDB table

create table orders as select * from read_parquet('https://github.com/duckdb/duckdb-data/releases/download/v1.0/orders.parquet');

describe table

describe orders;

select * from read_json('https://github.com/duckdb/duckdb-data/releases/download/v1.0/canada.json') limit 5;