Having a .duckdb file is a convenient way to package a bunch of tables under only one file. For example, you can ATTACH to a remote DuckDB database and start joining and querying data across tables, without having to remember and paste the URL for each table (parquet).