Hello Helical Insight,
I was working with Redshift data, and everything appears good till I change the column name to something useful like “Cost of Travel”. Is there a problem with application that alias names are not allowed? The same thing happens when I made a custom column for reporting. I am using the latest version of Helical Insight 5.0
Thanks,
Netta.
Hello Netta,
The issue is not with the Helical Insight application but with the database itself. You are trying to rename columns which include capital letters. You can make the same name with all small case letters and it will work fine. Like in your example: “cost of travel”
The same thing is happening when you do a custom column, the capital case letters are not supported by redshift, unless you explicitly make those settings on database server level.
Including some references from DB provider (Amazon) that might help you further:
https://docs.aws.amazon.com/redshift/latest/dg/cm_chap_ConfigurationRef.html
https://docs.aws.amazon.com/redshift/latest/dg/r_enable_case_sensitive_identifier.html
You need to set property SET enable_case_sensitive_identifier TO true; at database server level so that it becomes case sensitive and then you can give any kind of alias name but if you don’t set this property globally at server level then you have to give all small cases names to your custom column or column alias.
Thanks,
Helical Insight.