db_connection_override for this connection in the `pdt` maintenance context
Expand DBConnectionOverride definition...
context
string
Context in which to override (`pdt` is the only allowed value)
host
string
Host name/address of server
pdt_host
string
Host name/address of server (same as host)
port
string
Port number on server
pdt_port
string
Port number on server (same as port)
username
string
Username for server authentication
pdt_username
string
Username for server authentication (same as username)
password
string
(Write-Only) Password for server authentication
pdt_password
string
(Write-Only) Password for server authentication (same as password)
has_password
lock
boolean
Whether or not the password is overridden in this context
certificate
string
(Write-Only) Base64 encoded Certificate body for server authentication (when appropriate for dialect).
pdt_certificate
string
(Write-Only) Base64 encoded Certificate body for server authentication (when appropriate for dialect) (same as certificate).
file_type
string
(Write-Only) Certificate keyfile type - .json or .p12
pdt_file_type
string
(Write-Only) Certificate keyfile type - .json or .p12 (same as file_type)
database
string
Database name
pdt_database
string
Database name (same as database)
schema
string
Schema name
pdt_schema
string
Schema name (same as schema)
jdbc_additional_params
string
Additional params to add to JDBC connection string
pdt_jdbc_additional_params
string
Additional params to add to JDBC connection string (same as jdbc_additional_params)
after_connect_statements
string
SQL statements (semicolon separated) to issue after connecting to the database. Requires `custom_after_connect_statements` license feature
pdt_after_connect_statements
string
SQL statements (semicolon separated) to issue after connecting to the database. Requires `custom_after_connect_statements` license feature (same as after_connect_statements)
managed
lock
boolean
Is this connection created and managed by Looker
custom_local_port
integer
This field is only applicable to connections over an SSH Tunnel. The value of this field would be the local port associated with the SSH tunnel if configured manually. Otherwise either enter NULL or exclude this field.
Maximum number of threads to use to build PDTs in parallel
disable_context_comment
boolean
When disable_context_comment is true comment will not be added to SQL
oauth_application_id
string
An External OAuth Application to use for authenticating to the database
always_retry_failed_builds
boolean
When true, error PDTs will be retried every regenerator cycle
uses_application_default_credentials
boolean
Whether the connection should authenticate with the Application Default Credentials of the host environment (limited to GCP and certain dialects).
impersonated_service_account
string
An alternative Service Account to use for querying datasets (used primarily with `uses_application_default_credentials`) (limited to GCP and certain dialects).
cost_estimate_enabled
boolean
When true, query cost estimate will be displayed in explore.
pdt_api_control_enabled
boolean
PDT builds on this connection can be kicked off and cancelled via API.
connection_pooling
boolean
Enable database connection pooling.
default_bq_connection
lock
boolean
When true, represents that this connection is the default BQ connection.
bq_storage_project_id
string
The project id of the default BigQuery storage project.
bq_roles_verified
boolean
When true, represents that all project roles have been verified.
p4sa_name
lock
string
The name of P4SA service account that is associated with the Looker instance
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Hard to understand","hardToUnderstand","thumb-down"],["Incorrect information or sample code","incorrectInformationOrSampleCode","thumb-down"],["Missing the information/samples I need","missingTheInformationSamplesINeed","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2025-08-20 UTC."],[],[],null,["# DBConnection\n\nVersion 4.0.25.14 (latest) \nDatatype \nDescription \n(object) \nobject \ncan \n*lock* \nobject \nOperations the current user is able to perform on this object \nname \nstring \nName of the connection. Also used as the unique identifier \ndialect \n*lock* \n[Dialect](/looker/docs/reference/looker-api/latest/types/Dialect) \n(Read-only) SQL Dialect details\nExpand Dialect definition... \nname \n*lock* \nstring \nThe name of the dialect \nlabel \n*lock* \nstring \nThe human-readable label of the connection \nsupports_cost_estimate \n*lock* \nboolean \nWhether the dialect supports query cost estimates \ncost_estimate_style \n*lock* \nstring \nHow the dialect handles cost estimation \npersistent_table_indexes \n*lock* \nstring \nPDT index columns \npersistent_table_sortkeys \n*lock* \nstring \nPDT sortkey columns \npersistent_table_distkey \n*lock* \nstring \nPDT distkey column \nsupports_streaming \n*lock* \nboolean \nSupports streaming results \nautomatically_run_sql_runner_snippets \n*lock* \nboolean \nShould SQL Runner snippets automatically be run \nconnection_tests \nstring\\[\\] \nsupports_inducer \n*lock* \nboolean \nIs supported with the inducer (i.e. generate from sql) \nsupports_multiple_databases \n*lock* \nboolean \nCan multiple databases be accessed from a connection using this dialect \nsupports_persistent_derived_tables \n*lock* \nboolean \nWhether the dialect supports allowing Looker to build persistent derived tables \nhas_ssl_support \n*lock* \nboolean \nDoes the database have client SSL support settable through the JDBC string explicitly? \nsnippets \n[Snippet](/looker/docs/reference/looker-api/latest/types/Snippet)\\[\\] \nExpand Snippet definition... \nname \n*lock* \nstring \nName of the snippet \nlabel \n*lock* \nstring \nLabel of the snippet \nsql \n*lock* \nstring \nSQL text of the snippet \npdts_enabled \n*lock* \nboolean \nTrue if PDTs are enabled on this connection \nnamed_driver_version_requested \nstring \nRequested JDBC driver version name \nnamed_driver_version_actual \n*lock* \nstring \nResolved JDBC driver version \nhost \nstring \nHost name/address of server; or the string 'localhost' in case of a connection over an SSH tunnel. \nport \nstring \nPort number on server. If the connection is over an SSH tunnel, then the local port associated with the SSH tunnel. \nusername \nstring \nUsername for server authentication \npassword \nstring \n(Write-Only) Password for server authentication \nuses_oauth \n*lock* \nboolean \nWhether the connection uses OAuth for authentication. \nuses_key_pair_auth \nboolean \nWhether the connection uses key-pair for authentication. \nuses_instance_oauth \n*lock* \nboolean \nWhether the integration uses the oauth instance account. \nuses_service_auth \n*lock* \nboolean \nWhether the connection uses service authentication certificate. \ncertificate \nstring \n(Write-Only) Base64 encoded Certificate body for server authentication (when appropriate for dialect). \nfile_type \nstring \n(Write-Only) Certificate keyfile type - .json, .p8 or .p12 \ndatabase \nstring \nDatabase name \ndb_timezone \nstring \nTime zone of database \nquery_timezone \nstring \nTimezone to use in queries \nschema \nstring \nSchema name \nmax_connections \ninteger \nMaximum number of concurrent connection to use \nmax_queries \ninteger \nMaximum number of concurrent queries to begin on this connection \nmax_queries_per_user \ninteger \nMaximum number of concurrent queries per user to begin on this connection \nmax_billing_gigabytes \nstring \nMaximum size of query in GBs (BigQuery only, can be a user_attribute name) \nssl \nboolean \nUse SSL/TLS when connecting to server \nverify_ssl \nboolean \nVerify the SSL \ntmp_db_name \nstring \nName of temporary database (if used) \ntmp_db_host \nstring \nName of temporary host (if used) \njdbc_additional_params \nstring \nAdditional params to add to JDBC connection string \npool_timeout \ninteger \nConnection Pool Timeout, in seconds \ndialect_name \nstring \n(Read/Write) SQL Dialect name \nsupports_data_studio_link \n*lock* \nboolean \nDatabase connection has the ability to support open data studio from explore \ncreated_at \n*lock* \nstring \nCreation date for this connection \nuser_id \n*lock* \nstring \nId of user who last modified this connection configuration \nexample \n*lock* \nboolean \nIs this an example connection? \nuser_db_credentials \nboolean \n(Limited access feature) Are per user db credentials enabled. Enabling will remove previously set username and password \nuser_attribute_fields \nstring\\[\\] \nmaintenance_cron \nstring \nCron string specifying when maintenance such as PDT trigger checks and drops should be performed \nlast_regen_at \n*lock* \nstring \nUnix timestamp at start of last completed PDT trigger check process \nlast_reap_at \n*lock* \nstring \nUnix timestamp at start of last completed PDT reap process \nsql_runner_precache_tables \nboolean \nPrecache tables in the SQL Runner \nsql_writing_with_info_schema \nboolean \nFetch Information Schema For SQL Writing \nafter_connect_statements \nstring \nSQL statements (semicolon separated) to issue after connecting to the database. Requires \\`custom_after_connect_statements\\` license feature \npdt_context_override \n[DBConnectionOverride](/looker/docs/reference/looker-api/latest/types/DBConnectionOverride) \ndb_connection_override for this connection in the \\`pdt\\` maintenance context\nExpand DBConnectionOverride definition... \ncontext \nstring \nContext in which to override (\\`pdt\\` is the only allowed value) \nhost \nstring \nHost name/address of server \npdt_host \nstring \nHost name/address of server (same as host) \nport \nstring \nPort number on server \npdt_port \nstring \nPort number on server (same as port) \nusername \nstring \nUsername for server authentication \npdt_username \nstring \nUsername for server authentication (same as username) \npassword \nstring \n(Write-Only) Password for server authentication \npdt_password \nstring \n(Write-Only) Password for server authentication (same as password) \nhas_password \n*lock* \nboolean \nWhether or not the password is overridden in this context \ncertificate \nstring \n(Write-Only) Base64 encoded Certificate body for server authentication (when appropriate for dialect). \npdt_certificate \nstring \n(Write-Only) Base64 encoded Certificate body for server authentication (when appropriate for dialect) (same as certificate). \nfile_type \nstring \n(Write-Only) Certificate keyfile type - .json or .p12 \npdt_file_type \nstring \n(Write-Only) Certificate keyfile type - .json or .p12 (same as file_type) \ndatabase \nstring \nDatabase name \npdt_database \nstring \nDatabase name (same as database) \nschema \nstring \nSchema name \npdt_schema \nstring \nSchema name (same as schema) \njdbc_additional_params \nstring \nAdditional params to add to JDBC connection string \npdt_jdbc_additional_params \nstring \nAdditional params to add to JDBC connection string (same as jdbc_additional_params) \nafter_connect_statements \nstring \nSQL statements (semicolon separated) to issue after connecting to the database. Requires \\`custom_after_connect_statements\\` license feature \npdt_after_connect_statements \nstring \nSQL statements (semicolon separated) to issue after connecting to the database. Requires \\`custom_after_connect_statements\\` license feature (same as after_connect_statements) \nmanaged \n*lock* \nboolean \nIs this connection created and managed by Looker \ncustom_local_port \ninteger \nThis field is only applicable to connections over an SSH Tunnel. The value of this field would be the local port associated with the SSH tunnel if configured manually. Otherwise either enter NULL or exclude this field. \ntunnel_id \nstring \nThe Id of the ssh tunnel this connection uses \nuses_tns \nboolean \nEnable Transparent Network Substrate (TNS) connections \npdt_concurrency \ninteger \nMaximum number of threads to use to build PDTs in parallel \ndisable_context_comment \nboolean \nWhen disable_context_comment is true comment will not be added to SQL \noauth_application_id \nstring \nAn External OAuth Application to use for authenticating to the database \nalways_retry_failed_builds \nboolean \nWhen true, error PDTs will be retried every regenerator cycle \nuses_application_default_credentials \nboolean \nWhether the connection should authenticate with the Application Default Credentials of the host environment (limited to GCP and certain dialects). \nimpersonated_service_account \nstring \nAn alternative Service Account to use for querying datasets (used primarily with \\`uses_application_default_credentials\\`) (limited to GCP and certain dialects). \ncost_estimate_enabled \nboolean \nWhen true, query cost estimate will be displayed in explore. \npdt_api_control_enabled \nboolean \nPDT builds on this connection can be kicked off and cancelled via API. \nconnection_pooling \nboolean \nEnable database connection pooling. \ndefault_bq_connection \n*lock* \nboolean \nWhen true, represents that this connection is the default BQ connection. \nbq_storage_project_id \nstring \nThe project id of the default BigQuery storage project. \nbq_roles_verified \nboolean \nWhen true, represents that all project roles have been verified. \np4sa_name \n*lock* \nstring \nThe name of P4SA service account that is associated with the Looker instance \nquery_holding_disabled \nboolean \nDisable query holding for this connection.\n\nRelated Methods\n---------------\n\n- [Connection/create_connection](../methods/Connection/create_connection \"Connection/create_connection\")\n- [Connection/connection](../methods/Connection/connection \"Connection/connection\")\n- [Connection/update_connection](../methods/Connection/update_connection \"Connection/update_connection\")\n- [Connection/test_connection_config](../methods/Connection/test_connection_config \"Connection/test_connection_config\")"]]
