config

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

{{
	config(
		name="test",
		description="this is test sql statement",
		output_paths=[
			"/tmp/morph/{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: "['/tmp/morph/{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.