Referencing a persistent derived table in the sql_trigger for a datagroup

We have a use case where we’re building a few PDT’s once data is populated in a source table, and would like to kick off a scheduled plan when data is populated all of the PDT’s built from the source table by using a data group SQL trigger.

I was just reading over https://docs.looker.com/data-modeling/learning-lookml/derived-tables and there’s an example that shows the ${view.SQL_TABLE_NAME} syntax being used in trigger logic.

view: clean_events {
  derived_table: {
    sql:
      SELECT *
      FROM events
      WHERE type NOT IN ('test', 'staff') ;;
    sql_trigger_value: SELECT CURDATE() ;;
  }
}

view: events_summary {
  derived_table: {
    sql:
      SELECT
        type,
        date,
        COUNT(*) AS num_events
      FROM
        ${clean_events.SQL_TABLE_NAME} AS clean_events
      GROUP BY
        type,
        date ;;
    sql_trigger_value: SELECT MAX(id) FROM ${clean_events.SQL_TABLE_NAME} ;;
  }
}

However, when I try to reference the name of a PDT in the sql_trigger syntax of a data group, it throws an error:

Trigger error: Failed to retrieve data - Syntax error: Illegal input character “$” at [6:10]

Has anyone successfully referenced a PDT in the sql_trigger syntax for a data group?

This isn’t currently possible, which might be why nobody’s shared their solutions for it yet! Moving over to feature requests. Depending on the PDT, you could probably write a sql_trigger_value that references the underlying table with some WHERE conditions that mirror the joins and stuff in the PDT.

Still would be much cleaner/DRYer though to do it this way!