Learn How to Create AWS Account Alias ?
In this Video – We are going to learn What is AWS Account Alias ? Why someone need to Create AWS Account Alias ? How to create AWS Account Alias
Tag: AWS
Create single file in AWS Glue (pySpark) and store as custom file name S3
AWS Glue – AWS Glue is a serverless ETL tool developed by AWS. It is built on top of Spark. As spark is distributed processing engine by default it creates multiple output files states with e.g. Generating a Single file You might have requirement to create single output file. In order for you to create… Read More Create single file in AWS Glue (pySpark) and store as custom file name S3
AWS Learning series for Beginner
In this YouTube series I am covering 1. Cloud 101 2. Getting started with AWS 3. Introduction to AWS IAM 4. Introduction to AWS Storage Services 5. Introduction to AWS Networking Services 6. Introduction to AWS Migration Services ( Data Migration Services) 7. Introduction to AWS Compute Services – EC2 and Lambda 8. Introduction to… Read More AWS Learning series for Beginner
Serverless – The provided execution role does not have permissions to call CreateNetworkInterface on EC2
Issue – while deploying Serverless Lambda (sls deploy command ) function I got below error message An error occurred: EsLambdaFunction – The provided execution role does not have permissions to call CreateNetworkInterface on EC2 (Service: AWSLambdaInternal; Status Code: 400; Error Code: InvalidParameterValueException; Request ID: xxx). Resolution – In order to resolve the issue; I have… Read More Serverless – The provided execution role does not have permissions to call CreateNetworkInterface on EC2
AWS Lake formation – Error Message
Error Message – User: arn:aws:iam::xxxx:user/admin is not authorized to perform: lakeformation:PutDataLakeSettings with an explicit deny Issue – This issue will occur when you will try add new user as Lake formation admin with IAM user which already added as admin to Lake formation lakeformation:PutDataLakeSettings Denying this permission prevents a data lake administrator from designating other… Read More AWS Lake formation – Error Message
Aurora PostgreSQL vs MySQL Feature Comparison
Feature Comparison – Aurora PostgreSQL vs MySQL Feature Comparison As of Sep 2019. Features Features details Aurora PostgreSQL Aurora MySQL RDS PostgreSQL High Availability Read-replica Yes ( Up to 15 ) with sub-10ms replica lag Yes ( Up to 15 ) with sub-10ms replica lag Yes ( Up to 5 ) cross-region read replicas No… Read More Aurora PostgreSQL vs MySQL Feature Comparison
How to enable cron schedule in AWS EC2 instance
Step 1 – Connect to your ec2 instance ( follow below article ) https://learnsqlteam.com/2018/11/30/how-to-connect-aws-ec2-instance-through-terminal/ step 2 – go to /etc – ( cd /etc ) step 3 – edit crontab ( nano crontab ) step 4 – define schedule and command e.g. in this example I am sysning file b/w ec2 instance and s3 bucket… Read More How to enable cron schedule in AWS EC2 instance
Redshift – How to flatten JSON data in redshift
input [a,b,c,d] [b,c] [f,g,h] output a b c d b c f g h with NS AS ( select 1 as n union all select 2 union all select 3 union all select 4 union all select 5 union all select 6 union all select 7 union all select 8 union all select 9… Read More Redshift – How to flatten JSON data in redshift
Comparison between AMAZON RDS and SQL Server on EC2
Requirement – If you are planning to migrate your In House SQL Server to Amazon Cloud and wondering which option will be best for you b/w AMAZON RDS and SQL Server on EC2. Here, I have created comparison table based on AWS whitepaper and documents. Feature comparison :- Features RDS SQL on EC2 Contol AWS In house… Read More Comparison between AMAZON RDS and SQL Server on EC2
Learn Sql Team 