The prefix for the table is determined by the current state the table is in, so if the table is currently being built it will have a prefix of LC for Looker Create, and if it is ready to be read it will have a prefix of LR for Looker Read. The “Understanding PDT Names” section of this discourse article has some more detail on the difference between these two.
Once the table is ready to read in production and in development mode, the table name will have the
LR$ prefix followed by a longer hash, followed by the view name, like this:
sql_trigger_value is being used, during the creation step the name for PDTs built in dev mode will be slightly different. They will start with the
LC$ prefix, have a short hash, then an epoch timestamp, then the view name, like this:
You can use this difference in the hash during the creation process to check where the tables came from in the i__looker pdt_log explore at /explore/i__looker/pdt_log
Once the PDTs are ready to read there isn’t a way to tell dev and production PDTs based on their name, so I’m going to pass that feedback along to the product team. Hope this helps!