I’m trying to perform an INNER JOIN to a PDT as part of a join in an explore. I’ve previously used SQL_TABLE_NAME in defining PDTs that depend on other PDTs, but that syntax doesn’t appear to work when defining an explore. Perhaps I’m missing something obvious about how to do this correctly?
Incidentally, in the very same explore, I also had to join to a regular (non persistent) derived table, which works just fine.
- explore: repurchase_performance_by_customer
joins:
- join: user_purchase_facts # regular, non-persistent derived table - this works
sql: INNER JOIN looker_scratch.user_purchase_facts as user_purchase_facts ON user_purchase_facts.user_id = repurchase_performance_by_customer.user_id
- join: user_acquisition_product_facts # PDT - this one doesn't work
sql: INNER JOIN ${user_acquisition_product_facts.SQL_TABLE_NAME} ON user_acquisition_product_facts.user_id = repurchase_performance_by_customer.user_id
Error:
Unknown or inaccessible field “user_acquisition_product_facts.SQL_TABLE_NAME”
