CODEWITHSUNDEEP
alteryxamazon-athena
Coopernicus
Coopernicus

Reputation: 95

Create/Drop Tables in Athena using Alteryx Designer

is there way to drop and create tables in Athena from Alteryx Designer? I thought it would be dead simple using the connect In DB node and writing

drop table test

But I'm getting the following error

Connect In-DB (3)   Error SQLPrepare: [Simba][Athena] (1040) An error has been thrown from the AWS Athena client. Athena Error No: 130, HTTP Response Code: 400, Exception Name: InvalidRequestException, Error Message: line 1:30: mismatched input 'drop'. Expecting: '(', 'LATERAL', 'UNNEST', <identifier> [Execution ID: ]

Is there a way to it? Thanks

Upvotes: 1

Views: 243

Answers (2)

saubert
saubert

Reputation: 1

Using the connect In DB node and writing a drop query is not allowed... only select type queries are allowed. (and by the way,Athena is not supported for in database, cf Ideas to support Athena

So you must use standard output tool with a bulk load enter image description here

Best regards,

Simon

Upvotes: 0

Luk3rson
Luk3rson

Reputation: 171

I would use the Athena Bulk Loader in Output Data tool. This has functionality you need. Data Connections > Amazon Athena > Bulk

enter image description here

Upvotes: 0

Related Questions