CreateTaskFromSQLTask

class oci.data_integration.models.CreateTaskFromSQLTask(**kwargs)

Bases: CreateTaskDetails

The information about the SQL task.

Attributes:

MODEL_TYPE_DATA_LOADER_TASK	A constant which can be used with the model_type property of a CreateTaskDetails.
MODEL_TYPE_INTEGRATION_TASK	A constant which can be used with the model_type property of a CreateTaskDetails.
MODEL_TYPE_OCI_DATAFLOW_TASK	A constant which can be used with the model_type property of a CreateTaskDetails.
MODEL_TYPE_PIPELINE_TASK	A constant which can be used with the model_type property of a CreateTaskDetails.
MODEL_TYPE_REST_TASK	A constant which can be used with the model_type property of a CreateTaskDetails.
MODEL_TYPE_SQL_TASK	A constant which can be used with the model_type property of a CreateTaskDetails.
SQL_SCRIPT_TYPE_SQL_CODE	A constant which can be used with the sql_script_type property of a CreateTaskFromSQLTask.
SQL_SCRIPT_TYPE_STORED_PROCEDURE	A constant which can be used with the sql_script_type property of a CreateTaskFromSQLTask.
config_provider_delegate	Gets the config_provider_delegate of this CreateTaskDetails.
description	Gets the description of this CreateTaskDetails.
identifier	[Required] Gets the identifier of this CreateTaskDetails.
input_ports	Gets the input_ports of this CreateTaskDetails.
is_concurrent_allowed	Gets the is_concurrent_allowed of this CreateTaskDetails.
key	Gets the key of this CreateTaskDetails.
model_type	[Required] Gets the model_type of this CreateTaskDetails.
model_version	Gets the model_version of this CreateTaskDetails.
name	[Required] Gets the name of this CreateTaskDetails.
object_status	Gets the object_status of this CreateTaskDetails.
op_config_values	Gets the op_config_values of this CreateTaskDetails.
operation	Gets the operation of this CreateTaskFromSQLTask.
output_ports	Gets the output_ports of this CreateTaskDetails.
parameters	Gets the parameters of this CreateTaskDetails.
parent_ref	Gets the parent_ref of this CreateTaskDetails.
registry_metadata	[Required] Gets the registry_metadata of this CreateTaskDetails.
script	Gets the script of this CreateTaskFromSQLTask.
sql_script_type	Gets the sql_script_type of this CreateTaskFromSQLTask.

Methods:

__init__(**kwargs)	Initializes a new CreateTaskFromSQLTask object with values from keyword arguments.
get_subtype(object_dictionary)	Given the hash representation of a subtype of this class, use the info in the hash to return the class of the subtype.

MODEL_TYPE_DATA_LOADER_TASK = 'DATA_LOADER_TASK'

A constant which can be used with the model_type property of a CreateTaskDetails. This constant has a value of “DATA_LOADER_TASK”

MODEL_TYPE_INTEGRATION_TASK = 'INTEGRATION_TASK'

A constant which can be used with the model_type property of a CreateTaskDetails. This constant has a value of “INTEGRATION_TASK”

MODEL_TYPE_OCI_DATAFLOW_TASK = 'OCI_DATAFLOW_TASK'

A constant which can be used with the model_type property of a CreateTaskDetails. This constant has a value of “OCI_DATAFLOW_TASK”

MODEL_TYPE_PIPELINE_TASK = 'PIPELINE_TASK'

A constant which can be used with the model_type property of a CreateTaskDetails. This constant has a value of “PIPELINE_TASK”

MODEL_TYPE_REST_TASK = 'REST_TASK'

A constant which can be used with the model_type property of a CreateTaskDetails. This constant has a value of “REST_TASK”

MODEL_TYPE_SQL_TASK = 'SQL_TASK'

A constant which can be used with the model_type property of a CreateTaskDetails. This constant has a value of “SQL_TASK”

SQL_SCRIPT_TYPE_SQL_CODE = 'SQL_CODE'

A constant which can be used with the sql_script_type property of a CreateTaskFromSQLTask. This constant has a value of “SQL_CODE”

SQL_SCRIPT_TYPE_STORED_PROCEDURE = 'STORED_PROCEDURE'

A constant which can be used with the sql_script_type property of a CreateTaskFromSQLTask. This constant has a value of “STORED_PROCEDURE”

__init__(**kwargs)

Initializes a new CreateTaskFromSQLTask object with values from keyword arguments. The default value of the model_type attribute of this class is SQL_TASK and it should not be changed. The following keyword arguments are supported (corresponding to the getters/setters of this class):

Parameters

• model_type (str) – The value to assign to the model_type property of this CreateTaskFromSQLTask. Allowed values for this property are: “INTEGRATION_TASK”, “DATA_LOADER_TASK”, “PIPELINE_TASK”, “SQL_TASK”, “OCI_DATAFLOW_TASK”, “REST_TASK”

• key (str) – The value to assign to the key property of this CreateTaskFromSQLTask.

• model_version (str) – The value to assign to the model_version property of this CreateTaskFromSQLTask.

• parent_ref (oci.data_integration.models.ParentReference) – The value to assign to the parent_ref property of this CreateTaskFromSQLTask.

• name (str) – The value to assign to the name property of this CreateTaskFromSQLTask.

• description (str) – The value to assign to the description property of this CreateTaskFromSQLTask.

• object_status (int) – The value to assign to the object_status property of this CreateTaskFromSQLTask.

• identifier (str) – The value to assign to the identifier property of this CreateTaskFromSQLTask.

• input_ports (list[oci.data_integration.models.InputPort]) – The value to assign to the input_ports property of this CreateTaskFromSQLTask.

• output_ports (list[oci.data_integration.models.OutputPort]) – The value to assign to the output_ports property of this CreateTaskFromSQLTask.

• parameters (list[oci.data_integration.models.Parameter]) – The value to assign to the parameters property of this CreateTaskFromSQLTask.

• op_config_values (oci.data_integration.models.ConfigValues) – The value to assign to the op_config_values property of this CreateTaskFromSQLTask.

• config_provider_delegate (oci.data_integration.models.CreateConfigProvider) – The value to assign to the config_provider_delegate property of this CreateTaskFromSQLTask.

• is_concurrent_allowed (bool) – The value to assign to the is_concurrent_allowed property of this CreateTaskFromSQLTask.

• registry_metadata (oci.data_integration.models.RegistryMetadata) – The value to assign to the registry_metadata property of this CreateTaskFromSQLTask.

• script (oci.data_integration.models.Script) – The value to assign to the script property of this CreateTaskFromSQLTask.

• sql_script_type (str) – The value to assign to the sql_script_type property of this CreateTaskFromSQLTask. Allowed values for this property are: “STORED_PROCEDURE”, “SQL_CODE”

• operation (object) – The value to assign to the operation property of this CreateTaskFromSQLTask.

property config_provider_delegate

Gets the config_provider_delegate of this CreateTaskDetails.

Returns

The config_provider_delegate of this CreateTaskDetails.

Return type

oci.data_integration.models.CreateConfigProvider

property description

Gets the description of this CreateTaskDetails. Detailed description for the object.

Returns

The description of this CreateTaskDetails.

Return type

str

static get_subtype(object_dictionary)

Given the hash representation of a subtype of this class, use the info in the hash to return the class of the subtype.

property identifier

[Required] Gets the identifier of this CreateTaskDetails. Value can only contain upper case letters, underscore, and numbers. It should begin with upper case letter or underscore. The value can be modified.

Returns

The identifier of this CreateTaskDetails.

Return type

str

property input_ports

Gets the input_ports of this CreateTaskDetails. An array of input ports.

Returns

The input_ports of this CreateTaskDetails.

Return type

list[oci.data_integration.models.InputPort]

property is_concurrent_allowed

Gets the is_concurrent_allowed of this CreateTaskDetails. Whether the same task can be executed concurrently.

Returns

The is_concurrent_allowed of this CreateTaskDetails.

Return type

bool

property key

Gets the key of this CreateTaskDetails. Generated key that can be used in API calls to identify task. On scenarios where reference to the task is needed, a value can be passed in create.

Returns

The key of this CreateTaskDetails.

Return type

str

property model_type

[Required] Gets the model_type of this CreateTaskDetails. The type of the task.

Allowed values for this property are: “INTEGRATION_TASK”, “DATA_LOADER_TASK”, “PIPELINE_TASK”, “SQL_TASK”, “OCI_DATAFLOW_TASK”, “REST_TASK”

Returns

The model_type of this CreateTaskDetails.

Return type

str

property model_version

Gets the model_version of this CreateTaskDetails. The object’s model version.

Returns

The model_version of this CreateTaskDetails.

Return type

str

property name

[Required] Gets the name of this CreateTaskDetails. Free form text without any restriction on permitted characters. Name can have letters, numbers, and special characters. The value is editable and is restricted to 1000 characters.

Returns

The name of this CreateTaskDetails.

Return type

str

property object_status

Gets the object_status of this CreateTaskDetails. The status of an object that can be set to value 1 for shallow references across objects, other values reserved.

Returns

The object_status of this CreateTaskDetails.

Return type

int

property op_config_values

Gets the op_config_values of this CreateTaskDetails.

Returns

The op_config_values of this CreateTaskDetails.

Return type

oci.data_integration.models.ConfigValues

property operation

Gets the operation of this CreateTaskFromSQLTask. Describes the shape of the execution result

Returns

The operation of this CreateTaskFromSQLTask.

Return type

object

property output_ports

Gets the output_ports of this CreateTaskDetails. An array of output ports.

Returns

The output_ports of this CreateTaskDetails.

Return type

list[oci.data_integration.models.OutputPort]

property parameters

Gets the parameters of this CreateTaskDetails. An array of parameters.

Returns

The parameters of this CreateTaskDetails.

Return type

list[oci.data_integration.models.Parameter]

property parent_ref

Gets the parent_ref of this CreateTaskDetails.

Returns

The parent_ref of this CreateTaskDetails.

Return type

oci.data_integration.models.ParentReference

property registry_metadata

[Required] Gets the registry_metadata of this CreateTaskDetails.

Returns

The registry_metadata of this CreateTaskDetails.

Return type

oci.data_integration.models.RegistryMetadata

property script

Gets the script of this CreateTaskFromSQLTask.

Returns

The script of this CreateTaskFromSQLTask.

Return type

oci.data_integration.models.Script

property sql_script_type

Gets the sql_script_type of this CreateTaskFromSQLTask. Indicates whether the task is invoking a custom SQL script or stored procedure.

Allowed values for this property are: “STORED_PROCEDURE”, “SQL_CODE”

Returns

The sql_script_type of this CreateTaskFromSQLTask.

Return type

str