RADar-AZDelta/archived-Rabbit-in-a-Blender
1
0
Fork 0
mirror of https://github.com/RADar-AZDelta/Rabbit-in-a-Blender.git synced 2026-03-23 20:37:03 +00:00
Code Issues 6 Projects Packages Wiki Activity

[GH-ISSUE #114] fact_relationship error #68

New issue
Closed
opened 2026-03-23 20:28:50 +00:00 by mirror · 2 comments
mirror commented 2026-03-23 20:28:50 +00:00
Owner
Copy link

Originally created by @loreV-edenceHealth on GitHub (Feb 28, 2025).
Original GitHub issue: https://github.com/RADar-AZDelta/Rabbit-in-a-Blender/issues/114

Originally assigned to: @pjlammertyn on GitHub.

In {{omop_tables}}_apply_events_columns.sql.jinja for the fact_relationship, the quotes in row [github.com/RADar-AZDelta/Rabbit-in-a-Blender@fa010ea3ca/src/riab/etl/sql_server/templates/etl/{omop_table}_apply_event_columns.sql.jinja (L146)] are causing an error during the riab run.

Originally created by @loreV-edenceHealth on GitHub (Feb 28, 2025). Original GitHub issue: https://github.com/RADar-AZDelta/Rabbit-in-a-Blender/issues/114 Originally assigned to: @pjlammertyn on GitHub. In {{omop_tables}}_apply_events_columns.sql.jinja for the fact_relationship, the quotes in row [https://github.com/RADar-AZDelta/Rabbit-in-a-Blender/blob/fa010ea3ca194673524447fcfea9901c5cb26c08/src/riab/etl/sql_server/templates/etl/%7Bomop_table%7D_apply_event_columns.sql.jinja#L146] are causing an error during the riab run.
mirror 2026-03-23 20:28:50 +00:00
  • closed this issue
  • added the
    bug
         label
mirror commented 2026-03-23 20:28:51 +00:00
Author
Owner
Copy link

@loreV-edenceHealth commented on GitHub (Mar 21, 2025):

At the moment I need to manually run the final query to fill the fact_relationship table because the backtick (`) character is causing issues in sql_server queries.
Can this be fixed? in sql_server [] are used for tables and fields instead of this backtick character.

<!-- gh-comment-id:2742714642 --> @loreV-edenceHealth commented on GitHub (Mar 21, 2025): At the moment I need to manually run the final query to fill the fact_relationship table because the backtick (`) character is causing issues in sql_server queries. Can this be fixed? in sql_server [] are used for tables and fields instead of this backtick character.
mirror commented 2026-03-23 20:28:51 +00:00
Author
Owner
Copy link

@pjlammertyn commented on GitHub (Apr 28, 2025):

solved in version 0.0.73

<!-- gh-comment-id:2834612744 --> @pjlammertyn commented on GitHub (Apr 28, 2025): solved in version 0.0.73
Sign in to join this conversation.
No Branch/Tag specified
Branches Tags
main
109-episode_event-table-not-filled
issue95-make-link-between-episode_parent_id-and-episode_id
dependabot/pip/requests-2.32.0
gh-pages
0.0.74
0.0.73
0.0.72
0.0.71
0.0.70
0.0.69
0.0.68
0.0.67
0.0.66
0.0.65
0.0.64
0.0.63
0.0.62
0.0.61
0.0.60
0.0.59
0.0.58
0.0.57
0.0.56
0.0.54
0.0.53
0.0.52
0.0.51
0.0.50
0.0.48
0.0.47
0.0.45
0.0.44
0.0.42
0.0.40
0.0.39
0.0.38
0.0.37
0.0.36
0.0.35
0.0.34
Labels
Clear labels   
bug

   
cannot reproduce

   
duplicate

   
enhancement

   
experiment

   
invalid

   
pull-request

Mirrored from GitHub Pull Request

  
question

   
wontfix
No labels
bug
cannot reproduce
duplicate
enhancement
experiment
invalid
pull-request
question
wontfix
Milestone
Clear milestone
No items
No milestone
Projects
Clear projects
No items
No project
Assignees
Clear assignees
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#68
No description provided.