検索
検索

How to query in AWS athena connected through S3 using lambda functions in python

debugcn 投稿 Dev
5
Vipendra Singh

I have my .csv files saved in the S3 Bucket. I am able to query the data of S3 using AWS Athena. Is there any way we can connect the lambda function to athena and query the data from lambda function. please help

Thanks

Chris Pollard

Yes! You can use boto3 to interact with Athena.

Particularly, you're going to probably want the start_query_execution method.

http://boto3.readthedocs.io/en/latest/reference/services/athena.html#Athena.Client.start_query_execution

この記事はインターネットから収集されたものであり、転載の際にはソースを示してください。

侵害の場合は、連絡してください[email protected]

編集
0

コメントを追加

0
サインイン

関連記事

分類Dev

NoSuchKey in resize images using python on AWS (lambda + s3)

分類Dev

How To Re-encode AWS Lambda Event Encoding of S3 Key in Python 3?

分類Dev

How to query column name with space using AWS S3 SQL syntax?

分類Dev

AWS Lambda using s3 getObject function nothing happening

分類Dev

AWS Athena JDBC Query timeout

分類Dev

Amazon AWS Athena S3 and Glacier Mixed Bucket

分類Dev

AWS Athena + S3の制限

分類Dev

Using AWS (S3) via jclouds - how to assume role

分類Dev

How do I invoke a step function using AWS Lambda ( Python)

分類Dev

how to pass AWS lambda 1 output as lambda 2's input using BOTO 3

分類Dev

Is there a way to upload large files to Amazon lambda functions using Amazon s3

分類Dev

Synchronous call from AWS Lambda to Athena

分類Dev

How to read csv file from s3 bucket in AWS Lambda?

分類Dev

running aws athena query via pyathena

分類Dev

Possible to Specify a Parameter For AWS Athena Query?

分類Dev

Save an image from a HTTP request in S3 using python lambda

分類Dev

Athena query fails with boto3 (S3 location invalid)

分類Dev

How to run SQLAlchemy on AWS Lambda in Python

分類Dev

Access AWS S3 from Lambda within VPC

分類Dev

Access AWS S3 from Lambda within VPC

分類Dev

Access AWS S3 from Lambda within VPC

分類Dev

Can not use zip from S3 for AWS Lambda

分類Dev

Boto does not save s3 file to disc on AWS Lambda

分類Dev

Deploy lambda functions in an AWS Organization

分類Dev

How do I delete a versioned bucket in AWS S3 using the CLI?

分類Dev

How to synchronously upload files to S3 using aws-sdk?

分類Dev

how to upload larger file( greater than 12 MB) to aws s3 bucket in using salesforce apex

分類Dev

How to get Object URL(link) from AWS S3 using rails (API JSON Response)

分類Dev

How can I connect to snowflake in aws lambda function without using snowflake-connector-python?

Related 関連記事

  1. 1

    NoSuchKey in resize images using python on AWS (lambda + s3)

  2. 2

    How To Re-encode AWS Lambda Event Encoding of S3 Key in Python 3?

  3. 3

    How to query column name with space using AWS S3 SQL syntax?

  4. 4

    AWS Lambda using s3 getObject function nothing happening

  5. 5

    AWS Athena JDBC Query timeout

  6. 6

    Amazon AWS Athena S3 and Glacier Mixed Bucket

  7. 7

    AWS Athena + S3の制限

  8. 8

    Using AWS (S3) via jclouds - how to assume role

  9. 9

    How do I invoke a step function using AWS Lambda ( Python)

  10. 10

    how to pass AWS lambda 1 output as lambda 2's input using BOTO 3

  11. 11

    Is there a way to upload large files to Amazon lambda functions using Amazon s3

  12. 12

    Synchronous call from AWS Lambda to Athena

  13. 13

    How to read csv file from s3 bucket in AWS Lambda?

  14. 14

    running aws athena query via pyathena

  15. 15

    Possible to Specify a Parameter For AWS Athena Query?

  16. 16

    Save an image from a HTTP request in S3 using python lambda

  17. 17

    Athena query fails with boto3 (S3 location invalid)

  18. 18

    How to run SQLAlchemy on AWS Lambda in Python

  19. 19

    Access AWS S3 from Lambda within VPC

  20. 20

    Access AWS S3 from Lambda within VPC

  21. 21

    Access AWS S3 from Lambda within VPC

  22. 22

    Can not use zip from S3 for AWS Lambda

  23. 23

    Boto does not save s3 file to disc on AWS Lambda

  24. 24

    Deploy lambda functions in an AWS Organization

  25. 25

    How do I delete a versioned bucket in AWS S3 using the CLI?

  26. 26

    How to synchronously upload files to S3 using aws-sdk?

  27. 27

    how to upload larger file( greater than 12 MB) to aws s3 bucket in using salesforce apex

  28. 28

    How to get Object URL(link) from AWS S3 using rails (API JSON Response)

  29. 29

    How can I connect to snowflake in aws lambda function without using snowflake-connector-python?

ホットタグ

アーカイブ