Forum Discussion

merinmione's avatar
merinmione
Helper I
6 years ago

Prepared statements? Amazon Redshift ODBC Error prepared statements

hi, i'm trying to connect to an Amazon redshift database to get Greenhouse data (recruiting system) but i keep getting an error.   DataSource.Error: ODBC: ERROR [42P05] [Microsoft][Amazon Redshift]...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Following this thread as we got the same error using Tableau with Amazon Redshift connector to Greenhouse. Been using it for 6 months with no issues, then all of a sudden our Tableau online extract refreshes started failing with the exact same error message.

 

It only seems to be impacting our tableau online extract refreshes, we are able to connect using Tableau desktop and refresh fine aswell as connect tableau online workbooks to amazon redshift. 

 

Hopefull if you are able to resolve with PowerBi it could be the same issue in Tableau. 

merinmione's avatar
merinmione
Helper I
6 years ago

I've tested the PostgresSQL's ODBC that GH gave me and it worked. I had one table that gave me an error, that the fetched item was truncated. But i don't need that table, so I didn't select it next time and it worked fine.