Known Issues and Limitations
Asset Registration
Names are case-sensitive when registering an asset, schema, or table.
Policies and Rules
Upon deployment of the platform, we recommend that you immediately configure the behavior of access control rules to allow or deny access. If however, you wish to change this behavior at a later stage, you must delete all access control rules prior to making this change.
The platform does not fully support Boolean data types. Using them in cell-level transformations might result in a SQL error.
Projects
Only an exchange administrator or the project owner (creator) may modify, delete, add assets to, or remove assets from a project. We introduced this change to support the new project membership feature.
When searching for users and user groups to add as members of a project or dataset, the search returns all enterprise users and user groups, including those who may not have access to the data exchange. The platform performs against the internal registry or the LDAP registry.
If a user who is not a member of a project attempts to query data in it, the platform may return a generic error that does not inform the user that they are not authorized to access the data.
When a project owner edits a published project, the project moves to In Draft status, preventing data consumers from being able to consume data until a data guardian re-approves the project.
When editing a rejected project, a data consumer can remove all but one asset. A rejected project requires at least one asset so a data consumer can re-submit it for approval.
Datasets and Assets
Only an exchange administrator or the dataset owner (creator) may modify or delete a dataset. We introduced this change to support the new dataset membership feature.
If the dataset membership is restricted, only an exchange administrator, a member of the dataset, or the dataset owner (creator) may register, modify, or delete an asset within the specified dataset. We introduce this change to support the new dataset membership feature.
Business Information
You cannot edit or remove any data classes, terms, or tags that are in use.
REST APIs
When a data owner uses the REST API to create a new asset, the platform creates the asset in In Draft status, and a data guardian must approve it.
If you have an LDAP group with no users, the User Group API will return an error message.
Only an exchange administrator or the project owner (creator) may modify, delete, add assets to, or remove assets from a project. We introduced this change to support the new project membership feature.
Only an exchange administrator or the dataset owner (creator) may modify or delete a dataset. We introduced this change to support the new dataset membership feature.
If the dataset membership is restricted, only an exchange administrator, a member of the dataset, or the dataset owner (creator) may register, modify, or delete an asset within the specified dataset. We introduce this change to support the new dataset membership feature.
Nested LDAP Groups
You must explicitly add all LDAP user groups and give them a role on the platform. This includes all nested groups.
User Role Assignment
When changing the user role assignment of a user or group, it may take a few moments for the change to take effect. You should log in to the platform again for the changed role assignment to take effect.
Google BigQuery
The following Denodo VQL functions may show unexpected behavior or errors:
Scalar functions:
acos, ascii, atan, atan2, cos, cot, char, degrees, firstdayofmonth, firstdayofweek, getdaysbetween, getmonthsbetween, getdayofweek, getdayofyear, gethour, getminute, getsecond, gettimeinmillis, getmillisecond, getmicrosecond, getquarter, getweek, lastdayofmonth, lastdayofweek, nextweekday, previousweekday, pi, radians, removeaccents, sin, tan, sql_trim, textconstant, to_localdate, to_time, to_timestamp, to_timestamptz, position, localtimestamp(evaluate_literal)
Windowing functions:
percent_rank, percentile_disc, cume_dist, ntile, first_value, last_value