Hey everyone, my datasource is with ClickHouse, an...
# ask-questions
f
Hey everyone, my datasource is with ClickHouse, and I see it is possible to set template variable in exposure query, like
experiment_id = '{{experimentId}}'
, but this doesn't seem to work when I use in facts table query, its raising error like when save saying no columns returned from query, likely due to this template variable I introduced.
f
Fact tables should be defined outside of experiment names
they are defined generically, and the experiment will add the where for that experiment id
f
you are saying when we run experiment analysis, it will auto filter the facts table to that experiment?