PivotField¶
- class oci.data_integration.models.PivotField(**kwargs)¶
Bases:
TypedObjectThe type representing the pivot field. Pivot fields have an expression to define a macro and a pattern to generate the column name
Attributes:
A constant which can be used with the model_type property of a TypedObject.
A constant which can be used with the model_type property of a TypedObject.
A constant which can be used with the model_type property of a TypedObject.
A constant which can be used with the model_type property of a TypedObject.
A constant which can be used with the model_type property of a TypedObject.
A constant which can be used with the model_type property of a TypedObject.
A constant which can be used with the model_type property of a TypedObject.
A constant which can be used with the model_type property of a TypedObject.
A constant which can be used with the model_type property of a TypedObject.
A constant which can be used with the model_type property of a TypedObject.
A constant which can be used with the model_type property of a TypedObject.
A constant which can be used with the model_type property of a TypedObject.
A constant which can be used with the model_type property of a TypedObject.
A constant which can be used with the model_type property of a TypedObject.
A constant which can be used with the model_type property of a TypedObject.
A constant which can be used with the model_type property of a TypedObject.
A constant which can be used with the model_type property of a TypedObject.
A constant which can be used with the model_type property of a TypedObject.
Gets the column_name_pattern of this PivotField.
Gets the config_values of this TypedObject.
Gets the description of this TypedObject.
Gets the expr of this PivotField.
Gets the key of this TypedObject.
[Required] Gets the model_type of this TypedObject.
Gets the model_version of this TypedObject.
Gets the name of this TypedObject.
Gets the object_status of this TypedObject.
Gets the parent_ref of this TypedObject.
Gets the type of this PivotField.
Gets the use_type of this PivotField.
Methods:
__init__(**kwargs)Initializes a new PivotField 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_CONDITIONAL_OUTPUT_PORT = 'CONDITIONAL_OUTPUT_PORT'¶
A constant which can be used with the model_type property of a TypedObject. This constant has a value of “CONDITIONAL_OUTPUT_PORT”
- MODEL_TYPE_DECISION_OUTPUT_PORT = 'DECISION_OUTPUT_PORT'¶
A constant which can be used with the model_type property of a TypedObject. This constant has a value of “DECISION_OUTPUT_PORT”
- MODEL_TYPE_DERIVED_FIELD = 'DERIVED_FIELD'¶
A constant which can be used with the model_type property of a TypedObject. This constant has a value of “DERIVED_FIELD”
- MODEL_TYPE_DYNAMIC_INPUT_FIELD = 'DYNAMIC_INPUT_FIELD'¶
A constant which can be used with the model_type property of a TypedObject. This constant has a value of “DYNAMIC_INPUT_FIELD”
- MODEL_TYPE_DYNAMIC_PROXY_FIELD = 'DYNAMIC_PROXY_FIELD'¶
A constant which can be used with the model_type property of a TypedObject. This constant has a value of “DYNAMIC_PROXY_FIELD”
- MODEL_TYPE_INPUT_FIELD = 'INPUT_FIELD'¶
A constant which can be used with the model_type property of a TypedObject. This constant has a value of “INPUT_FIELD”
- MODEL_TYPE_INPUT_PORT = 'INPUT_PORT'¶
A constant which can be used with the model_type property of a TypedObject. This constant has a value of “INPUT_PORT”
- MODEL_TYPE_INPUT_PROXY_FIELD = 'INPUT_PROXY_FIELD'¶
A constant which can be used with the model_type property of a TypedObject. This constant has a value of “INPUT_PROXY_FIELD”
- MODEL_TYPE_MACRO_FIELD = 'MACRO_FIELD'¶
A constant which can be used with the model_type property of a TypedObject. This constant has a value of “MACRO_FIELD”
- MODEL_TYPE_MACRO_PIVOT_FIELD = 'MACRO_PIVOT_FIELD'¶
A constant which can be used with the model_type property of a TypedObject. This constant has a value of “MACRO_PIVOT_FIELD”
- MODEL_TYPE_MATERIALIZED_DYNAMIC_FIELD = 'MATERIALIZED_DYNAMIC_FIELD'¶
A constant which can be used with the model_type property of a TypedObject. This constant has a value of “MATERIALIZED_DYNAMIC_FIELD”
- MODEL_TYPE_OUTPUT_FIELD = 'OUTPUT_FIELD'¶
A constant which can be used with the model_type property of a TypedObject. This constant has a value of “OUTPUT_FIELD”
- MODEL_TYPE_OUTPUT_PORT = 'OUTPUT_PORT'¶
A constant which can be used with the model_type property of a TypedObject. This constant has a value of “OUTPUT_PORT”
- MODEL_TYPE_PARAMETER = 'PARAMETER'¶
A constant which can be used with the model_type property of a TypedObject. This constant has a value of “PARAMETER”
- MODEL_TYPE_PIVOT_FIELD = 'PIVOT_FIELD'¶
A constant which can be used with the model_type property of a TypedObject. This constant has a value of “PIVOT_FIELD”
- MODEL_TYPE_PROXY_FIELD = 'PROXY_FIELD'¶
A constant which can be used with the model_type property of a TypedObject. This constant has a value of “PROXY_FIELD”
- MODEL_TYPE_SHAPE = 'SHAPE'¶
A constant which can be used with the model_type property of a TypedObject. This constant has a value of “SHAPE”
- MODEL_TYPE_SHAPE_FIELD = 'SHAPE_FIELD'¶
A constant which can be used with the model_type property of a TypedObject. This constant has a value of “SHAPE_FIELD”
- __init__(**kwargs)¶
Initializes a new PivotField object with values from keyword arguments. The default value of the
model_typeattribute of this class isPIVOT_FIELDand 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 PivotField. Allowed values for this property are: “SHAPE”, “INPUT_PORT”, “SHAPE_FIELD”, “INPUT_FIELD”, “DERIVED_FIELD”, “MACRO_FIELD”, “OUTPUT_FIELD”, “DYNAMIC_PROXY_FIELD”, “OUTPUT_PORT”, “DYNAMIC_INPUT_FIELD”, “PROXY_FIELD”, “PARAMETER”, “PIVOT_FIELD”, “MACRO_PIVOT_FIELD”, “CONDITIONAL_OUTPUT_PORT”, “INPUT_PROXY_FIELD”, “MATERIALIZED_DYNAMIC_FIELD”, “DECISION_OUTPUT_PORT”
key (str) – The value to assign to the key property of this PivotField.
model_version (str) – The value to assign to the model_version property of this PivotField.
parent_ref (oci.data_integration.models.ParentReference) – The value to assign to the parent_ref property of this PivotField.
config_values (oci.data_integration.models.ConfigValues) – The value to assign to the config_values property of this PivotField.
object_status (int) – The value to assign to the object_status property of this PivotField.
name (str) – The value to assign to the name property of this PivotField.
description (str) – The value to assign to the description property of this PivotField.
expr (oci.data_integration.models.Expression) – The value to assign to the expr property of this PivotField.
use_type (oci.data_integration.models.ConfiguredType) – The value to assign to the use_type property of this PivotField.
type (oci.data_integration.models.BaseType) – The value to assign to the type property of this PivotField.
column_name_pattern (str) – The value to assign to the column_name_pattern property of this PivotField.
- property column_name_pattern¶
Gets the column_name_pattern of this PivotField. column name pattern can be used to generate the name structure of the generated columns. By default column names are of %PIVOT_KEY_VALUE% or %MACRO_INPUT%_%PIVOT_KEY_VALUE%, but we can change it something by passing something like MY_PREFIX%PIVOT_KEY_VALUE%MY_SUFFIX or MY_PREFIX%MACRO_INPUT%_%PIVOT_KEY_VALUE%MY_SUFFIX which will add custom prefix and suffix to the column name.
- Returns
The column_name_pattern of this PivotField.
- Return type
str
- property config_values¶
Gets the config_values of this TypedObject.
- Returns
The config_values of this TypedObject.
- Return type
- property description¶
Gets the description of this TypedObject. Detailed description for the object.
- Returns
The description of this TypedObject.
- Return type
str
- property expr¶
Gets the expr of this PivotField.
- Returns
The expr of this PivotField.
- Return type
- 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 key¶
Gets the key of this TypedObject. The key of the object.
- Returns
The key of this TypedObject.
- Return type
str
- property model_type¶
[Required] Gets the model_type of this TypedObject. The type of the types object.
Allowed values for this property are: “SHAPE”, “INPUT_PORT”, “SHAPE_FIELD”, “INPUT_FIELD”, “DERIVED_FIELD”, “MACRO_FIELD”, “OUTPUT_FIELD”, “DYNAMIC_PROXY_FIELD”, “OUTPUT_PORT”, “DYNAMIC_INPUT_FIELD”, “PROXY_FIELD”, “PARAMETER”, “PIVOT_FIELD”, “MACRO_PIVOT_FIELD”, “CONDITIONAL_OUTPUT_PORT”, “INPUT_PROXY_FIELD”, “MATERIALIZED_DYNAMIC_FIELD”, “DECISION_OUTPUT_PORT”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.
- Returns
The model_type of this TypedObject.
- Return type
str
- property model_version¶
Gets the model_version of this TypedObject. The model version of an object.
- Returns
The model_version of this TypedObject.
- Return type
str
- property name¶
Gets the name of this TypedObject. 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 TypedObject.
- Return type
str
- property object_status¶
Gets the object_status of this TypedObject. 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 TypedObject.
- Return type
int
- property parent_ref¶
Gets the parent_ref of this TypedObject.
- Returns
The parent_ref of this TypedObject.
- Return type
- property type¶
Gets the type of this PivotField.
- Returns
The type of this PivotField.
- Return type
- property use_type¶
Gets the use_type of this PivotField.
- Returns
The use_type of this PivotField.
- Return type