Attributes
Entities contain attributes. Attributes are managed in the entity attributes tab where attributes can be created, soft deleted and restored.
Entity import
Entity and attribute definitions can be imported into Agile Data Engine. This is the recommended way for creating source entities for incoming data.
See also:
Tutorials
See the below video for a quick tutorial on how to create an attribute.
https://youtu.be/yFV1dm-cKB8Managing attributes
In Attributes tab (Entities -> Attributes) you can:
Create an attribute.
Soft Delete an attribute.
Edit an attribute.
View soft deleded attributes by toggling the slider.
Restore soft deleted attributes when the slider is toggled:
Attribute properties
Property | Description |
|---|---|
ATTRIBUTE NAME | Case-insensitive attribute name. Attribute names will be in lowercase in the DDL executed in target databases. |
DATA TYPE | Attribute value data type in Agile Data Engine format. Data types will be resolved to target database types during deployment. Export SQL to examine resolved data types before deployment. Use CONFIG_DATATYPES to manage available data types. |
System attribute type that can have transformations and load automation patterns related to it. See main article for further information. | |
DATA LENGTH | Defines attribute length/size for specific data types such as strings. |
DATA PRECISION | Defines the number of digits in a number for fixed-point numeric data types. For example, the number 1234.56 has a precision of 6. |
DATA SCALE | Defines the number of decimals in a number for fixed-point numeric data types. For example, the number 1234.56 has a scale of 2. |
DEFAULT VALUE | Defines a default value or expression for an attribute. |
POSITION | Defines the position (order) of an attribute in an entity. Note that depending on the target database management system, changing the attribute order might not have an effect unless FORCE RECREATION is used. |
NULLABLE? | Defines if the attribute accepts null values. Note that an attribute cannot be changed to non-nullable if it already contains null values. |
COMPRESSION TYPE | AMAZON REDSHIFT ONLY: Encoding type for attribute, see Amazon Redshift documentation for further information. |
Agile Data Engine supports column level collation definition in specific target database management systems. See main article for further information. | |
Agile Data Engine supports column masking policies to protect sensitive data in specific target database management systems. See main article for further information. | |
DESCRIPTION | Attribute description/comment which is also written into the target database. |