hello, i’ll like to clarify the usage of dimension tables - can i use the columns in

dimTable

but not

factTable

to filter in the WHERE clause? https://docs.google.com/document/d/1InWmxbRqwcqIakzvoEWHLxtX4XR9H5L01256EbAUHV8/edit#

Table factTable:
string    uuid
int       metric
timestamp event_time
string    status

Table dimTable:
string uuid
string name 
string country

SELECT
  f.uuid,
  d.name,
  d.country,
  abs(sum(m.metric)) as sum_metric
FROM
  factTable f join dimTable d on f.uuid = d.uuid
WHERE 
  d.country in ('USA')
GROUP BY
  1,
  2,
  3
ORDER BY
  2

@Jackie ^^

@Yupeng Fu might also be able to answer this

ah right so it’ll be:

SELECT
  f.uuid,
  lookUp('dimTable', 'name', 'uuid', f.uuid) as name,
  lookUp('dimTable', 'country', 'uuid', f.uuid) as country,
  abs(sum(m.metric)) as sum_metric
FROM
  factTable f 
WHERE 
  ...
GROUP BY
  1,
  2,
  3
ORDER BY

yes