config

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

{{
	config(
		name="test",
		description="this is test sql statement",
		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.

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.