Skip to content

Attempt to alter the precision of a decimal column in Redshit #4005

@izeigerman

Description

@izeigerman

Only VARCHAR type precision can be altered as per Redshift documentation: https://docs.aws.amazon.com/redshift/latest/dg/r_ALTER_TABLE.html. However SQLMesh attempts to also alter a column of DECIMAL type:

ALTER TABLE <target_table> ALTER COLUMN "quantity_amt" TYPE DECIMAL(25, 10) 

We need to make sure that SQLMesh only alters columns of VARCHAR type when used with Redshift.

Metadata

Metadata

Assignees

Labels

BugSomething isn't workingEngine: RedshiftIssues related to Redshift

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions