How to configure your DuckDB database
queries/
folder.
Create the source configuration file
.yaml
file in the queries
folder. There can only be one source configuration file per directory, so if you already have another source file in your root queries
folder, you will need to create a new subfolder for this source.Add the duckdb type in the source configuration file
(optional) Add more details to connect to a remote duckdb database
Done!
.sql
in the queries
directory that points to a table of your new connection in the FROM
clause. See the section SQL Syntax Basics to learn more.latitude run query_file_name
where query_file_name
is the name of your .sql
file. This will display the results in your terminal. See the section Running queries to learn more about how to query your data.