awslabs / awslabs/amazon-redshift-utils
sp_correlation is giving error with column "trip_count" does not exist in derived_table1
Open
- Dominant language
- Python
- Stars
- 2.8k
- Forks
- 1.2k
- PR merge metrics
- No merged PRs in 30d
Description
The Procedure is not generic. Not able to run with generic column and table name.
Contributor guide
Research direction
Locate the sp_correlation procedure and inspect how it references trip_count and derived_table1. Reproduce the failure with generic column and table names; done means the procedure runs without assuming those specific identifiers.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- sql
- Domain
- databases
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 15/100