amazon web services - determine address of underlying s3 bucket in Athena -


i can run query in athena frontend:

select * analysisdata."iris" limit 10; 

when click on table properties location:

s3://bladata887342ac-a3ce-4600-94d0-9092f4a6bd20/iris 

is have use s3_staging_dir in python code so:

cursor = connect(aws_access_key_id='xyz',                  aws_secret_access_key='xyz',                  s3_staging_dir='s3://bladata887342ac-a3ce-4600-94d0-9092f4a6bd20/iris',                  region_name='us-east-1').cursor() 

also s3 bucket hosted in:

eu (ireland) 

what region_name?

ireland should eu-west-1.

http://docs.aws.amazon.com/general/latest/gr/rande.html#s3_region


Comments

Popular posts from this blog

resizing Telegram inline keyboard -

command line - How can a Python program background itself? -

php - "cURL error 28: Resolving timed out" on Wordpress on Azure App Service on Linux -