Module - builtin.sql.jobs.job_sql¶
JsonConfig¶
Represents the job’s JSON config. |
|||||
type |
object |
||||
properties |
|||||
|
Title |
||||
Job Title |
|||||
type |
string |
||||
|
Name |
||||
Job Name |
|||||
type |
string |
||||
|
Dbo |
||||
Database URL. |
|||||
type |
string |
||||
default |
postgresql://localhost/analytics |
||||
|
Credentials |
||||
Credentials name. |
|||||
type |
string |
||||
|
Type |
||||
Mitto job type; must be ‘sql’. |
|||||
type |
string |
||||
|
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 |
||||
|
Query parameters. To indicate a parameter in a query use the following format: ‘:param1’ . |
||||
Parameters |
|||||
default |
OrderedDict() |
||||
anyOf |
type |
array |
|||
items |
|||||
type |
object |
||||
|
Kwargs |
||||
Optional keyword arguments that are passed directly to create_engine() |
|||||
type |
object |
||||
default |
OrderedDict() |
||||
|
Transaction |
||||
|
|||||
type |
boolean |
||||
default |
True |
||||
|
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 |