Module - builtin.sql.sql.types

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