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
v_generate_tbl_ddl pulls comments for tables with the same name in different schemas as the join to information_schema."columns" is only joining on table name. Correct this by adding a condition to...
### Summary 1. Handled bind variables for stored procedures 2. Renamed the branch 3. Made the functions async for faster execution 4. Batch Processing for sql query
src/AdminViews/v_get_tbl_priv_by_user.sql can we had a feature request to include DROP permissions for this view ?
When using the [MultipleTableRestoreUtility](https://github.com/awslabs/amazon-redshift-utils/tree/master/src/MultipleTableRestoreUtility), it only works for the first item in the list and fails for the next item due to "InvalidClusterState" exception as Redshift is in a modifying...
v_generate_user_grant_revoke_ddl.sql does not include external tables and external schemas.
Bumps [@adobe/css-tools](https://github.com/adobe/css-tools) from 4.1.0 to 4.3.1. Changelog Sourced from @adobe/css-tools's changelog. 4.3.1 / 2023-03-14 Fix redos vulnerability with specific crafted css string - CVE-2023-26364 4.3.0 / 2023-03-07 Update build tools...
![dependabot[bot] avatar](https://avatars.githubusercontent.com/in/29110?v=4 "dependabot[bot] avatar"){kind=avatar}
fixes: https://github.com/awslabs/amazon-redshift-utils/issues/694 *Description of changes:* In [WorkloadManagementScheduler/wlm_scheduler.py](https://github.com/awslabs/amazon-redshift-utils/blob/7d2361b96b9599d9a47a593d18c4b12f832f9a38/src/WorkloadManagementScheduler/wlm_scheduler.py) Additionally add support for local json file stored in lambda's code dir. Currently only [in-place configuration](https://github.com/awslabs/amazon-redshift-utils/blob/7d2361b96b9599d9a47a593d18c4b12f832f9a38/src/WorkloadManagementScheduler/example-config.json#L13) and json files stored in s3 are...
Bumps [word-wrap](https://github.com/jonschlinkert/word-wrap) from 1.2.3 to 1.2.4. Release notes Sourced from word-wrap's releases. 1.2.4 What's Changed Remove default indent by @mohd-akram in jonschlinkert/word-wrap#24 🔒fix: CVE 2023 26115 (2) by @OlafConijn in...
User owns ASSUMEROLE permission on IAM roles can't be listed by https://github.com/awslabs/amazon-redshift-utils/blob/master/src/AdminViews/v_generate_user_grant_revoke_ddl.sql So, if admin doesn't know of assumerole permission to revoke it first, user can't be dropped and receiving...
**Feature Request** In [WorkloadManagementScheduler/wlm_scheduler.py](https://github.com/awslabs/amazon-redshift-utils/blob/7d2361b96b9599d9a47a593d18c4b12f832f9a38/src/WorkloadManagementScheduler/wlm_scheduler.py) Currently both inplace configuration and json files stored in s3 are supported. Additionally add support for local json file stored in lambda's code dir. https://github.com/awslabs/amazon-redshift-utils/blob/7d2361b96b9599d9a47a593d18c4b12f832f9a38/src/WorkloadManagementScheduler/wlm_scheduler.py#L98-L105