The many different kinds of AWS Policies
Identity Policy – Assigned to a user group or role, can be either 1.) in-line with the identity, 2.) User […]
Amazon AWS
Amazon AWS
Amazon AWS, AWS CLI
If you need AWS command line creds / credentials and you are using Okta – this maybe your easiest route gimme-aws-creds
I found using gimme-aws-creds is easier to use that okta-awscli. I believe it was written by the Nike folks, To
Amazon AWS, PostgreSQL, Uncategorized
The best YouTube video on detailed tuning of autovacuum
keep in mind, if you are running postgresql on ads, this video may not apply. Also note at around the
Amazon AWS, Data Warehouse, Redshift, Snowflake
Data Warehouse design – Type 2 Slowly Changing Dimensions
The blog outlines one method for handling Slowly Changing Dimensions – probably the most popular method referred to as type
Amazon AWS, Redshift, Uncategorized
Redshift – How to find and kill a process holding locks – and a bonus feature – allow power users to do this too – with a definers right pl/sql proc
To find blocking locks: select a.txn_owner, a.txn_db, a.xid, a.pid, a.txn_start, a.lock_mode, a.relation as table_id,nvl(trim(c.”name”),d.relname) as tablename, a.granted,b.pid as blocking_pid ,datediff(s,a.txn_start,getdate())/86400||’
Amazon AWS, Redshift
Redshift – The basics of granting a shared database or subset of a database
Basically it comes down to this syntactical example: GRANT USAGE ON DATASHARE salesshare TO NAMESPACE ’13b8833d-17c6-4f16-8fe4-1a018f5ed00d’; To determine the namespace
Amazon AWS, AWS CLI
Using AWS CLI to filter EC2 Resources by a tag with wildcard
Note I used AWS CLI V2 for this – not certain if it works with V1 but it is easy
Amazon AWS, Redshift
JDBC parameters that can be used with Redshift
I haven’t tested everyone of these but here is the link to the long list of them. If they all
Amazon AWS, Redshift
Customizing TCP/IP timeout settings for Redshift
Redshift TCP/IP keep alive settings for Linux / EC2 and Windows URL https://docs.aws.amazon.com/redshift/latest/mgmt/connecting-firewall-guidance.html
Amazon AWS, SSO
Using Google Apps as an identity provider for AWS
Using Google Apps as an identity provider for AWS to provision SSO / single-sign-on… see link at the bottom of