[GH-ISSUE #76] Note: event_id template joins on 'None_swap' work table #46

Closed
opened 2026-03-23 20:28:42 +00:00 by mirror · 2 comments
Owner

Originally created by @lbertelo01 on GitHub (Jun 19, 2024).
Original GitHub issue: https://github.com/RADar-AZDelta/Rabbit-in-a-Blender/issues/76

image

Events are however correctly defined: https://github.com/RADar-AZDelta/Rabbit-in-a-Blender/blob/main/src/riab/etl/cdm_5.4_events.json

During the execution of this template, a connection error arises.

image

Originally created by @lbertelo01 on GitHub (Jun 19, 2024). Original GitHub issue: https://github.com/RADar-AZDelta/Rabbit-in-a-Blender/issues/76 ![image](https://github.com/RADar-AZDelta/Rabbit-in-a-Blender/assets/98480071/08cd6533-ea80-4d88-8fe5-7c6b417841f9) Events are however correctly defined: https://github.com/RADar-AZDelta/Rabbit-in-a-Blender/blob/main/src/riab/etl/cdm_5.4_events.json During the execution of this [template](https://github.com/RADar-AZDelta/Rabbit-in-a-Blender/blob/main/src/riab/etl/bigquery/templates/etl/%7Bomop_table%7D_apply_event_columns.sql.jinja), a connection error arises. ![image](https://github.com/RADar-AZDelta/Rabbit-in-a-Blender/assets/98480071/702302ee-dcf0-47ef-9749-458631522aa1)
mirror 2026-03-23 20:28:42 +00:00
  • closed this issue
  • added the
    invalid
    label
Author
Owner

@pjlammertyn commented on GitHub (Jun 27, 2024):

Is this not the result of a hickup in the internet connection to GCP? @lbertelo01

<!-- gh-comment-id:2195056837 --> @pjlammertyn commented on GitHub (Jun 27, 2024): Is this not the result of a hickup in the internet connection to GCP? @lbertelo01
Author
Owner

@pjlammertyn commented on GitHub (Jun 27, 2024):

This comes because of filling in the wrong field with the referring table! Column note_event_field_concept_id should contain the table name and not column note_event_id!

image

<!-- gh-comment-id:2195562679 --> @pjlammertyn commented on GitHub (Jun 27, 2024): This comes because of filling in the wrong field with the referring table! Column note_event_field_concept_id should contain the table name and not column note_event_id! ![image](https://github.com/RADar-AZDelta/Rabbit-in-a-Blender/assets/1187178/980beb32-8347-4bd4-adaa-f6f6888018e6)
Sign in to join this conversation.
No milestone
No project
No assignees
1 participant
Notifications
Due date
The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference
RADar-AZDelta/archived-Rabbit-in-a-Blender#46
No description provided.