I'd like to insert records to AWS Athena table directory.

Hi all,

I’d like to insert recode to AWS Athena table directory.
Is it possible?

Currently, I create csv(gzip) files and upload to S3.
Then, Tableau Online connect AWS Athena table and make some dashboard.

Best regards,
TK

20210204-1

Hello takushikanai,
the support for inserting values into Athena via an INSERT statement are quite limited as of today since every statement call creates a new file in the correspondingS3 bucket which would result in a file per row. That is why the DB Insert node is not supported with Athena.
To insert data I would suggest to write the data directly into the S3 bucket the table is based on. When using the new file handling nodes this should be fairly easy to do.
Bye
Tobias

2 Likes

Hi Tobias,

Thank you very much for reply and alternative method.
I did it and it looks good!

Best regards,
TK
20210205-2

2 Likes

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.