Special Control Arguments (Autonomous AI Database)

13.7.4 Special Control Arguments (Autonomous AI Database)

Use the PAR_LST parameter to specify special control arguments and additional arguments to be passed into the Python script.

Argument	Syntax and Description
`oml_input_type`	Syntax `oml_input_type` : `'pandas.DataFrame'`, `'numpy.recarray'`, or `'default'` (default) Description Specifies the type of object to construct from data in the Autonomous AI Database. By default, a two-dimensional `numpy.ndarray` of type `numpy.float64` is constructed if all columns are numeric. Otherwise, a `pandas.DataFrame` is constructed.
`oml_na_omit`	Syntax `oml_na_omit : bool, false` (default) Description Determines if rows with any missing values will be omitted from the table to be evaluated. If `true`, omit all rows with missing values from the table. If `false`, do not omit rows with missing values from the table.
`oml_async_flag`	Syntax `oml_async_flag`: `bool`, `false` (default) Description If `true`, the job will be submitted asynchronously. If `false`, the job will be executed in synchronous mode.
`oml_graphics_flag`	Syntax `oml_graphics_flag`: `bool`, `false` (default) Description If `true`, the server will capture images rendered in the Python script. If `false`, the server will not capture images rendered in the Python script.
`oml_parallel_flag`	Syntax `oml_parallel_flag`: `bool`, `false` (default) Description If `true`, the Python script will be run with data parallelism. Data parallelism is only applicable to `pyqRowEval`, `pyqGroupEval`, and `pyqIndexEval`. If `false`, the Python script will not be run with data parallelism.
`oml_service_level`	Syntax `oml_service_level` : `string`, allowed values: `'LOW'`(default), `'MEDIUM'`, `'HIGH'` Description Controls the different levels of performance and concurrency in Autonomous AI Database.
`timeout`	Syntax `timeout` : `int, 1800` (default) Description The asynchronous timeout limit, expressed in seconds, must be used with the argument `oml_async_flag` set to `true`. Allowed values are in the range [1800, 43200].

Examples

Input data is pandas.DataFrame:

par_lst => '{"oml_input_type":"pandas.DataFrame"}'

Drop rows with missing values from input data:
```
par_lst => '{"oml_na_omit":true}'
```
Submit a job in asynchronous mode:
```
par_lst => '{"oml_async_flag":true}'
```

Use MEDIUM service level:

par_lst => '{"oml_service_level":"MEDIUM"}'

Use timeout argument:

par_lst => '{"oml_async_flag":true, "timeout": 4000}'

Parent topic: SQL API for Embedded Python Execution with Autonomous AI Database