1

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

Coopernicus
  • 85
  • 10

1 Answers1

0

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

Luk3rson
  • 151
  • 1
  • 4