Question

[RETIRED] Creating a Connection to Amazon Athena

  • 20 January 2017
  • 3 replies
  • 350 views

  • Anonymous
  • 0 replies

Hi,


Are there any plans to support using IAM Roles to connect to Athena instead of having to pass a hardcoded access key and secret key? Our machines running Looker run on EC2 with a role that already gives them access to Athena and it would be nice and safer if Looker could just use that.


Thanks


3 replies

Userlevel 3
Badge

Hi Justin,


It looks like you already got your answer from chat, but for the benefit of everyone else, this isn’t something we support right now but we’ve passed the feedback along!

Just added the “Feature Support” section to this article.

Since Looker has native connections to AWS Athena you may be interested in how best to leverage Athena and Looker. Using a columnar storage format is ket to optimized performance and lowers per query costs. If you are looking to get started with Athena, this may be of interest. It has automated the setup and optimization of data pipelines for Looker users, including converting data to Apache Parquet format.


https://blog.openbridge.com/aws-athena-automated-60-second-setup-zero-administration-and-automatic-optimization-eba474e9897a)


If there is any interest, please let me know.

Reply