awslabs / awslabs/amazon-redshift-utils
TABLE PROPERTIES is not generated in admin.v_generate_external_tbl_ddl view
Open
- Dominant language
- Python
- Stars
- 2.8k
- Forks
- 1.2k
- PR merge metrics
- No merged PRs in 30d
Description
https://github.com/awslabs/amazon-redshift-utils/blob/0293a7310fad6ee5f99e5ae2b9002cc4c98f291d/src/AdminViews/v_generate_external_tbl_ddl.sql#L101
`regexp_replace(params, $$'EXTERNAL'='TRUE',|'transient_lastDdlTime'='[::digit::]*',$$, NULL))` always results to NULL
Contributor guide
Research direction
Start in src/AdminViews/v_generate_external_tbl_ddl.sql at line 101 and inspect how the regexp_replace call handles params. Reproduce the view output for an external table, then adjust the issue's NULL-producing expression so TABLE PROPERTIES is generated and verify the resulting DDL.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- sql
- Domain
- databases
- Issue type
- Bug
- Difficulty
- 2/5
- Estimated time
- 1-3 hours
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 45/100