full360 / glue-sneaql-demo Goto Github PK

Could you please upload virtualenv_python.zip?

I have setup AWS ECS using docker image. I have demo.sql and sneaql.json in code commit. When I run task its reading demo.sql instead of sneaql.json for steps.

2018-04-27 09:59:28[INFO] 2018-04-27 13:59:28 UTC tid2000: 0 statements found
2018-04-27 09:59:28[INFO] 2018-04-27 13:59:28 UTC tid2000: parsing statements from step file /repo/demo.sql
[INFO] 2018-04-27 13:59:28 UTC tid2000: parsing statements from step file /repo/demo.sql

Please add steps to create ECS cluster that was used in glue.

repository-url/image:tag

Hello,
I am trying to replicate your solution but I am having issues. I do not have your virtualenv_python.zip file so I can't replicate exactly but I can't connect to ECS with the included boto3. Based on the error logs, It seems like the glue ETL job is creating instances inside of my default VPC (which has an internet gateway attached and public ips auto assigned). It seems like the instances Glue creates do not have external network access. I get an exception like the following:

botocore.vendored.requests.exceptions.ConnectTimeout: HTTPSConnectionPool(host='ecs.us-east-1.amazonaws.com', port=443): Max retries exceeded with url: / (Caused by ConnectTimeoutError(<botocore.awsrequest.AWSHTTPSConnection object at 0x7fa488baa610>, 'Connection to ecs.us-east-1.amazonaws.com timed out. (connect timeout=60)'))

I have tried attaching the appropriate EC2Cotainer policies to the glue service role and I have tried just passing an ACCESS_KEY and SECRET_KEY directly to boto3, but I have had no luck.

How did you get yours to work?