DuckDB Powered by GlobalSolutions

DuckDB is a relational (table-oriented) DBMS that supports the Structured Query Language (SQL). It runs on a columnar-vectorized query engine, which makes efficient use of the CPU cache and speeds up response times for analytical query workloads. DuckDB fills the need for an embedded database solution for analytical processing and enables users to run complex SQL queries with APIs available for Java, C, C++, and more.

DuckDB has no external dependencies, neither for compilation nor at runtime. It offers a flexible extension mechanism that allows defining new data types, functions, file formats, and SQL syntax. DuckDB can easily pull in files from blob storage, S3, and Azure Blob Storage with minimal configuration.

DBeaver is a powerful and popular desktop SQL editor and integrated development environment (IDE). It is useful for visually inspecting the available tables in DuckDB and for quickly building complex queries.

We have ensured the image is hardened to be secured from all existing vulnerabilities.

Why Subscribe to Our Offering in AWS Marketplace

We update the software constantly to the latest version to address security issues.
Customers can kick-start their core work right away with our pre-packaged AMIs.
Production-ready application stacks.

Accessing Your AMI from AWS Marketplace

To get started with your DuckDB stack:

Subscribe: Purchase the DuckDB AMI from the AWS Marketplace.
Connect via RDP:
- In the AWS Console, select your launched instance and click Connect.
- Choose RDP Client, upload your .pem key file, and decrypt the password using your private key.
- Download the .rdp file and connect using the username Administrator and the decrypted password.

For more information, refer to the AWS Windows Instance Connection Guide.

Installation Paths and Versions

The DuckDB stack is installed in standard Windows directories for easy access:

Category	Packages	Version	Location
DuckDB	DuckDB	1.5.2	C:\duckdb\
DBeaver	DBeaver	26.0.4	C:\DBeaver\

Getting Started with DuckDB

The DuckDB offering from GlobalSolutions comes pre-packaged with all dependent components. All you have to do is subscribe to our AMI and start using it right away.

Accessing DuckDB via Command Line

Open a Command Prompt and navigate to C:\duckdb\.
Type duckdb to connect to DuckDB and create a database.

You can run complex SQL queries directly from the DuckDB CLI. Type .help at the prompt for a list of available commands.

Accessing DuckDB via DBeaver

Click the DBeaver icon on the desktop to launch the SQL IDE.
A sample database Sample.db has been pre-loaded for you to explore and run queries against.

First-Time Setup: When DBeaver opens, it will prompt you to connect to a database. Select DuckDB as the database type and point it to your .db file under C:\duckdb\ to get started.

AWS Cost Optimizer — CloudInsider

Our other popular offering is the AWS Cost Optimizer aka CloudInsider, available in AWS Marketplace. This service has helped our customers save significantly on AWS and other cloud spending. It is easy to subscribe and you can see the savings in minutes.

▶ Watch Demo Video Subscribe on AWS Marketplace

Support

For any questions or assistance with our AWS Marketplace offering, reach out to us at support@theglobalsolutions.net.