Error "DUPLICATE_DECLARATIVE_COLUMN_INFO" while connecting Quicksight to AWS Catalog via Athena

Question & Answer
,
1

I am trying to connect Quicksight to AWS Catalog via Athena and upon selecting the database and the required table, i am getting an error saying “DUPLICATE_DECLARATIVE_COLUMN_INFO” though there is no duplicate columns. I am able to connect to it when I am using Custom SQL.

It should give me the table data as expected but it didn’t.

1 Like
2

Can you paste the SHOW CREATE TABLE result / SHOW CREATE VIEW in here?

Also, are you saying that you are using SELECT * FROM your_table and it’s working?

3

Hi,

I’ve just had the same problem. In my case I had a column that was containing both float and int written as follow : 10 and 10.00 - I’ve just cast everything in int.

1 Like