Skip to content

🐛 Destination BigQuery Denormalized : lose timezone after insert datetime with TZ #13229

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
Closed
DoNotPanicUA opened this issue May 26, 2022 · 0 comments · Fixed by #13286
Closed

🐛 Destination BigQuery Denormalized : lose timezone after insert datetime with TZ #13229

DoNotPanicUA opened this issue May 26, 2022 · 0 comments · Fixed by #13286
Assignees
@DoNotPanicUA
Labels
connectors/destination/bigquery-denormalized needs-triage type/bug Something isn't working

Comments

@DoNotPanicUA
Copy link
Contributor

Current Behavior

The BigQuery stores all dates in the UTC timezone.
The normalization process ignores the timezone of incoming values and stores it in UTC as is.
Incoming data : 2022-11-22T01:23:45+05:00
Stored data in UTC : 2022-11-22T01:23:45
Expacted data in UTC : 2022-11-21T20:23:45

Expected Behavior

Data should be stored including the timezone.
@DoNotPanicUA DoNotPanicUA added type/bug Something isn't working needs-triage labels May 26, 2022
@DoNotPanicUA DoNotPanicUA self-assigned this May 26, 2022
@DoNotPanicUA DoNotPanicUA mentioned this issue May 27, 2022
Merged
@DoNotPanicUA DoNotPanicUA linked a pull request May 28, 2022 that will close this issue
🐛 Destination BigQuery Denormalized : fix datetime with timezone #13286
Merged
@andrea-zanetti andrea-zanetti mentioned this issue Oct 14, 2024
Closed
1 task
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@DoNotPanicUA DoNotPanicUA

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

Successfully merging a pull request may close this issue.

🐛 Destination BigQuery Denormalized : fix datetime with timezone airbytehq/airbyte
2 participants
@DoNotPanicUA @octavia-squidington-iii