# 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=459,
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_nlhOc': {
'stringValue': 'EXAMPLE-stringValue-Value',
'intValue': 140,
'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=237,
name="EXAMPLE-name-Value",
description="EXAMPLE-description-Value",
type=oci.data_integration.models.DynamicType(
model_type="DYNAMIC_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=412,
description="EXAMPLE-description-Value",
type_handler=oci.data_integration.models.FlattenTypeHandler(
model_type="FLATTEN_TYPE_HANDLER",
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"),
scope="EXAMPLE-scope-Value",
flatten_details="EXAMPLE-flattenDetails-Value",
config_values=oci.data_integration.models.ConfigValues(
config_param_values={
'EXAMPLE_KEY_6XXME': {
'stringValue': 'EXAMPLE-stringValue-Value',
'intValue': 359,
'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=91),
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=True,
object_status=748,
config_parameter_definitions={
'EXAMPLE_KEY_Epxqd': {
'parameterName': 'EXAMPLE-parameterName-Value',
'description': 'EXAMPLE-description-Value',
'defaultValue': 'EXAMPLE-defaultValue-Value',
'classFieldName': 'EXAMPLE-classFieldName-Value',
'isStatic': True,
'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=560,
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_X8dFl': {
'stringValue': 'EXAMPLE-stringValue-Value',
'intValue': 763,
'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=923,
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_CdFl1': {
'stringValue': 'EXAMPLE-stringValue-Value',
'intValue': 459,
'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=536,
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_nPY9z': {
'stringValue': 'EXAMPLE-stringValue-Value',
'intValue': 369,
'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=232,
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_UZU2X': {
'stringValue': 'EXAMPLE-stringValue-Value',
'intValue': 795,
'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=6,
default_value_string="EXAMPLE-defaultValueString-Value",
is_mandatory=True)))],
object_status=178)],
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=877,
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_8YRaX': {
'stringValue': 'EXAMPLE-stringValue-Value',
'intValue': 802,
'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=967,
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_OSDvX': {
'stringValue': 'EXAMPLE-stringValue-Value',
'intValue': 102,
'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=544,
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_9KTit': {
'stringValue': 'EXAMPLE-stringValue-Value',
'intValue': 225,
'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=32,
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_mf9Zr': {
'stringValue': 'EXAMPLE-stringValue-Value',
'intValue': 526,
'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=689,
default_value_string="EXAMPLE-defaultValueString-Value",
is_mandatory=False)))],
update_rule=702,
delete_rule=527,
reference_unique_key=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=929,
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_QImfr': {
'stringValue': 'EXAMPLE-stringValue-Value',
'intValue': 997,
'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=356,
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_CkOGf': {
'stringValue': 'EXAMPLE-stringValue-Value',
'intValue': 912,
'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=97,
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_bW82J': {
'stringValue': 'EXAMPLE-stringValue-Value',
'intValue': 443,
'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=394,
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_bUf8c': {
'stringValue': 'EXAMPLE-stringValue-Value',
'intValue': 179,
'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=970,
default_value_string="EXAMPLE-defaultValueString-Value",
is_mandatory=False)))],
object_status=554),
object_status=215)],
resource_name="EXAMPLE-resourceName-Value",
data_format=oci.data_integration.models.DataFormat(
format_attribute=oci.data_integration.models.JsonFormatAttribute(
model_type="JSON_FORMAT",
is_file_pattern=True,
encoding="EXAMPLE-encoding-Value",
sample_entity_data="EXAMPLE-sampleEntityData-Value"),
type="AVRO",
compression_config=oci.data_integration.models.Compression(
codec="SNAPPY")),
object_status=363,
identifier="EXAMPLE-identifier-Value",
sql_query="EXAMPLE-sqlQuery-Value"),
opc_request_id="NW3KNMVQORPJPWEPYNYM<unique_ID>",
opc_retry_token="EXAMPLE-opcRetryToken-Value",
if_match="EXAMPLE-ifMatch-Value")
# Get the data from response
print(create_entity_shape_response.data)