The publish_as_db_view parameter allows you to flag a PDT for querying outside of Looker. For PDTs with publish_as_db_view set to yes, Looker creates a stable database view on the database for the PDT. The stable database view is created on the database itself, so that it can be queried outside of Looker. The concept of a stable database view is different from a LookML view, since LookML views exist on your Looker instance and not in your database itself.
- The publish_as_db_view parameter is supported only for PDTs that use datagroup or sql_trigger_value caching. PDTs using persist_for aren’t supported.
- In addition, the account that Looker uses to connect to your database must have CREATE VIEW permissions for the temporary schema on your database. See the The database connection must have CREATE VIEW permissions section on this page for more information.
- Once Looker creates the stable database view on the database, the PDT must be built before you can query the stable database view on the database.
The publish_as_db_view documentation page details the followings: