DuckDB Analytics¶
DuckDB Analytics is an Ubuntu 24.04 AMI with the official DuckDB v1.5.6
command-line tool, ready to query local CSV and Parquet files. The matching
httpfs and aws extensions are pre-installed, so you can also read your own
S3 data through an instance IAM role when you choose to.
Launch on AWS Marketplace Getting started
What is included¶
| Component | Details |
|---|---|
| Operating system | Ubuntu 24.04 LTS, x86_64 |
| DuckDB CLI | v1.5.6, official linux/amd64 build, at /usr/local/bin/duckdb |
| Extensions | httpfs and aws for v1.5.6, pinned under /opt/sushi/share/duckdb/extensions/ |
| Query wrapper | /opt/sushi/bin/duckdb-sql, runs one SQL file with the pinned extensions and memory limits |
| Sample data | /opt/sushi/share/duckdb/examples/orders.csv |
| Walkthrough | /opt/sushi/docs/demo.sh and the bundled guide /opt/sushi/docs/README.md |
| Provenance | /opt/sushi/evidence/duckdb-provenance.json |
DuckDB is a command-line tool here. It does not run a server, does not listen on any TCP port, and the image does not include Jupyter or a web UI.
Ports¶
| Port | Purpose | Exposure |
|---|---|---|
| 22/tcp | SSH, optional | Only if you use SSH instead of Session Manager. Restrict it to your administrator CIDR. |
No other inbound port is needed.
Recommended instance¶
t3.medium(2 vCPU, 4 GiB RAM) or larger. At least 4 GiB RAM.- At least 16 GiB encrypted gp3 root volume. Leave room for query spill files.
- IMDSv2.
Billing¶
You pay an hourly software fee, shown on the AWS Marketplace listing, for each running instance. EC2, EBS and data transfer are billed separately by AWS. See the offer terms on the listing for any free trial or promotion.
Where to go next¶
- Getting started: launch, connect and run your first query.
- Configuration: memory limits and reading from S3.
- Operations: security model, backups, updates and support.
- Troubleshooting: common errors and fixes.
Upstream project¶
DuckDB is published by the DuckDB Foundation under the MIT license. Software Sushi packages it and is not affiliated with or endorsed by the DuckDB project.