Back to Code Snippets

Carlo Piovesan

@carlo

Load AWS credentialsSQL

Carlo Piovesan

Copy code

Expand

Share link

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.

Carlo Piovesan

Expand

Share link

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.

Carlo Piovesan

Expand

Share link