# This is an automatically generated code sample.
# To make this code sample work in your Oracle Cloud tenancy,
# please replace the values for any parameters whose current values do not fit
# your use case (such as resource IDs, strings containing ‘EXAMPLE’ or ‘unique_id’, and
# boolean, number, and enum parameters with values not fitting your use case).

import oci

# Create a default config using DEFAULT profile in default location
# Refer to
# https://docs.cloud.oracle.com/en-us/iaas/Content/API/Concepts/sdkconfig.htm#SDK_and_CLI_Configuration_File
# for more info
config = oci.config.from_file()


# Initialize service client with default config file
data_integration_client = oci.data_integration.DataIntegrationClient(config)


# Send the request to service, some parameters are not required, see API
# doc for more info
create_task_response = data_integration_client.create_task(
    workspace_id="ocid1.test.oc1..<unique_ID>EXAMPLE-workspaceId-Value",
    create_task_details=oci.data_integration.models.CreateTaskFromSQLTask(
        model_type="SQL_TASK",
        name="EXAMPLE-name-Value",
        identifier="EXAMPLE-identifier-Value",
        registry_metadata=oci.data_integration.models.RegistryMetadata(
            aggregator_key="EXAMPLE-aggregatorKey-Value",
            labels=["EXAMPLE--Value"],
            registry_version=436,
            key="EXAMPLE-key-Value",
            is_favorite=False),
        key="EXAMPLE-key-Value",
        model_version="EXAMPLE-modelVersion-Value",
        parent_ref=oci.data_integration.models.ParentReference(
            parent="EXAMPLE-parent-Value",
            root_doc_id="ocid1.test.oc1..<unique_ID>EXAMPLE-rootDocId-Value"),
        description="EXAMPLE-description-Value",
        object_status=92,
        input_ports=[
                    oci.data_integration.models.InputPort(
                        model_type="INPUT_PORT",
                        key="EXAMPLE-key-Value",
                        model_version="EXAMPLE-modelVersion-Value",
                        parent_ref=oci.data_integration.models.ParentReference(
                            parent="EXAMPLE-parent-Value",
                            root_doc_id="ocid1.test.oc1..<unique_ID>EXAMPLE-rootDocId-Value"),
                        config_values=oci.data_integration.models.ConfigValues(
                            config_param_values={
                                'EXAMPLE_KEY_1Kmru': {
                                    'stringValue': 'EXAMPLE-stringValue-Value',
                                    'intValue': 870,
                                    'objectValue': 'EXAMPLE-objectValue-Value',
                                    'refValue': 'EXAMPLE-refValue-Value',
                                    'parameterValue': 'EXAMPLE-parameterValue-Value',
                                    'rootObjectValue': 'EXAMPLE-rootObjectValue-Value'}},
                            parent_ref=oci.data_integration.models.ParentReference(
                                parent="EXAMPLE-parent-Value",
                                root_doc_id="ocid1.test.oc1..<unique_ID>EXAMPLE-rootDocId-Value")),
                        object_status=3,
                        name="EXAMPLE-name-Value",
                        description="EXAMPLE-description-Value",
                        port_type="DATA",
                        fields=[
                            oci.data_integration.models.DynamicProxyField(
                                model_type="DYNAMIC_PROXY_FIELD",
                                key="EXAMPLE-key-Value",
                                model_version="EXAMPLE-modelVersion-Value",
                                parent_ref=oci.data_integration.models.ParentReference(
                                    parent="EXAMPLE-parent-Value",
                                    root_doc_id="ocid1.test.oc1..<unique_ID>EXAMPLE-rootDocId-Value"),
                                config_values=oci.data_integration.models.ConfigValues(
                                    config_param_values={
                                        'EXAMPLE_KEY_aMHqo': {
                                            'stringValue': 'EXAMPLE-stringValue-Value',
                                            'intValue': 988,
                                            'objectValue': 'EXAMPLE-objectValue-Value',
                                            'refValue': 'EXAMPLE-refValue-Value',
                                            'parameterValue': 'EXAMPLE-parameterValue-Value',
                                            'rootObjectValue': 'EXAMPLE-rootObjectValue-Value'}},
                                    parent_ref=oci.data_integration.models.ParentReference(
                                        parent="EXAMPLE-parent-Value",
                                        root_doc_id="ocid1.test.oc1..<unique_ID>EXAMPLE-rootDocId-Value")),
                                object_status=595,
                                name="EXAMPLE-name-Value",
                                description="EXAMPLE-description-Value",
                                type=oci.data_integration.models.MapType(
                                    model_type="MAP_TYPE",
                                    key="EXAMPLE-key-Value",
                                    model_version="EXAMPLE-modelVersion-Value",
                                    parent_ref=oci.data_integration.models.ParentReference(
                                        parent="EXAMPLE-parent-Value",
                                        root_doc_id="ocid1.test.oc1..<unique_ID>EXAMPLE-rootDocId-Value"),
                                    name="EXAMPLE-name-Value",
                                    object_status=335,
                                    description="EXAMPLE-description-Value",
                                    key_element_type="EXAMPLE-keyElementType-Value",
                                    value_element_type="EXAMPLE-valueElementType-Value",
                                    contains_null=True),
                                labels=["EXAMPLE--Value"])])],
        output_ports=[
            oci.data_integration.models.OutputPort(
                model_type="OUTPUT_PORT",
                key="EXAMPLE-key-Value",
                model_version="EXAMPLE-modelVersion-Value",
                parent_ref=oci.data_integration.models.ParentReference(
                    parent="EXAMPLE-parent-Value",
                    root_doc_id="ocid1.test.oc1..<unique_ID>EXAMPLE-rootDocId-Value"),
                config_values=oci.data_integration.models.ConfigValues(
                    config_param_values={
                        'EXAMPLE_KEY_OysNd': {
                            'stringValue': 'EXAMPLE-stringValue-Value',
                            'intValue': 745,
                            'objectValue': 'EXAMPLE-objectValue-Value',
                            'refValue': 'EXAMPLE-refValue-Value',
                            'parameterValue': 'EXAMPLE-parameterValue-Value',
                            'rootObjectValue': 'EXAMPLE-rootObjectValue-Value'}},
                    parent_ref=oci.data_integration.models.ParentReference(
                        parent="EXAMPLE-parent-Value",
                        root_doc_id="ocid1.test.oc1..<unique_ID>EXAMPLE-rootDocId-Value")),
                object_status=217,
                name="EXAMPLE-name-Value",
                description="EXAMPLE-description-Value",
                port_type="CONTROL",
                fields=[
                    oci.data_integration.models.DerivedField(
                        model_type="DERIVED_FIELD",
                        key="EXAMPLE-key-Value",
                        model_version="EXAMPLE-modelVersion-Value",
                        parent_ref=oci.data_integration.models.ParentReference(
                            parent="EXAMPLE-parent-Value",
                            root_doc_id="ocid1.test.oc1..<unique_ID>EXAMPLE-rootDocId-Value"),
                        config_values=oci.data_integration.models.ConfigValues(
                            config_param_values={
                                'EXAMPLE_KEY_HCBFP': {
                                    'stringValue': 'EXAMPLE-stringValue-Value',
                                    'intValue': 564,
                                    'objectValue': 'EXAMPLE-objectValue-Value',
                                    'refValue': 'EXAMPLE-refValue-Value',
                                    'parameterValue': 'EXAMPLE-parameterValue-Value',
                                    'rootObjectValue': 'EXAMPLE-rootObjectValue-Value'}},
                            parent_ref=oci.data_integration.models.ParentReference(
                                parent="EXAMPLE-parent-Value",
                                root_doc_id="ocid1.test.oc1..<unique_ID>EXAMPLE-rootDocId-Value")),
                        object_status=189,
                        name="EXAMPLE-name-Value",
                        description="EXAMPLE-description-Value",
                        expr=oci.data_integration.models.Expression(
                            key="EXAMPLE-key-Value",
                            model_type="EXAMPLE-modelType-Value",
                            model_version="EXAMPLE-modelVersion-Value",
                            parent_ref=oci.data_integration.models.ParentReference(
                                parent="EXAMPLE-parent-Value",
                                root_doc_id="ocid1.test.oc1..<unique_ID>EXAMPLE-rootDocId-Value"),
                            expr_string="EXAMPLE-exprString-Value",
                            config_values=oci.data_integration.models.ConfigValues(
                                config_param_values={
                                    'EXAMPLE_KEY_LTByO': {
                                        'stringValue': 'EXAMPLE-stringValue-Value',
                                        'intValue': 417,
                                        'objectValue': 'EXAMPLE-objectValue-Value',
                                        'refValue': 'EXAMPLE-refValue-Value',
                                        'parameterValue': 'EXAMPLE-parameterValue-Value',
                                        'rootObjectValue': 'EXAMPLE-rootObjectValue-Value'}},
                                parent_ref=oci.data_integration.models.ParentReference(
                                    parent="EXAMPLE-parent-Value",
                                    root_doc_id="ocid1.test.oc1..<unique_ID>EXAMPLE-rootDocId-Value")),
                            object_status=904),
                        type="EXAMPLE-type-Value",
                        is_use_inferred_type=True,
                        labels=["EXAMPLE--Value"])])],
        parameters=[
            oci.data_integration.models.Parameter(
                model_type="PARAMETER",
                key="EXAMPLE-key-Value",
                model_version="EXAMPLE-modelVersion-Value",
                parent_ref=oci.data_integration.models.ParentReference(
                    parent="EXAMPLE-parent-Value",
                    root_doc_id="ocid1.test.oc1..<unique_ID>EXAMPLE-rootDocId-Value"),
                config_values=oci.data_integration.models.ConfigValues(
                    config_param_values={
                        'EXAMPLE_KEY_oxubz': {
                            'stringValue': 'EXAMPLE-stringValue-Value',
                            'intValue': 12,
                            'objectValue': 'EXAMPLE-objectValue-Value',
                            'refValue': 'EXAMPLE-refValue-Value',
                            'parameterValue': 'EXAMPLE-parameterValue-Value',
                            'rootObjectValue': 'EXAMPLE-rootObjectValue-Value'}},
                    parent_ref=oci.data_integration.models.ParentReference(
                        parent="EXAMPLE-parent-Value",
                        root_doc_id="ocid1.test.oc1..<unique_ID>EXAMPLE-rootDocId-Value")),
                object_status=804,
                name="EXAMPLE-name-Value",
                description="EXAMPLE-description-Value",
                type="EXAMPLE-type-Value",
                default_value="EXAMPLE-defaultValue-Value",
                root_object_default_value="EXAMPLE-rootObjectDefaultValue-Value",
                is_input=True,
                is_output=False,
                output_aggregation_type="COUNT",
                type_name="EXAMPLE-typeName-Value",
                used_for="EXAMPLE-usedFor-Value")],
        op_config_values=oci.data_integration.models.ConfigValues(
            config_param_values={
                'EXAMPLE_KEY_Yu7rv': {
                    'stringValue': 'EXAMPLE-stringValue-Value',
                    'intValue': 637,
                    'objectValue': 'EXAMPLE-objectValue-Value',
                    'refValue': 'EXAMPLE-refValue-Value',
                    'parameterValue': 'EXAMPLE-parameterValue-Value',
                    'rootObjectValue': 'EXAMPLE-rootObjectValue-Value'}},
            parent_ref=oci.data_integration.models.ParentReference(
                parent="EXAMPLE-parent-Value",
                root_doc_id="ocid1.test.oc1..<unique_ID>EXAMPLE-rootDocId-Value")),
        config_provider_delegate=oci.data_integration.models.CreateConfigProvider(
            bindings={
                'EXAMPLE_KEY_DQ51q': {
                    'simpleValue': 'EXAMPLE-simpleValue-Value',
                    'rootObjectValue': 'EXAMPLE-rootObjectValue-Value'}}),
        is_concurrent_allowed=False,
        script=oci.data_integration.models.Script(
            key="EXAMPLE-key-Value",
            model_type="EXAMPLE-modelType-Value",
            model_version="EXAMPLE-modelVersion-Value",
            parent_ref=oci.data_integration.models.ParentReference(
                parent="EXAMPLE-parent-Value",
                root_doc_id="ocid1.test.oc1..<unique_ID>EXAMPLE-rootDocId-Value"),
            object_status=859),
        sql_script_type="SQL_CODE",
        operation="EXAMPLE-operation-Value"),
    opc_retry_token="EXAMPLE-opcRetryToken-Value",
    opc_request_id="0ABT87JQGVGXR7CCR4VJ<unique_ID>")

# Get the data from response
print(create_task_response.data)