Class - builtin.sql.jobs.job_sql.JsonConfig

JSON Schema

JsonConfig

Represents the job’s JSON config.
type	object
properties
title	Title
	Job Title
	type	string
name	Name
	Job Name
	type	string
dbo	Dbo
	Database URL.
	type	string
	default	postgresql://mitto:1234@db/analytics_test
credentials	Credentials
	Credential name.
	type	string
type	Type
	Mitto job type; must be ‘sql’.
	type	string
	default	sql
	const	sql
sql	Sql
	SQL statement(s) separated by commas. This parameter may be a single string or a list of strings. If a list is provided, that list is concatenated into a single string separated by a space.
	anyOf	type	string
		type	array
		items	type	string
parameters	Parameters
	Query parameters. To indicate a parameter in a query use the following format: ‘:param1’ .
	default
	anyOf	type	array
		items
		type	object
kwargs	Kwargs
	Optional keyword arguments that are passed directly to create_engine()
	type	object
	default
transaction	Transaction
	“ Use a transaction to run SQL. Setting this parameter to True wraps the execution of sql in a begin() context.
	type	boolean
	default	True
split	Split
	Split the sql into separate statements before passing the result to the database via ‘;’ sign. This capability is particularly useful for Snowflake which only allows a single SQL statement to be submitted at a given time.
	type	boolean
	default	False