Attaching remote databases

Connect to remote DuckDB databases hosted on GitHub or other URLs

Remote DuckDB databases can be attached by executing a SQL statement, here we use an example database from the tobilg/aws-iam-data repository on GitHub:
-- Attach remote database
ATTACH 'https://raw.githubusercontent.com/tobilg/aws-iam-data/main/data/db/iam.duckdb' as aws_iam (READ_ONLY);
The result area will show a success message, and the database is then accessible in the schema browser on the left-hand side: