hi, dong, If a query is not related to fact table, Kylin will not leverage cubes to answer the query. Instead, it will use the lookup table's snapshot.
In other words, query execution logic changes when you're querying lookup table only. can you please try using "facttable join lookup" pattern in your query? and meantime I'll check if there's any bug in the snapshot approach. thanks hongbin
