DataEntityFromSqlEntityDetails¶

class oci.data_integration.models.DataEntityFromSqlEntityDetails(**kwargs)¶

Bases: oci.data_integration.models.data_entity_details.DataEntityDetails

The sql entity data entity details.

Attributes

`ENTITY_TYPE_FILE`	A constant which can be used with the entity_type property of a DataEntityFromSqlEntityDetails.
`ENTITY_TYPE_SQL`	A constant which can be used with the entity_type property of a DataEntityFromSqlEntityDetails.
`ENTITY_TYPE_TABLE`	A constant which can be used with the entity_type property of a DataEntityFromSqlEntityDetails.
`ENTITY_TYPE_VIEW`	A constant which can be used with the entity_type property of a DataEntityFromSqlEntityDetails.
`MODEL_TYPE_DATA_STORE_ENTITY`	str(object=’’) -> str
`MODEL_TYPE_FILE_ENTITY`	str(object=’’) -> str
`MODEL_TYPE_OBJECT_ENTITY`	str(object=’’) -> str
`MODEL_TYPE_SQL_ENTITY`	str(object=’’) -> str
`MODEL_TYPE_TABLE_ENTITY`	str(object=’’) -> str
`MODEL_TYPE_VIEW_ENTITY`	str(object=’’) -> str
`description`	Gets the description of this DataEntityFromSqlEntityDetails.
`entity_type`	Gets the entity_type of this DataEntityFromSqlEntityDetails.
`external_key`	Gets the external_key of this DataEntityFromSqlEntityDetails.
`foreign_keys`	Gets the foreign_keys of this DataEntityFromSqlEntityDetails.
`identifier`	Gets the identifier of this DataEntityFromSqlEntityDetails.
`key`	Gets the key of this DataEntityFromSqlEntityDetails.
`model_type`	[Required] Gets the model_type of this DataEntityDetails.
`model_version`	Gets the model_version of this DataEntityFromSqlEntityDetails.
`name`	Gets the name of this DataEntityFromSqlEntityDetails.
`object_status`	Gets the object_status of this DataEntityFromSqlEntityDetails.
`object_version`	Gets the object_version of this DataEntityFromSqlEntityDetails.
`other_type_label`	Gets the other_type_label of this DataEntityFromSqlEntityDetails.
`parent_ref`	Gets the parent_ref of this DataEntityFromSqlEntityDetails.
`resource_name`	Gets the resource_name of this DataEntityFromSqlEntityDetails.
`shape`	Gets the shape of this DataEntityFromSqlEntityDetails.
`shape_id`	Gets the shape_id of this DataEntityFromSqlEntityDetails.
`sql_query`	Gets the sql_query of this DataEntityFromSqlEntityDetails.
`unique_keys`	Gets the unique_keys of this DataEntityFromSqlEntityDetails.

Methods

`__init__`(**kwargs)	Initializes a new DataEntityFromSqlEntityDetails 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.

ENTITY_TYPE_FILE = 'FILE'¶: A constant which can be used with the entity_type property of a DataEntityFromSqlEntityDetails. This constant has a value of “FILE”

ENTITY_TYPE_SQL = 'SQL'¶: A constant which can be used with the entity_type property of a DataEntityFromSqlEntityDetails. This constant has a value of “SQL”

ENTITY_TYPE_TABLE = 'TABLE'¶: A constant which can be used with the entity_type property of a DataEntityFromSqlEntityDetails. This constant has a value of “TABLE”

ENTITY_TYPE_VIEW = 'VIEW'¶: A constant which can be used with the entity_type property of a DataEntityFromSqlEntityDetails. This constant has a value of “VIEW”

MODEL_TYPE_DATA_STORE_ENTITY = 'DATA_STORE_ENTITY'¶

MODEL_TYPE_FILE_ENTITY = 'FILE_ENTITY'¶

MODEL_TYPE_OBJECT_ENTITY = 'OBJECT_ENTITY'¶

MODEL_TYPE_SQL_ENTITY = 'SQL_ENTITY'¶

MODEL_TYPE_TABLE_ENTITY = 'TABLE_ENTITY'¶

MODEL_TYPE_VIEW_ENTITY = 'VIEW_ENTITY'¶

__init__(**kwargs)¶

Initializes a new DataEntityFromSqlEntityDetails object with values from keyword arguments. The default value of the model_type attribute of this class is SQL_ENTITY 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 DataEntityFromSqlEntityDetails. Allowed values for this property are: “VIEW_ENTITY”, “TABLE_ENTITY”, “FILE_ENTITY”, “SQL_ENTITY”, “OBJECT_ENTITY”, “DATA_STORE_ENTITY”
key (str) – The value to assign to the key property of this DataEntityFromSqlEntityDetails.
model_version (str) – The value to assign to the model_version property of this DataEntityFromSqlEntityDetails.
parent_ref (oci.data_integration.models.ParentReference) – The value to assign to the parent_ref property of this DataEntityFromSqlEntityDetails.
name (str) – The value to assign to the name property of this DataEntityFromSqlEntityDetails.
description (str) – The value to assign to the description property of this DataEntityFromSqlEntityDetails.
object_version (int) – The value to assign to the object_version property of this DataEntityFromSqlEntityDetails.
external_key (str) – The value to assign to the external_key property of this DataEntityFromSqlEntityDetails.
shape (oci.data_integration.models.Shape) – The value to assign to the shape property of this DataEntityFromSqlEntityDetails.
shape_id (str) – The value to assign to the shape_id property of this DataEntityFromSqlEntityDetails.
entity_type (str) – The value to assign to the entity_type property of this DataEntityFromSqlEntityDetails. Allowed values for this property are: “TABLE”, “VIEW”, “FILE”, “SQL”
other_type_label (str) – The value to assign to the other_type_label property of this DataEntityFromSqlEntityDetails.
unique_keys (list[oci.data_integration.models.UniqueKey]) – The value to assign to the unique_keys property of this DataEntityFromSqlEntityDetails.
foreign_keys (list[oci.data_integration.models.ForeignKey]) – The value to assign to the foreign_keys property of this DataEntityFromSqlEntityDetails.
resource_name (str) – The value to assign to the resource_name property of this DataEntityFromSqlEntityDetails.
object_status (int) – The value to assign to the object_status property of this DataEntityFromSqlEntityDetails.
identifier (str) – The value to assign to the identifier property of this DataEntityFromSqlEntityDetails.
sql_query (str) – The value to assign to the sql_query property of this DataEntityFromSqlEntityDetails.

description¶

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

Returns:	The description of this DataEntityFromSqlEntityDetails.
Return type:	str

entity_type¶

Gets the entity_type of this DataEntityFromSqlEntityDetails. The entity type.

Allowed values for this property are: “TABLE”, “VIEW”, “FILE”, “SQL”

Returns:	The entity_type of this DataEntityFromSqlEntityDetails.
Return type:	str

external_key¶

Gets the external_key of this DataEntityFromSqlEntityDetails. The external key for the object

Returns:	The external_key of this DataEntityFromSqlEntityDetails.
Return type:	str

foreign_keys¶

Gets the foreign_keys of this DataEntityFromSqlEntityDetails. An array of foreign keys.

Returns:	The foreign_keys of this DataEntityFromSqlEntityDetails.
Return type:	list[oci.data_integration.models.ForeignKey]

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.

identifier¶

Gets the identifier of this DataEntityFromSqlEntityDetails. 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 DataEntityFromSqlEntityDetails.
Return type:	str

key¶

Gets the key of this DataEntityFromSqlEntityDetails. The object key.

Returns:	The key of this DataEntityFromSqlEntityDetails.
Return type:	str

model_type¶

[Required] Gets the model_type of this DataEntityDetails. The data entity type.

Allowed values for this property are: “VIEW_ENTITY”, “TABLE_ENTITY”, “FILE_ENTITY”, “SQL_ENTITY”, “OBJECT_ENTITY”, “DATA_STORE_ENTITY”

Returns:	The model_type of this DataEntityDetails.
Return type:	str

model_version¶

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

Returns:	The model_version of this DataEntityFromSqlEntityDetails.
Return type:	str

name¶

Gets the name of this DataEntityFromSqlEntityDetails. 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 DataEntityFromSqlEntityDetails.
Return type:	str

object_status¶

Gets the object_status of this DataEntityFromSqlEntityDetails. 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 DataEntityFromSqlEntityDetails.
Return type:	int

object_version¶

Gets the object_version of this DataEntityFromSqlEntityDetails. The version of the object that is used to track changes in the object instance.

Returns:	The object_version of this DataEntityFromSqlEntityDetails.
Return type:	int

other_type_label¶

Gets the other_type_label of this DataEntityFromSqlEntityDetails. Specifies other type labels.

Returns:	The other_type_label of this DataEntityFromSqlEntityDetails.
Return type:	str

parent_ref¶

Gets the parent_ref of this DataEntityFromSqlEntityDetails.

Returns:	The parent_ref of this DataEntityFromSqlEntityDetails.
Return type:	oci.data_integration.models.ParentReference

resource_name¶

Gets the resource_name of this DataEntityFromSqlEntityDetails. The resource name.

Returns:	The resource_name of this DataEntityFromSqlEntityDetails.
Return type:	str

shape¶

Gets the shape of this DataEntityFromSqlEntityDetails.

Returns:	The shape of this DataEntityFromSqlEntityDetails.
Return type:	oci.data_integration.models.Shape

shape_id¶

Gets the shape_id of this DataEntityFromSqlEntityDetails. The shape ID.

Returns:	The shape_id of this DataEntityFromSqlEntityDetails.
Return type:	str

sql_query¶

Gets the sql_query of this DataEntityFromSqlEntityDetails. sqlQuery

Returns:	The sql_query of this DataEntityFromSqlEntityDetails.
Return type:	str

unique_keys¶

Gets the unique_keys of this DataEntityFromSqlEntityDetails. An array of unique keys.

Returns:	The unique_keys of this DataEntityFromSqlEntityDetails.
Return type:	list[oci.data_integration.models.UniqueKey]