Redshift data ingestion deduplication / upsert ( delete / insert ) using a staging table – and a little tuning
Why would you do this? In Redshift blocks are immutable – and are re-written completely – no partial block writes. […]
Why would you do this? In Redshift blocks are immutable – and are re-written completely – no partial block writes. […]
I had a major problem with my new HP x360 trackpad being too sensitive using trackpad taps. I almost took
References to AWS Docs. For Redshift tuning table design distribution styles and distribution keys and much more… https://aws.amazon.com/blogs/big-data/amazon-redshift-engineerings-advanced-table-design-playbook-distribution-styles-and-distribution-keys/ https://aws.amazon.com/blogs/big-data/top-10-performance-tuning-techniques-for-amazon-redshift/ https://docs.aws.amazon.com/redshift/latest/dg/c_best-practices-best-dist-key.html
diststyle and distkey combination define slice distributions diststyle defaults to “even” when not defined distkey has no default
alternatives –config java + 1 /usr/lib/jvm/jre-1.6.0-openjdk/bin/java * 2 /etc/alternatives/java_sdk/bin/java 3 /usr/lib/jvm/jre-1.5.0-gcj/bin/java 4 /usr/java/latest/bin/java 5 /usr/java/jdk1.7.0/bin/java
work in progress – writing an AWS Python based lambda function with events on S3 – trying to figure how
When creating an S3 bucket with the AWS CLI s3api like: aws s3api create-bucket –bucket xxxxxredshiftoregon –region us-west-2 –create-bucket-configuration LocationConstraint=us-west-2
Download Aginity Workbench Desktop Client Here – I believe it is a Windows only tool. http://www.aginity.com/redshift/ I had to
General description of the process Generate a fairly large volume of test data using the tpch-kit – (setup required described