AWS Athena Integration

How to integrate AWS Athena with DataSiv

πŸ“˜

Note that AWS Athena returns only 1000 rows per page, which limits the volume of results our system can return

To integrate AWS athena with DataSiv, create a new SQL Resource and enter in a connection string with the following values: awsathena://{aws_access_key_id}:{aws_secret_access_key}@athena.{region_name}.amazonaws.com:443/{schema_name}?s3_staging_dir={s3_staging_dir}


Upon creating the connection string, you should be able to run SQL queries as expected from your applications, taking into consideration the number of rows returned limitations above