Back to Code Snippets

Carlo Piovesan

@carlo

‌

Load AWS credentialsSQL

Execute this SQL

CALL load_aws_credentials();
--- duckdb >= v0.9.0, AWS and httpfs extension loaded on the fly
Copy code

Copy code

Carlo Piovesan

Copy code

Expand

Share link

Created 09/27/23
‌

SUMMARIZESQL

Editor's note: the SUMMARIZE() function allows you to quickly understand your data. If you want to understand a little more about how it works under the hood, see Hamilton's other snippet on building your own SUMMARIZE() capabilities using built-in analytics functions.

Execute this SQL

SUMMARIZE some_tbl;
SUMMARIZE from 'some_file.csv';
--- summary informations about a given table
Copy code

Copy code

Carlo Piovesan

Expand

Share link

Edited 02/23/24
‌

ATTACH 'other.db';SQL

Editor's note: DuckDB allows you to attach multiple databases at once. For example, you can attach a local file, an in-memory database and a database from MotherDuck and work with all of them simultaneously. The ATTACH statement is executed for each database to be attached.

Execute this SQL

-- attach another database, alias inferred from the name ("other")
ATTACH 'other.db';
SELECT * FROM other.some_table;
Copy code

Copy code

Carlo Piovesan

Expand

Share link

Edited 02/23/24
Terms of Service
Privacy Policy
Sponsored by