Configuration values can be written in jinja in SQL as follows:

{{
	config(
		name="test",
		description="this is test sql statement",
		output_paths=[
			"_private/{name}/{now()}{ext()}"
		],
		connection="your_connection_slug"
	)
}}

select 1 as test

​
Parameters

name
string
default: "SQL filename"

Process name, can also be used as an alias when calling from another file.

description
string

Description of the process

output_paths
array: string
default: "['_private/{name}/{now()}{ext()}']"

Output paths for the result files.

See here for description.

connection
string

Destination of connections other than the builtin registered on the screen (optional).

※ If not specified, it is set to built-in postgresql.

Quickstart - SQLload_data