Amazon Athena Overview Amazon Athena is an interactive query service (serverless) that allows analyzing data in Amazon S3 using SQL Athena used Data Catalogue that stores the S3 DDL Athena is based on Presto – an open-source, distributed SQL query engine optimized for low latency and ad-hoc data analysis with Read more…
Overview VPC Endpoint enables a private connection between VPC and AWS supported services (including S3, Athena, DynamoDB, ECS) and AWS Marketplace services (AWS PrivateLink-powered SaaS) Unlike VPC Endpoint – NAT Gateway uses the Internet Gateway and thus the public internet, impacting solution performance and cost VPC Endpoint VPC Endpoint enables Read more…
Overview An IAM Role is an IAM entity that defines a set of permissions for making AWS service requests. IAM roles are not associated with a specific user or group. Instead, trusted entities assume roles, such as IAM users, applications, or AWS services such as EC2. (what can I do?) An instance profile represents EC2 instances (who am I?). Instance profiles provide temporary credentials that are rotated Read more…
Python – Data Science Toolbox — Importing Data, Cleaning Data, pandas Foundations, Manipulating DataFrames and more.