Allow post-join computed columns for columns that begin with underscores
When a column starts with an underscore, it cannot be used in a post-join computed column. For example, this column is defined for every record in the table:
However, the preview fails when it is used in a post-join computed column formula:
Other columns beginning with underscores that I know are fully defined have the same issue. Running the recipe anyways results in the following error:
[Teradata Database] [TeraJDBC 16.20.00.12] [Error 2620] [SQLState HY000] The format or data contains a bad character.
Comments
-
Turribeach Dataiku DSS Core Designer, Neuron, Dataiku DSS Adv Designer, Registered, Neuron 2023 Posts: 2,166 NeuronThis seems a trivial problem to work around. Just don’t start your column names with an underscore.
-
This is a requirement for me to upload items to my database, since the required meta attributes all start with an underscore. I cannot change this. It is less than ideal to replace my entire database to accommodate an issue that Dataiku has, so I am trying to help them and others.
-
Turribeach Dataiku DSS Core Designer, Neuron, Dataiku DSS Adv Designer, Registered, Neuron 2023 Posts: 2,166 Neuron
Again this is fairly trivial to bypass. Use the column without underscore in your flow. In the final output step rename it to have an underscore.