amazon redshift - OLE DB error: OLE DB or ODBC error: Undefined column name - Stack Overflow

I am trying to run SSAS cubes. While running getting error like

OLE DB error: OLE DB or ODBC error: Undefined column name sh.SiteHours_Id.

The source tables are present in redshift database. I checked the column is already there in the redshift database.

I checked the relation between the fact and dimension tables as well manually. I did not find any issues there as well. Not able to resolve this issue. Can anyone please guide me how can i resolve this issue.

I am trying to run SSAS cubes. While running getting error like

OLE DB error: OLE DB or ODBC error: Undefined column name sh.SiteHours_Id.

The source tables are present in redshift database. I checked the column is already there in the redshift database.

I checked the relation between the fact and dimension tables as well manually. I did not find any issues there as well. Not able to resolve this issue. Can anyone please guide me how can i resolve this issue.

• odbc
• amazon-redshift
• ssas
• oledb
• cube

Share Improve this question Follow asked Feb 3 at 20:46 insanityinsanity 1,17866 gold badges1616 silver badges3030 bronze badges

Add a comment  | 

1 Answer 1

Sorted by: Reset to default 0

Little to go on here but I'll take a stab.

You error message has mixed case letters for the column name and usually this won't be an issue but Redshift connections can be configured to enable case sensitivity. Check the setting of this configuration value. If "true" it would explain why the column wasn't found.

See: https://docs.aws.amazon.com/redshift/latest/dg/r_enable_case_sensitive_identifier.html