Last tested: Feb 20, 2020
In order to use PDTs, your database will need to be configured to allow Looker to build and maintain tables on the database.
Once you enable PDTs for your connection, you’ll notice that there is a “PDT Override” column. In the PDT Override column, you can enter separate JDBC parameters (host, port, database, username, password, schema, and additional parameters) that are specific to PDT processes.
More information as well as use cases for configuring separate login credentials for PDT processes located in our PDT Override documentation.
*We have seen a few cases in which users have used the PDT Override feature to configure a separate, read-only database for use with PDTs. This use case is not what the override feature is meant for, but may nonetheless 'just work' in some cases.
This content is subject to limited support.