Querying with Custom Connector

Upload Sample Data to the S3 Bucket for the Example Connector.
   aws s3 cp ~/environment/aws-athena-query-federation/athena-example/sample_data.csv s3://<<s3Bucket>>/2017/11/1/sample_data.csv
    
Now that the Example Connector code is deployed we can run queries that use the Connector:
  • Search for Athena in the Services as shown below:
  • Make sure you are in Workgroup: V2EngineWorkGroup. If not click on Workgroup and then select V2EngineWorkGroup and click Switch workgroup
  • Click on Saved Queries and Select ConnectorExample You should see like this: Click Run query. Once the query executes succesfully you should see the results like this: