When querying athena using aws sdk, is it necessary to save results in s3?

Question

I tried to do a select query on Athena using aws sdk.

In the sample, using resultconfiguration, it was stored in s3 and then queried.

However, it seems that the console showed the select result without saving the query result.

So I skipped resultconfiguration and ran aws sdk, and the following error occurred.

```
An output location is required either through the Workgroup result configuration setting or as an API input.
```

So I think that to query athena from aws sdk, the result must be saved in s3. Is this correct?

If not, please tell me how should I configure the aws sdk.

Lunga T · Accepted Answer

Hello,

Amazon Athena automatically stores query results and metadata information for each query that runs in a query result location that you can specify in Amazon S3.

If necessary, you can access the files in this location to work with them. You can also download query result files directly from the Athena console.

To determine the location that Athena will use you need a combination of a workgroup and client-side settings.

**The client-side settings are based on how you run the query:**

>   If you run the query using the Athena console, the **Query result location** entered under **Settings** in the navigation bar determines the client-side setting.

>   If you run the query using the Athena API, the `OutputLocation` parameter of the StartQueryExecution action determines the client-side setting.

>    If you use the ODBC or JDBC drivers to run queries, the `S3OutputLocation` property specified in the connection URL determines the client-side setting.

To use the AWS CLI to identify the query output location and result files, run the `aws athena get-query-execution` command, as in the following example. 
 ``` bash
aws athena get-query-execution --query-execution-id 
```

**Note:** When you run a query using the API or using the ODBC or JDBC driver, the console setting does not apply.

For more detailed information, refer to [Finding Query Output Files in S3](https://docs.aws.amazon.com/athena/latest/ug/querying.html#querying-finding-output-files).

I hope this helps.

When querying athena using aws sdk, is it necessary to save results in s3?

Contenuto pertinente