amazon-redshift-utils
amazon-redshift-utils copied to clipboard
awslabs
Amazon Redshift Utils contains utilities, scripts and view which are useful in a Redshift environment
When running replay.py, I am occasionally seeing errors like this ``` [ERROR] 2021-04-06 10:38:32 [12] (260) Exception in connect: {'S': 'ERROR', 'C': 'XX000', 'M': 'cursors can only be used within...
https://github.com/awslabs/amazon-redshift-utils/tree/master/src/SimpleReplay#step-2---simple-replay-setup With recent Amazon image ami-0ffea00000f287d30 (March 27, 2021) these are missing: ``` sudo yum install git sudo yum install python3-devel ```
I am trying to user `v_generate_user_grant_revoke_ddl` to change user ownership and drop user. But I am having issues with `default acl`. Suggested step does not handle that case `select regexp_replace(ddl,grantor,'')...
https://github.com/awslabs/amazon-redshift-utils/blob/bfe6b021e3c292723f52e4c7f81c5278e37737c4/src/AdminViews/v_get_blocking_locks.sql#L64 Is this really correct? Why use transaction time for one and waiting time for the other? annotations on this view would be great, because I don't understand it well...
When running with params set to force drop and recreate on a first-time run with a fresh target DB, this fails since it finds no table to drop. https://github.com/awslabs/amazon-redshift-utils/blob/d2aa42a6ff872164613af027543efdfe5d517dbe/src/UnloadCopyUtility/util/tasks.py#L185-L189 Combining...
I have used the script that was made available under the path **amazon-redshift-utils/src/AnalyzeVacuumUtility/lib/analyze_vacuum.py** As per my understanding we are mainly depending on interleaved_skew value from **svv_interleaved_columns** which is the ratio...
cannot blacklist / whitelist based on prefix or suffix. for blacklisting a table I would like to be able to add a table prefix% which matches any table name with...
It seems that when cluster has only 1 node, the v_space_used_per_tbl view shows all tables as being 100 pct unsorted.
We've had a number of changes that have been merged that cause issues upon execution. This can be mitigated via the addition of Unit/Integration tests and a CI/CD pipeline to...
*Description of changes:* Add scenario for migrating schema with all tables contained. Migrate single schema: ```json { "unloadSource": { "schemaName": "public" }, "copyTarget": { "schemaName": "public" } } ``` Migrate...
