Using Google Apps as an identity provider for AWS to provision SSO / single-sign-on… see link at the bottom of this page. Not for the “faint of heart” but I’ve seen worse. This post below looks like it is being updated to include new requirements / process on both side GoogleApps and AWS – in …
Using Google Apps as an identity provider for AWS Read More »
You may want to use something like this to guide you in implementing cross account s3 access when using Redshift copy or unload: https://aws.amazon.com/premiumsupport/knowledge-center/redshift-s3-cross-account/ It is a somewhat long and drawn out process, which is why I suggest you simply setup a bucket in the same account and region but, if it must be done, …
Here is an issue we see frequently: User A connects to Redshift with AutoCommit OFF. User A selects from table T. User B try’s to drop table T and even though User B owns table T, the drop is blocked by the User A – as User A did not connect with AutoCommit On/True and …
Redshift how to determine the pid of the currently running process / pid: select pg_backend_pid();