A Column has Values of Another Column in a Redshift View on a Particular Environment

Question

3 different tables are joined upon view creation. On dev and prod environment everything works as expected. On test environment, however, a column A of a table T gets values of a column B of a table T. Column B is not used in a view or referenced in a join. Columns are referenced by names.

Pipeline: csv in S3 -> ref.T -> schema.T (join schema.T2 join schema T3) -> View

Pipeline:
csv in S3 -> ref.T -> schema.T (join schema.T2 join schema T3) -> View

Answer

This is either user error or a bug. Assuming you have double checked everything, ask a colleague to triple check it - fresh set of eyes can see things that were originally overlooked. If thats all done then kindly raise a Support Ticket for deeper investigation.

Answer

Hi,

As mentioned by MilindOke@, This seems has to be a user error or bug. If you are still facing the issue, Please raise a support case with us - https://docs.aws.amazon.com/awssupport/latest/user/case-management.html  and share the cluster arn and view details.

Thank you.

A Column has Values of Another Column in a Redshift View on a Particular Environment

Conteúdo relevante