Applies to: 
Kyvos Enterprise Kyvos Cloud (SaaS on AWS) Kyvos AWS Marketplace
...
| Panel |
|---|
| panelIconId | atlassian-note |
|---|
| panelIcon | :note: |
|---|
| bgColor | #DEEBFF |
|---|
|
Note Kyvos does not support some special characters/values. Either remove them from the source data or contact the Kyvos Support team for assistance.
Example of unsupported values: [New line character 'n', HTML tags, KYVOS_NULL_VALUE, !==!, ~, !__!, !@!, !@@!] |
Formatting data
Kyvos allows you to change the data type for columns while registering datasets. The supported Data Types are char, date, and number.
...
| Panel |
|---|
| panelIconId | atlassian-note |
|---|
| panelIcon | :note: |
|---|
| bgColor | #DEEBFF |
|---|
|
Note If the raw data contains decimal values, Kyvos detects it as a Double, by default. If you do not want any precision loss post cube build-in querying, then set the Data Type of the respective field as Decimal and set the correct precisions and scale to avoid any data inaccuracy and precision loss. Cube build size may increase if the data type is Decimal. From the Kyvos 2023.1 release onwards, the Decimal data type is applicable only when registering a dataset using a BigQuery connection. The Decimal data type will only be applicable to new Register datasets, while the previous data types (long, float, and double) will be used for existing register files.
|
Working with Dates
Generally, date columns store dates as strings. Kyvos then reads the date using the default format YYYY/MM/DD. If the date format of the source data doesn't match the default format, then Kyvos will throw an error while validating the registered dataset. To improve performance and avoid errors, you should specify the format string for the date.
...
