Warning We have announced the end of life of Jobserver and all related Jobserver integrations for September 30, 2024, with the exception of Public Sector customers using GovCloud or on-prem environments.
For information on profiling via Edge, go to Profiling via Edge.
In Collibra 2024.05, we've launched a new user interface (UI) for Collibra Data Intelligence Platform! You can learn more about this latest UI in the UI overview.
Use the following options to see the documentation in the latest UI or in the previous, classic UI:
When Collibra Data Intelligence Platform creates a data profile of registered data, it detects the data type of each column. It's possible that Collibra detects a data type that does not correctly correspond with the actual data type, for example the Text data type is detected for a column, but the actual data in the column are dates.
For more information about the data type detection, see Data type detection via Jobserver.
You can update the data type of each column to ensure that the data is properly managed in Collibra.
Note If you use the Jobserver to register a data source and you have enabled the Anonymize data option in Collibra Console, Collibra detects the data type of a column during profiling and only anonymizes the data if the data type attribute is Text or Geo. Other data types are not anonymized. If you use Edge to register a data source, these columns are automatically anonymized.
Prerequisites
- You have a global role with the Catalog global permission, for example, Catalog Author.
- You have a resource role with the Attribute > Update resource permission.
Steps
There are two ways to modify a column's data type:
- In the data sources table.
- On the Column's asset page.
In the data sources table
-
On the main toolbar, click
, and then click
Catalog.
The Catalog Home opens. - In the submenu, click Data Sources.
- Add the Data Type column to the table.
- Expand the schema and table to see the columns.
- Double-click in the Data Type column and choose the correct data type.
- Click
to apply the change.
On the Column asset page
- Look up the column via the Search function.
Tip If you don't know the exact name of the column name, you can find it via Data Catalog → Data Dictionary and select the All Schemas view. Then click the schema that contains the column and click the column whose data type you want to update.
- In the tab pane, click Data Profiling.
- In the Metadata section, double-click the value of the Data Type parameter.
- In the Summary tab, click Descriptive Statistics.
The Data Type is located in the Metadata tab. - Select the correct type from the Data Type list.
- Click outside the list.
- Click Save.
When you refresh the schema, this change is not overridden.