You can write configuration values in SQL using jinja as follows.

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

select 1 as test

​
Parameters

​
name
string
default:
"SQL file name"

The process name, which can also be used as an alias when called from other files.

​
description
string

You can describe the process.

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

The output destination of the result file.

Refer to here for the description method.

​
connection
string
default:
"default_connection set in morph_project.yml"

The destination of connections other than the built-in ones registered on the screen (optional).

※ If not specified, it will be set to the built-in PostgreSQL.

​
result_cache_ttl
integer
default:
"0"

Specify the cache expiration time of the data pipeline execution result in seconds.

scheduled_jobsload_data