Period in column name


We are trying to construct a domain based on a Redshift (postgres) data source.

The table has columns that have periods in the column names, when saving the domain we get the following error

The Domain schema is invalid. Review the schema.
The Domain schema has an invalid set or item definitions.
The Domain set or item public_logtable_100._customer.__createdat references an invalid resource [public_logtable_100._customer.__createdat].

the error above relates to a column names "_customer.__createdat" - which is a valid column name in redshift

Is there anyway around this - renaming the columns is not going to be possible

gareth.james's picture
Joined: Mar 6 2015 - 9:58am
Last seen: 6 years 1 month ago

What version of JRS are you using? Although I am not too certain about redshift but there was some work done with period in column name on JRS 6.0.

nthapa - 6 years 1 month ago

0 Answers:

No answers yet