Skip to main content
Run SQL queries, browse your catalogs and tables, and open a DuckDB terminal connected to your lake—all from the command line. For a full overview of the lake, see the Lake documentation.

​
Query

Execute ad-hoc SQL queries against the lake: 
oleander query "<sql>"
Example: 
oleander query "SELECT * FROM public.iris_dataset LIMIT 10"
Results are printed as a formatted table with row counts and execution time.

​
Save results

Use --save to persist query results as a table in your lake: 
oleander query "SELECT * FROM public.iris_dataset LIMIT 100" --save

​
Catalog

​
List catalogs

List all available catalogs in your organization: 
oleander catalog list

​
List tables

List tables in a catalog namespace: 
oleander catalog table list --catalog <catalog_name> --namespace <namespace>
If you omit --catalog or --namespace, the CLI prompts you interactively.

​
Describe a table

View the schema of a table: 
oleander catalog table describe --catalog <catalog_name> --namespace <namespace> --table <table_name>

​
DuckDB terminal

Launch a DuckDB terminal pre-configured with your lake catalogs: 
oleander duckdb
This loads all registered catalogs (including Iceberg and S3 Tables) and drops you into an interactive DuckDB session. You can query your lake data directly: 
SELECT * FROM flowers LIMIT 10;
The duckdb command requires DuckDB to be installed on your machine.