Amazon Athena interview questions

41. Can I use federated query capabilities for ETL? What is the workflow?
All Athena query results are stored in an Amazon S3 location that you set. You can use Athena’s federated query capabilities to execute a query that scans data sources of your choice and store the result in S3 in one SQL query. Common SQL constructs such as JOINs, Filter clauses, etc. are supported.

42. Is Athena highly available?
Yes. Amazon Athena is highly available and executes queries using compute resources across multiple facilities, automatically routing queries appropriately if a particular facility is unreachable. Athena uses Amazon S3 as its underlying data store, making your data highly available and durable. Amazon S3 provides durable infrastructure to store important data and is designed for durability of 99.999999999% of objects.

43. Will I be charged for using AWS Glue Data Catalog?
Yes, you are charged separately for using the AWS Glue Data Catalog. Click here to learn more about Glue Data Catalog pricing.

44. How to add 30 minutes in sql Amazon Athena ?
Assuming stamp is the column name in date time data type. Just update now() with stamp column:
select substring( cast(date_add(‘minute’, 30, now()) as varchar),12,5) as added_time,now()

45. How to connect Superset with AWS Athena ?
awsathena+jdbc://username:password@xxxx.redshift.amazonaws.com:port/dbname

Author: user

Leave a Reply