Editor (or system) attributes are attributes available "by default," which cannot be modified by users. They can be recognized by the cloud icon next to their name.
These attributes let you quickly display information about your data without having to create it yourself.
Common Attributes
| Name | Attribute Type | Definition | Imported by a connector |
|---|---|---|---|
| Aggregatable | Boolean | Indicates whether the field can be aggregated. | Yes |
| Calculated | Boolean | Indicates whether the field is calculated | |
| CDO | Users | Editor attribute used to define and display the "Chief Data Officer" on an object. The CDO is an official DataGalaxy role that can only be assigned to licensed users | |
| CISO | Users | Editor attribute used to define and display the "Chief Information Security Officer" on an object. The CISO is an official DataGalaxy role that can only be assigned to licensed users | |
| PII Classes | List of values | Editor attribute used to classify data according to a sensitivity level. | |
| Partition Key | Boolean | Indicates whether the field is part of a partition key | BigQuery |
| Expiration date of the source object | Date | Expiration date in the source system | BigQuery |
Creation date of the source object | Date | Creation date in the source system | BigQuery, Snowflake, Power BI Services, Tableau |
| Last Synchronization Date | Date | Date of the last synchronization | |
| Deletion date of the source object | Date | Deletion date in the source system | |
| Last Access Date | Date | Deletion date in the source system | |
| Last execution | Date | Date of the last execution in the source system | |
| Last Data Refresh | Date | Date of the last data refresh | |
| Last modification date of the source object | Date | Date of the last modification in the source system | BigQuery (?) Snowflake (?) |
| Description | Formatted text | Editor attribute used to enter a description of the object | |
| Domain | Shortcut | Editor shortcut attribute used to display an object's domains as tags. This attribute also allows adding/removing links between an object and its domains | |
| DPO | Users | Editor attribute used to define and display the Data Protection Officer on an object. The DPO is an official DataGalaxy role that can only be assigned to licensed users | |
| Labels | Custom label | Editor attribute used to create labels to attach to objects. These labels can be searched via global search features, notably via the # shortcut | |
| Data sample | Formatted text | Data sample | |
| Expert | Users | Editor attribute used to define and display an expert user on an object. Expert is an official DataGalaxy role that can only be assigned to licensed users | |
| Expression | Formatted text | Expression or formula | Power BI Services |
| Required filter | Boolean | Indicates whether a filter is required when querying the structure | |
| Format | Text | Field format | |
| External Id | Text | External identifier | Snowflake |
| Indexed | Boolean | Indicates whether the field is indexed | |
| Functional Label | Text | Editor attribute used to display the functional name | |
| Link to Source | Text | Link expression to the object in the source system | |
| Geographical Location | Text | Geographical location | Snowflake |
| Access Count | Number | Number of accesses in the source system (last 30 days) | |
| Write Access Count | Number | Number of write accesses in the source system (last 30 days) | |
| Read Access Count | Number | Number of read accesses in the source system (last 30 days) | |
| User Access Count | Number | Number of user accesses in the source system (last 30 days) | |
| User Write Access Count | Number | Number of user write accesses in the source system (last 30 days) | |
| User Read Access Count | Number | Number of user read accesses in the source system (last 30 days) | |
| Children count | Number | Calculated editor attribute used to display the number of children of an object. A child being a level-1 descendant. | |
| Number of records | Number | Current record count | BigQuery, Snowflake |
| Historical number of records | Time series | Historical record count | Snowflake |
| Descendants count | Number | Calculated editor attribute used to display the total number of descendants of an object. Descendants are its children, its children's children, and so on. | |
| Current distinct value count | Number | Current number of distinct values | |
| Historical distinct value count | Time series | Historical number of distinct values | |
| Number of Empty Values | Number | Current number of empty values | |
| Current empty value count | Time series | Historical number of empty values | |
| Denied Access Count | Number | Number of denied accesses in the source system (last 30 days) | |
| User Denied Access Count | Number | Number of user denied accesses in the source system (last 30 days) | |
| Parent | Shortcut | Shortcut attribute used to display an object's parent as tags. This attribute also allows modifying the parent relationship of an object directly from its object sheet. | |
| Partitioned | Boolean | Indicates whether the structure is partitioned | BigQuery |
| Path | Non-editable editor attribute used to display the full ancestor hierarchy of an object as a sequence of objects with icons. | ||
| Path (text) | Non-editable editor attribute used to display the full ancestor hierarchy of an object as a complete string, in a format usable for DataGalaxy CSV imports. This attribute is useful for copy/pasting an object's full path. | ||
| Top users | Text | Frequent users in the source system | |
| Owners | Users | Editor attribute used to define and display the Data Owner on an object. Owner is an official DataGalaxy role that can only be assigned to licensed users | |
| Query | Formatted text | Query | BigQuery, Power BI Services |
| Summary | Text | Editor attribute used to enter a summary of the object | |
| PII with Risk | List of values | Personal data risk | |
| Status | List of values | Editor attribute used to indicate the status of the object among the values: Proposed, Under Review, Under Validation, Validated, Deprecated | |
| Last Execution Status | Text | Status of the last execution in the source system | |
| Stewards | Users | Editor attribute used to define and display the Data Stewards on an object. Owner is an official DataGalaxy role that can only be assigned to licensed users | |
| Current Storage Size | Number | Current storage size | BigQuery, Snowflake |
| Historical Storage Size | Time series | Historical storage size | Snowflake |
| Personal Data Type | Hierarchy | Editor attribute used to define the type of personal data concerned by an object, from a predefined list | |
| Sensitive Data Type | Hierarchy | Editor attribute used to define the type of sensitive data concerned by an object, from a predefined list | |
| Physical Person Type | Hierarchy | Editor attribute used to define the type of individual concerned by an object, from a predefined list | |
| Technical Type | Text | Object type in the source system | BigQuery, Power BI Services, Tableau |
| Storage Unit | Text | Unit of storage size | BigQuery, Snowflake |
| Universe | Shortcuts | Editor shortcut attribute used to display an object's universe as tags. This attribute also allows adding/removing links between an object and its universe | |
| URL | Hyperlink | External URL of the object in the source system | Power BI Services, Tableau |
| Last modified by | Text | User who performed the last modification in the source system |
Glossary Attributes
| Name | Attribute Type | Definition | Imported by a connector |
|---|---|---|---|
| Code | Text | Code of the reference value | |
| Validity start | Date | Start date of validity of the reference value | |
| Dimension | Shortcut | Editor shortcut attribute used to display an object's dimensions as tags. This attribute also allows adding/removing links between an object and its dimensions | |
| Is Personal Data | Boolean | Editor attribute used to indicate whether an object is personal data in its own right | |
| Is Sensitive Data | Boolean | Editor attribute used to indicate whether an object is sensitive data in its own right | |
| Validity end | Date | End date of validity of the reference value | |
| Nomenclature | Shortcut | Editor shortcut attribute used to display an object's nomenclatures as tags. This attribute also allows adding/removing links between an object and its nomenclatures. | |
Recording system | Shortcut | Editor shortcut attribute used to display an object's systems of record as tags. This attribute also allows adding/removing links between an object and its systems of record. A System of Record can be a data source or a data source container. | |
| Free Text 1 | Text | Editor attribute used to add additional information to a reference value | |
| Free Text 2 | Text | Editor attribute used to add additional information to a reference value | |
| Type | List of values | Editor attribute used to display the object's type | |
| Use | Shortcut | Editor shortcut attribute used to display an object's usages as tags. This attribute also allows adding/removing links between an object and its usages |
Dictionary Attributes
Sources
| Name | Attribute Type | Definition | Imported by a connector |
|---|---|---|---|
| Contains Personal Data | Boolean | Editor attribute used to indicate whether an object contains personal data | |
| Contains Sensitive Data | Boolean | Editor attribute used to indicate whether an object contains sensitive data | |
| Technical Label | Text | Editor attribute used to display the technical name | |
| Schema | Text | Schema | |
| Technology | List of values | Editor attribute used to indicate an object's technology | |
| Type | List of values | Editor attribute used to display the object's type | |
| Use | Shortcut | Editor shortcut attribute used to display an object's usages as tags. This attribute also allows adding/removing links between an object and its usages |
Containers
| Name | Attribute Type | Definition | Imported by a connector |
|---|---|---|---|
| Contains Personal Data | Boolean | Editor attribute used to indicate whether an object contains personal data | |
| Contains Sensitive Data | Boolean | Editor attribute used to indicate whether an object contains sensitive data | |
| Technical Label | Text | Editor attribute used to display the technical name | |
| Technology | List of values | Editor attribute used to indicate an object's technology | |
| Type | List of values | Editor attribute used to display the object's type | |
| Use | Shortcut | Editor shortcut attribute used to display an object's usages as tags. This attribute also allows adding/removing links between an object and its usages |
Structures
| Name | Attribute Type | Definition | Imported by a connector |
|---|---|---|---|
| Technical Comments | Formatted text | Technical comments | BigQuery, Snowflake |
| Contains Personal Data | Boolean | Editor attribute used to indicate whether an object contains personal data | |
| Contains Sensitive Data | Boolean | Editor attribute used to indicate whether an object contains sensitive data | |
| Technical Label | Text | Editor attribute used to display the technical name | |
| Primary Key Technical Label | Text | Editor attribute used to display the technical name of the table's primary key | |
| Technology | List of values | Editor attribute used to indicate an object's technology | |
| Type | List of values | Editor attribute used to display the object's type | |
| Use | Shortcut | Editor shortcut attribute used to display an object's usages as tags. This attribute also allows adding/removing links between an object and its usages |
Fields
| Name | Attribute Type | Definition | Imported by a connector |
|---|---|---|---|
| Foreign Key | Boolean | Editor attribute used to define and identify whether a piece of data belongs to a foreign key | |
| Primary Key | Boolean | Editor attribute used to define and identify whether a piece of data belongs to a primary key | |
| Technical Comments | Formatted text | Technical comments | |
| Is Personal Data | Boolean | Editor attribute used to indicate whether an object contains personal data | |
| Is Sensitive Data | Boolean | Editor attribute used to indicate whether an object contains sensitive data | |
| Structure Functional Label | Text | Structure's functional label | |
| Technical Label | Text | Editor attribute used to display the technical name | |
| Structure Technical Label | Text | Structure's technical label | |
| Mandatory | Boolean | Editor attribute used to define and identify whether a column is required (non-nullable) | |
| Technical | Boolean | Editor attribute used to define and identify whether a piece of data is technical | |
| Technology | Technology | Editor attribute used to indicate an object's technology | |
| Type | Column type, size, and precision | Editor attribute used to indicate whether the column's precision is required | |
| Type | Type | Editor attribute used to display the object's type | |
| Use | Shortcut | Editor shortcut attribute used to display an object's usages as tags. This attribute also allows adding/removing links between an object and its usages |
Processing Attributes
| Name | Attribute Type | Definition | Imported by a connector |
|---|---|---|---|
| Contains Personal Data | Boolean | Editor attribute used to indicate whether an object contains personal data | |
| Contains Sensitive Data | Boolean | Editor attribute used to indicate whether an object contains sensitive data | |
| Technical Label | Text | Editor attribute used to display the technical name | |
| Technology | List of values | Editor attribute used to indicate an object's technology | |
| Type | List of values | Editor attribute used to display the object's type |
Usage Attributes
| Name | Attribute Type | Definition | Imported by a connector |
|---|---|---|---|
Impact Analysis Type | List of values | Editor attribute used to define and identify whether an object requires a PIA (Privacy Impact Assessment), among the values: Mandatory, Recommended, None | |
| Individual's Consent | Hierarchy | ||
| Contains Personal Data | Boolean | Editor attribute used to indicate whether an object contains personal data | |
| Contains Sensitive Data | Boolean | Editor attribute used to indicate whether an object contains sensitive data | |
| Usage Start Date | Date | Editor attribute used to define the start date of the usage for GDPR purposes | |
| Dimension | Shortcut | Editor shortcut attribute used to display an object's dimensions as tags. This attribute also allows adding/removing links between an object and its dimensions | |
| PII Policy | Hierarchy | Editor attribute used to define the type of access right to personal data among the values: Other, Unavailable, Online Access, By Mail, On-Site, By Email | |
| PII Portability Policy | Hierarchy | Editor attribute used to define the portability right of personal data and the available format | |
| Data Retention policy | Text | Editor attribute used to define the data retention period for GDPR purposes | |
| Usage Duration | Text | Editor attribute used to define the duration of the usage for GDPR purposes | |
| Consent Exception type | Hierarchy | Editor attribute used to define the type of consent exception concerned by an object, from a predefined list | |
| Main Purpose | Formatted text | Editor attribute used to define the main purpose of the usage | |
| Secondary Purpose | Formatted text | Editor attribute used to define the secondary purpose of the usage | |
| Person Information Type | Hierarchy | Editor attribute used to define the type of information provided to individuals concerned by an object, from a predefined list | |
| Technical Label | Text | Editor attribute used to display the technical name | |
| Usage nature | List of values | Editor attribute used to define the nature of the usage from a predefined list | |
Impact Analysis Url | Hyperlink | Editor attribute used to define the hyperlink to the PIA | |
| Source | Shortcut | Editor shortcut attribute used to display an object's source as tags. This attribute also allows adding/removing links between an object and its source. The source can only be a source or a container. | |
| Technology | List of values | Editor attribute used to indicate an object's technology | |
| Type | List of values | Editor attribute used to display the object's type | |
| Component Type | List of values | Editor attribute used to display the component type |
Diagram Attributes
| Name | Attribute Type | Definition | Imported by a connector |
|---|---|---|---|
| Visual Data | Text | ||
| Technical Label | Text | Editor attribute used to display the technical name | |
| Publishing status | List of values | ||
| Type | List of values | Editor attribute used to display the object's type |