# 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_entity_shape_response = data_integration_client.create_entity_shape(
    workspace_id="ocid1.test.oc1..<unique_ID>EXAMPLE-workspaceId-Value",
    connection_key="EXAMPLE-connectionKey-Value",
    schema_resource_name="EXAMPLE-schemaResourceName-Value",
    create_entity_shape_details=oci.data_integration.models.CreateEntityShapeFromSQL(
        model_type="SQL_ENTITY",
        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",
        description="EXAMPLE-description-Value",
        object_version=503,
        external_key="EXAMPLE-externalKey-Value",
        shape=oci.data_integration.models.Shape(
            model_type="SHAPE",
            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_sUeYt': {
                        'stringValue': 'EXAMPLE-stringValue-Value',
                        'intValue': 118,
                        '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=496,
            name="EXAMPLE-name-Value",
            description="EXAMPLE-description-Value",
            type=oci.data_integration.models.DataType(
                model_type="DATA_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=506,
                description="EXAMPLE-description-Value",
                dt_type="STRUCTURED",
                type_system_name="EXAMPLE-typeSystemName-Value",
                config_definition=oci.data_integration.models.ConfigDefinition(
                        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"),
                        name="EXAMPLE-name-Value",
                        is_contained=False,
                        object_status=129,
                        config_parameter_definitions={
                            'EXAMPLE_KEY_aiXv2': {
                                'parameterName': 'EXAMPLE-parameterName-Value',
                                'description': 'EXAMPLE-description-Value',
                                'defaultValue': 'EXAMPLE-defaultValue-Value',
                                'classFieldName': 'EXAMPLE-classFieldName-Value',
                                'isStatic': False,
                                'isClassFieldValue': False}}))),
        shape_id="ocid1.test.oc1..<unique_ID>EXAMPLE-shapeId-Value",
        entity_type="VIEW",
        other_type_label="EXAMPLE-otherTypeLabel-Value",
        unique_keys=[
            oci.data_integration.models.UniqueDataKey(
                model_type="UNIQUE_KEY",
                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",
                attribute_refs=[
                    oci.data_integration.models.KeyAttribute(
                        position=927,
                        shape_field=oci.data_integration.models.ShapeField(
                            model_type="SHAPE_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_ZQ2Lo': {
                                        'stringValue': 'EXAMPLE-stringValue-Value',
                                        'intValue': 114,
                                        '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=526,
                            name="EXAMPLE-name-Value",
                            description="EXAMPLE-description-Value",
                            type="EXAMPLE-type-Value",
                            labels=["EXAMPLE--Value"],
                            native_shape_field=oci.data_integration.models.NativeShapeField(
                                name="EXAMPLE-name-Value",
                                model_type="EXAMPLE-modelType-Value",
                                type="EXAMPLE-type-Value",
                                config_values=oci.data_integration.models.ConfigValues(
                                    config_param_values={
                                        'EXAMPLE_KEY_0JQkV': {
                                            'stringValue': 'EXAMPLE-stringValue-Value',
                                            'intValue': 131,
                                            '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")),
                                position=741,
                                default_value_string="EXAMPLE-defaultValueString-Value",
                                is_mandatory=False)),
                        attribute=oci.data_integration.models.ShapeField(
                            model_type="SHAPE_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_tpO9Y': {
                                        'stringValue': 'EXAMPLE-stringValue-Value',
                                        'intValue': 840,
                                        '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=845,
                            name="EXAMPLE-name-Value",
                            description="EXAMPLE-description-Value",
                            type="EXAMPLE-type-Value",
                            labels=["EXAMPLE--Value"],
                            native_shape_field=oci.data_integration.models.NativeShapeField(
                                name="EXAMPLE-name-Value",
                                model_type="EXAMPLE-modelType-Value",
                                type="EXAMPLE-type-Value",
                                config_values=oci.data_integration.models.ConfigValues(
                                    config_param_values={
                                        'EXAMPLE_KEY_ym8Vn': {
                                            'stringValue': 'EXAMPLE-stringValue-Value',
                                            'intValue': 62,
                                            '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")),
                                position=268,
                                default_value_string="EXAMPLE-defaultValueString-Value",
                                is_mandatory=True)))],
                object_status=292)],
        foreign_keys=[
            oci.data_integration.models.ForeignKey(
                model_type="FOREIGN_KEY",
                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",
                attribute_refs=[
                    oci.data_integration.models.KeyAttribute(
                        position=834,
                        shape_field=oci.data_integration.models.ShapeField(
                            model_type="SHAPE_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_A6Hma': {
                                        'stringValue': 'EXAMPLE-stringValue-Value',
                                        'intValue': 541,
                                        '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=512,
                            name="EXAMPLE-name-Value",
                            description="EXAMPLE-description-Value",
                            type="EXAMPLE-type-Value",
                            labels=["EXAMPLE--Value"],
                            native_shape_field=oci.data_integration.models.NativeShapeField(
                                name="EXAMPLE-name-Value",
                                model_type="EXAMPLE-modelType-Value",
                                type="EXAMPLE-type-Value",
                                config_values=oci.data_integration.models.ConfigValues(
                                    config_param_values={
                                        'EXAMPLE_KEY_q2QMz': {
                                            'stringValue': 'EXAMPLE-stringValue-Value',
                                            'intValue': 985,
                                            '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")),
                                position=657,
                                default_value_string="EXAMPLE-defaultValueString-Value",
                                is_mandatory=False)),
                        attribute=oci.data_integration.models.ShapeField(
                            model_type="SHAPE_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_y99ct': {
                                        'stringValue': 'EXAMPLE-stringValue-Value',
                                        'intValue': 684,
                                        '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=529,
                            name="EXAMPLE-name-Value",
                            description="EXAMPLE-description-Value",
                            type="EXAMPLE-type-Value",
                            labels=["EXAMPLE--Value"],
                            native_shape_field=oci.data_integration.models.NativeShapeField(
                                name="EXAMPLE-name-Value",
                                model_type="EXAMPLE-modelType-Value",
                                type="EXAMPLE-type-Value",
                                config_values=oci.data_integration.models.ConfigValues(
                                    config_param_values={
                                        'EXAMPLE_KEY_tws8p': {
                                            'stringValue': 'EXAMPLE-stringValue-Value',
                                            'intValue': 617,
                                            '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")),
                                position=402,
                                default_value_string="EXAMPLE-defaultValueString-Value",
                                is_mandatory=False)))],
                update_rule=642,
                delete_rule=628,
                reference_unique_key=oci.data_integration.models.PrimaryKey(
                    model_type="PRIMARY_KEY",
                    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",
                    attribute_refs=[
                        oci.data_integration.models.KeyAttribute(
                            position=326,
                            shape_field=oci.data_integration.models.ShapeField(
                                model_type="SHAPE_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_fpnPx': {
                                            'stringValue': 'EXAMPLE-stringValue-Value',
                                            'intValue': 471,
                                            '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=735,
                                name="EXAMPLE-name-Value",
                                description="EXAMPLE-description-Value",
                                type="EXAMPLE-type-Value",
                                labels=["EXAMPLE--Value"],
                                native_shape_field=oci.data_integration.models.NativeShapeField(
                                    name="EXAMPLE-name-Value",
                                    model_type="EXAMPLE-modelType-Value",
                                    type="EXAMPLE-type-Value",
                                    config_values=oci.data_integration.models.ConfigValues(
                                        config_param_values={
                                            'EXAMPLE_KEY_WkjX1': {
                                                'stringValue': 'EXAMPLE-stringValue-Value',
                                                'intValue': 51,
                                                '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")),
                                    position=568,
                                    default_value_string="EXAMPLE-defaultValueString-Value",
                                    is_mandatory=True)),
                            attribute=oci.data_integration.models.ShapeField(
                                model_type="SHAPE_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_8e7fS': {
                                            'stringValue': 'EXAMPLE-stringValue-Value',
                                            'intValue': 679,
                                            '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=851,
                                name="EXAMPLE-name-Value",
                                description="EXAMPLE-description-Value",
                                type="EXAMPLE-type-Value",
                                labels=["EXAMPLE--Value"],
                                native_shape_field=oci.data_integration.models.NativeShapeField(
                                    name="EXAMPLE-name-Value",
                                    model_type="EXAMPLE-modelType-Value",
                                    type="EXAMPLE-type-Value",
                                    config_values=oci.data_integration.models.ConfigValues(
                                        config_param_values={
                                            'EXAMPLE_KEY_ExwW7': {
                                                'stringValue': 'EXAMPLE-stringValue-Value',
                                                'intValue': 904,
                                                '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")),
                                    position=601,
                                    default_value_string="EXAMPLE-defaultValueString-Value",
                                    is_mandatory=True)))],
                    object_status=460),
                object_status=703)],
        resource_name="EXAMPLE-resourceName-Value",
        data_format=oci.data_integration.models.DataFormat(
            format_attribute=oci.data_integration.models.CsvFormatAttribute(
                model_type="CSV_FORMAT",
                is_file_pattern=True,
                encoding="EXAMPLE-encoding-Value",
                escape_character="EXAMPLE-escapeCharacter-Value",
                delimiter="EXAMPLE-delimiter-Value",
                quote_character="EXAMPLE-quoteCharacter-Value",
                has_header=False,
                timestamp_format="EXAMPLE-timestampFormat-Value"),
            type="AVRO",
            compression_config=oci.data_integration.models.Compression(
                codec="DEFLATE")),
        object_status=652,
        identifier="EXAMPLE-identifier-Value",
        sql_query="EXAMPLE-sqlQuery-Value"),
    opc_request_id="QXZIJSXRTUZYQ7PIWQDZ<unique_ID>",
    opc_retry_token="EXAMPLE-opcRetryToken-Value",
    if_match="EXAMPLE-ifMatch-Value")

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