Python helper functions in recipes/_helper to standardize Athena processes

[SPTKL]

Aws

class Aws:
     def __init__(self, region_name, ....): 
      """ 
      initialize class Aws
      """ 
      self.s3_client = XXXX
      self.athena_client = XXXX
      self.s3_resource = XXXX
      self.session = XXXXX

Aws.execute_query

def execute_query(self, query:str, database:str, output_location:str='s3://recovery-data-partnership/tmp/') -> str:
"""
Given query, database, output location, execute the query, 
and print out temporary output location
"""
return queryLoc

Aws.move_file

def move_file(self, source_location:str, target_location:str):
"""
given source_location, move file from source_location to
target_location and remove the original file at source_location
"""

[SPTKL]

resources:

• https://github.com/NYCPlanning/db-safegraph/issues/12#issue-706615010 code snippet
• boto3 documentation https://boto3.amazonaws.com/v1/documentation/api/latest/reference/services/s3.html#service-resource