Can I run Athena query from sql file stored in S3

Question

I have a .sql file filled with Athena queries.

Is there a way I can tell Athena to run the sql queries saved in s3://my-bucket/path/to/queries.sql?

In MySQL can do something like this (based in SO answer), but curious if possible in Athena

mysql> source \home\user\Desktop\test.sql;

Red Boy · Accepted Answer · 2020-01-12 13:07:52Z

1

Is there a way I can tell Athena to run the sql queries saved in s3://my-bucket/path/to/queries.sql?

I think there is no direct way to tell Athena to run query stored in S3.

In MySQL can do something like this (based in SO answer), but curious if possible in Athena.

If you want to do it at all, then yes, you should be able to run the query using AWS CLI. Your steps should be look like this.

Hope this will help.

answered Jan 12, 2020 at 13:07

Red Boy

5,7893 gold badges35 silver badges49 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1