DBConnection.md

DBConnection

Properties

Name	Type	Description	Notes
name	string	Name of the connection. Also used as the unique identifier	[optional]
dialect	\Looker\Model\Dialect	(Read-only) SQL Dialect details	[optional]
snippets	\Looker\Model\Snippet[]	SQL Runner snippets for this connection	[optional]
host	string	Host name/address of server	[optional]
port	string	Port number on server	[optional]
username	string	Username for server authentication	[optional]
password	string	(Write-Only) Password for server authentication	[optional]
certificate	string	(Write-Only) Base64 encoded Certificate body for server authentication (when appropriate for dialect).	[optional]
file_type	string	(Write-Only) Certificate keyfile type - .json or .p12	[optional]
database	string	Database name	[optional]
db_timezone	string	Time zone of database	[optional]
query_timezone	string	Timezone to use in queries	[optional]
schema	string	Scheme name	[optional]
max_connections	int	Maximum number of concurrent connection to use	[optional]
max_billing_gigabytes	string	Maximum size of query in GBs (BigQuery only, can be a user_attribute name)	[optional]
ssl	bool	Use SSL/TLS when connecting to server	[optional]
verify_ssl	bool	Verify the SSL	[optional]
tmp_db_name	string	Name of temporary database (if used)	[optional]
jdbc_additional_params	string	Additional params to add to JDBC connection string	[optional]
pool_timeout	int	Pool Timeout	[optional]
dialect_name	string	(Read/Write) SQL Dialect name	[optional]
created_at	string	Creation date for this connection	[optional]
user_id	string	Id of user who last modified this connection configuration	[optional]
example	bool	Is this an example connection	[optional]
user_db_credentials	bool	(Limited access feature) Are per user db credentials enabled	[optional]
user_attribute_fields	string[]	Fields whose values map to user attribute names	[optional]
maintenance_cron	string	Cron string specifying when maintenance such as PDT trigger checks and drops should be performed	[optional]
last_regen_at	string	Unix timestamp at start of last completed PDT trigger check process	[optional]
last_reap_at	string	Unix timestamp at start of last completed PDT reap process	[optional]
sql_runner_precache_tables	bool	Precache tables in the SQL Runner	[optional]
after_connect_statements	string	SQL statements (semicolon separated) to issue after connecting to the database. Requires `custom_after_connect_statements` license feature	[optional]
pdt_context_override	\Looker\Model\DBConnectionOverride	db_connection_override for this connection in the `pdt` maintenance context	[optional]
can	map[string,bool]	Operations the current user is able to perform on this object	[optional]

[Back to Model list] [Back to API list] [Back to README]