Module - builtin.sql.jobs.job_sql

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://localhost/analytics
type	Type
	Mitto job type; must be ‘sql’.
	type	string
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.
	Sql
	anyOf		type	string
			type	array
			items
				type	string
parameters	Query parameters. To indicate a parameter in a query use the following format: ‘:param1’ .
	Parameters
	default	OrderedDict()
	anyOf		type	array
			items
			type	object
kwargs	Kwargs
	Optional keyword arguments that are passed directly to create_engine()
	type	object
	default	OrderedDict()
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