You can translate the question and the replies:

Column Names and reserve words

Denodo is throwing error for below, 1. column name starting with “Underscore” . 2. column name “asoftimestamp” any idea, is this a reserved word ?
03-01-2022 14:27:48 -0500

1 Answer

Hi, I would like to inform you that Denodo **accepts** the field names that begin with underscore. However, Denodo throws an error when the [view name]( starts with an underscore. In Denodo, you could not use [reserved words]( as a view name or column name. For your scenario, ‘AS OF TIMESTAMP’ is **not a reserved one** which is simply a clause statement. In a data recovery context, it is useful to be able to query the state of the view at a previous time. For more information, you could refer to the [Syntax Conventions]( section of the Virtual DataPort VQL guide. Hope this helps!
Denodo Team
04-01-2022 01:56:09 -0500
You must sign in to add an answer. If you do not have an account, you can register here