Auto Upload an S3 File to Redshift
Lambda code will look like this: import json import psycopg2 import os def lambda_handler(event, context): print(“event collected is {}”.format(event)) for […]
Amazon AWS, Lambda, Python & Boto3, Redshift
Amazon AWS
Amazon AWS, Amazon Linux 2, LAMP, WordPress
Installing WordPress on AWS EC2 Ubuntu
Here are the basics of what we are about to do:Pre-requisites With a new ec2 ubuntu instance (I used a
Amazon AWS, PostgreSQL
Create a unique hexidecimal based hash id using a postgresql function
select gen_random_uuid ()::text; select translate(gen_random_uuid ()::text,’-‘,”); select translate(‘abc-def’, ‘-‘, ”); select length(gen_random_uuid ()::text); select length(translate(gen_random_uuid ()::text,’-‘,”));
Amazon AWS, Aurora, PostgreSQL
PostgreSQL Watch out timestamp or now() function returns timestamp with timezone offset not compatible with pl/pgsql timestamp data type
Run the two commands below and you will see what I mean: select now() AT TIME ZONE current_setting(‘timezone’); 2023-09-30 09:07:31.251
Amazon AWS, Redshift
Redshift System Tables and View Types
There are several types of system tables and views here are there prefixes which categorize purpose: SVV_ prefixedviews contain information
Amazon AWS
Securing AWS API Gateway
A good place to get started on this important subject: https://docs.aws.amazon.com/apigateway/latest/developerguide/apigateway-control-access-to-api.html https://docs.aws.amazon.com/apigateway/latest/developerguide/security.html
Amazon AWS, IAM
AWS lAM Roles the Basics
AWS IAM roles define two types of policies Permissions Policy – Defines what permissions the role is granted Trust Policies
Amazon AWS, Redshift
Default maximum number of manual snapshots retained at any one time is 20
Reach out to AWS Support to increase this #. They will gladly. If you try to create a 21st your
Amazon AWS
Domains / Subject Matter Breakdown on the AWS Database Specialty Certification (DBS-C01)
Domain 1: Workload-Specific Database Design 26%Domain 2: Deployment and Migration 20%Domain 3: Management and Operations 18%Domain 4: Monitoring and Troubleshooting
Amazon AWS, DynamoDB
DynamoDB is all about knowing your data access patterns
This because using the primary key will usually result in a much lower cost query and how do you do