Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Destination Redshift broken integration tests in the master branch #13875

Closed
VitaliiMaltsev opened this issue Jun 17, 2022 · 1 comment · Fixed by #13894
Closed

Destination Redshift broken integration tests in the master branch #13875

VitaliiMaltsev opened this issue Jun 17, 2022 · 1 comment · Fixed by #13894
Assignees
@grubberr
Labels
needs-triage team/connectors-python type/bug Something isn't working

Comments

@VitaliiMaltsev
Copy link
Contributor

Integration tests are permanently failing on the normalization step
Error: 2-06-14 11:56:07 normalization > 11:56:05.559977 [error] [MainThread]: Database Error in model array_test_1 (models/generated/airbyte_tables/integration_test_spvsd/array_test_1.sql)
Please see https://github.com/airbytehq/airbyte/runs/6879607021?check_suite_focus=true
@bazarnov
Copy link
Collaborator

bazarnov commented Jun 17, 2022 •
edited
Loading

This PR should be related:
#13289

This is the actual model generated by this change:
https://github.com/airbytehq/airbyte/runs/6879607198?check_suite_focus=true#step:11:7308

This causes issues while JSON_EXTRACT_ARRAY is not the function for Snowflake, Redshift and probably Postgres.

@bazarnov bazarnov mentioned this issue Jun 17, 2022
Merged
38 tasks
@grubberr grubberr self-assigned this Jun 17, 2022
@grubberr grubberr linked a pull request Jun 17, 2022 that will close this issue
Normalization: Fix incorrect jinja2 macro json_extract_array call #13894
Merged
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@grubberr grubberr

Labels
needs-triage team/connectors-python type/bug Something isn't working
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

Normalization: Fix incorrect jinja2 macro json_extract_array call airbytehq/airbyte
4 participants
@grubberr @bazarnov @VitaliiMaltsev @octavia-squidington-iii