home User Guide Getting Started Help Center Documentation Community Training Certification
menu
close
settings
Looker keyboard_arrow_down
language keyboard_arrow_down
English
Français
Deutsch
日本語
search
print
Connection : Manage Database Connections

Get All Connections

GET/api/4.0/connections
all_connections(fields)

Implementation Notes

Get information about all connections.

Response Class

  array

Parameters

Parameter Required? Description Parameter Type Data Type
fields false Requested fields. string string

Response Messages

HTTP Status Code Reason Response Model
400 Bad Request
Error {
message (string, read-only, required): Error details,
documentation_url (string, read-only, required): Documentation link
}
404 Not Found
Error {
message (string, read-only, required): Error details,
documentation_url (string, read-only, required): Documentation link
}

Create Connection

POST/api/4.0/connections
create_connection(body)

Implementation Notes

Create a connection using the specified configuration.

Response Class

DBConnection {
can (object, read-only): Operations the current user is able to perform on this object,
name (string): Name of the connection. Also used as the unique identifier,
dialect (Dialect, read-only): (Read-only) SQL Dialect details,
snippets (Array[Snippet], read-only): SQL Runner snippets for this connection,
pdts_enabled (boolean, read-only): True if PDTs are enabled on this connection,
host (string): Host name/address of server,
port (long): Port number on server,
username (string): Username for server authentication,
password (string): (Write-Only) Password for server authentication,
uses_oauth (boolean, read-only): Whether the connection uses OAuth for authentication.,
certificate (string): (Write-Only) Base64 encoded Certificate body for server authentication (when appropriate for dialect).,
file_type (string): (Write-Only) Certificate keyfile type - .json or .p12,
database (string): Database name,
db_timezone (string): Time zone of database,
query_timezone (string): Timezone to use in queries,
schema (string): Scheme name,
max_connections (long): Maximum number of concurrent connection to use,
max_billing_gigabytes (string): Maximum size of query in GBs (BigQuery only, can be a user_attribute name),
ssl (boolean): Use SSL/TLS when connecting to server,
verify_ssl (boolean): Verify the SSL,
tmp_db_name (string): Name of temporary database (if used),
jdbc_additional_params (string): Additional params to add to JDBC connection string,
pool_timeout (long): Connection Pool Timeout, in seconds,
dialect_name (string): (Read/Write) SQL Dialect name,
created_at (string, read-only): Creation date for this connection,
user_id (string, read-only): Id of user who last modified this connection configuration,
example (boolean, read-only): Is this an example connection?,
user_db_credentials (boolean): (Limited access feature) Are per user db credentials enabled. Enabling will remove previously set username and password,
user_attribute_fields (Array[string]): Fields whose values map to user attribute names,
maintenance_cron (string): Cron string specifying when maintenance such as PDT trigger checks and drops should be performed,
last_regen_at (string, read-only): Unix timestamp at start of last completed PDT trigger check process,
last_reap_at (string, read-only): Unix timestamp at start of last completed PDT reap process,
sql_runner_precache_tables (boolean): Precache tables in the SQL Runner,
after_connect_statements (string): SQL statements (semicolon separated) to issue after connecting to the database. Requires custom_after_connect_statements license feature,
pdt_context_override (DBConnectionOverride): db_connection_override for this connection in the pdt maintenance context,
managed (boolean, read-only): Is this connection created and managed by Looker,
tunnel_id (string): The Id of the ssh tunnel this connection uses,
pdt_concurrency (long): 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
}
Dialect {
name (string, read-only): The name of the dialect,
label (string, read-only): The human-readable label of the connection,
supports_cost_estimate (boolean, read-only): Whether the dialect supports query cost estimates,
persistent_table_indexes (string, read-only): PDT index columns,
persistent_table_sortkeys (string, read-only): PDT sortkey columns,
persistent_table_distkey (string, read-only): PDT distkey column,
supports_streaming (boolean, read-only): Suports streaming results,
automatically_run_sql_runner_snippets (boolean, read-only): Should SQL Runner snippets automatically be run,
connection_tests (Array[string], read-only): Array of names of the tests that can be run on a connection using this dialect,
supports_inducer (boolean, read-only): Is supported with the inducer (i.e. generate from sql),
supports_multiple_databases (boolean, read-only): Can multiple databases be accessed from a connection using this dialect,
supports_persistent_derived_tables (boolean, read-only): Whether the dialect supports allowing Looker to build persistent derived tables,
has_ssl_support (boolean, read-only): Does the database have client SSL support settable through the JDBC string explicitly?
}
Snippet {
name (string, read-only): Name of the snippet,
label (string, read-only): Label of the snippet,
sql (string, read-only): SQL text of the snippet
}
DBConnectionOverride {
context (string): Context in which to override (pdt is the only allowed value),
host (string): Host name/address of server,
port (string): Port number on server,
username (string): Username for server authentication,
password (string): (Write-Only) Password for server authentication,
has_password (boolean, read-only): 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).,
file_type (string): (Write-Only) Certificate keyfile type - .json or .p12,
database (string): Database name,
schema (string): Scheme name,
jdbc_additional_params (string): Additional params to add to JDBC connection string,
after_connect_statements (string): SQL statements (semicolon separated) to issue after connecting to the database. Requires custom_after_connect_statements license feature
}

Parameters

Parameter Required? Description Parameter Type Data Type
body true Connection body
DBConnection {
can (object, read-only): Operations the current user is able to perform on this object,
name (string): Name of the connection. Also used as the unique identifier,
dialect (Dialect, read-only): (Read-only) SQL Dialect details,
snippets (Array[Snippet], read-only): SQL Runner snippets for this connection,
pdts_enabled (boolean, read-only): True if PDTs are enabled on this connection,
host (string): Host name/address of server,
port (long): Port number on server,
username (string): Username for server authentication,
password (string): (Write-Only) Password for server authentication,
uses_oauth (boolean, read-only): Whether the connection uses OAuth for authentication.,
certificate (string): (Write-Only) Base64 encoded Certificate body for server authentication (when appropriate for dialect).,
file_type (string): (Write-Only) Certificate keyfile type - .json or .p12,
database (string): Database name,
db_timezone (string): Time zone of database,
query_timezone (string): Timezone to use in queries,
schema (string): Scheme name,
max_connections (long): Maximum number of concurrent connection to use,
max_billing_gigabytes (string): Maximum size of query in GBs (BigQuery only, can be a user_attribute name),
ssl (boolean): Use SSL/TLS when connecting to server,
verify_ssl (boolean): Verify the SSL,
tmp_db_name (string): Name of temporary database (if used),
jdbc_additional_params (string): Additional params to add to JDBC connection string,
pool_timeout (long): Connection Pool Timeout, in seconds,
dialect_name (string): (Read/Write) SQL Dialect name,
created_at (string, read-only): Creation date for this connection,
user_id (string, read-only): Id of user who last modified this connection configuration,
example (boolean, read-only): Is this an example connection?,
user_db_credentials (boolean): (Limited access feature) Are per user db credentials enabled. Enabling will remove previously set username and password,
user_attribute_fields (Array[string]): Fields whose values map to user attribute names,
maintenance_cron (string): Cron string specifying when maintenance such as PDT trigger checks and drops should be performed,
last_regen_at (string, read-only): Unix timestamp at start of last completed PDT trigger check process,
last_reap_at (string, read-only): Unix timestamp at start of last completed PDT reap process,
sql_runner_precache_tables (boolean): Precache tables in the SQL Runner,
after_connect_statements (string): SQL statements (semicolon separated) to issue after connecting to the database. Requires custom_after_connect_statements license feature,
pdt_context_override (DBConnectionOverride): db_connection_override for this connection in the pdt maintenance context,
managed (boolean, read-only): Is this connection created and managed by Looker,
tunnel_id (string): The Id of the ssh tunnel this connection uses,
pdt_concurrency (long): 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
}
Dialect {
name (string, read-only): The name of the dialect,
label (string, read-only): The human-readable label of the connection,
supports_cost_estimate (boolean, read-only): Whether the dialect supports query cost estimates,
persistent_table_indexes (string, read-only): PDT index columns,
persistent_table_sortkeys (string, read-only): PDT sortkey columns,
persistent_table_distkey (string, read-only): PDT distkey column,
supports_streaming (boolean, read-only): Suports streaming results,
automatically_run_sql_runner_snippets (boolean, read-only): Should SQL Runner snippets automatically be run,
connection_tests (Array[string], read-only): Array of names of the tests that can be run on a connection using this dialect,
supports_inducer (boolean, read-only): Is supported with the inducer (i.e. generate from sql),
supports_multiple_databases (boolean, read-only): Can multiple databases be accessed from a connection using this dialect,
supports_persistent_derived_tables (boolean, read-only): Whether the dialect supports allowing Looker to build persistent derived tables,
has_ssl_support (boolean, read-only): Does the database have client SSL support settable through the JDBC string explicitly?
}
Snippet {
name (string, read-only): Name of the snippet,
label (string, read-only): Label of the snippet,
sql (string, read-only): SQL text of the snippet
}
DBConnectionOverride {
context (string): Context in which to override (pdt is the only allowed value),
host (string): Host name/address of server,
port (string): Port number on server,
username (string): Username for server authentication,
password (string): (Write-Only) Password for server authentication,
has_password (boolean, read-only): 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).,
file_type (string): (Write-Only) Certificate keyfile type - .json or .p12,
database (string): Database name,
schema (string): Scheme name,
jdbc_additional_params (string): Additional params to add to JDBC connection string,
after_connect_statements (string): SQL statements (semicolon separated) to issue after connecting to the database. Requires custom_after_connect_statements license feature
}

Response Messages

HTTP Status Code Reason Response Model
400 Bad Request
Error {
message (string, read-only, required): Error details,
documentation_url (string, read-only, required): Documentation link
}
404 Not Found
Error {
message (string, read-only, required): Error details,
documentation_url (string, read-only, required): Documentation link
}
409 Resource Already Exists
Error {
message (string, read-only, required): Error details,
documentation_url (string, read-only, required): Documentation link
}
422 Validation Error
ValidationError {
message (string, read-only, required): Error details,
errors (Array[ValidationErrorDetail], read-only): Error detail array,
documentation_url (string, read-only, required): Documentation link
}
ValidationErrorDetail {
field (string, read-only): Field with error,
code (string, read-only): Error code,
message (string, read-only): Error info message,
documentation_url (string, read-only, required): Documentation link
}
429 Too Many Requests
Error {
message (string, read-only, required): Error details,
documentation_url (string, read-only, required): Documentation link
}

Get Connection

GET/api/4.0/connections/{connection_name}
connection(connection_name, fields)

Implementation Notes

Get information about a connection.

Response Class

DBConnection {
can (object, read-only): Operations the current user is able to perform on this object,
name (string): Name of the connection. Also used as the unique identifier,
dialect (Dialect, read-only): (Read-only) SQL Dialect details,
snippets (Array[Snippet], read-only): SQL Runner snippets for this connection,
pdts_enabled (boolean, read-only): True if PDTs are enabled on this connection,
host (string): Host name/address of server,
port (long): Port number on server,
username (string): Username for server authentication,
password (string): (Write-Only) Password for server authentication,
uses_oauth (boolean, read-only): Whether the connection uses OAuth for authentication.,
certificate (string): (Write-Only) Base64 encoded Certificate body for server authentication (when appropriate for dialect).,
file_type (string): (Write-Only) Certificate keyfile type - .json or .p12,
database (string): Database name,
db_timezone (string): Time zone of database,
query_timezone (string): Timezone to use in queries,
schema (string): Scheme name,
max_connections (long): Maximum number of concurrent connection to use,
max_billing_gigabytes (string): Maximum size of query in GBs (BigQuery only, can be a user_attribute name),
ssl (boolean): Use SSL/TLS when connecting to server,
verify_ssl (boolean): Verify the SSL,
tmp_db_name (string): Name of temporary database (if used),
jdbc_additional_params (string): Additional params to add to JDBC connection string,
pool_timeout (long): Connection Pool Timeout, in seconds,
dialect_name (string): (Read/Write) SQL Dialect name,
created_at (string, read-only): Creation date for this connection,
user_id (string, read-only): Id of user who last modified this connection configuration,
example (boolean, read-only): Is this an example connection?,
user_db_credentials (boolean): (Limited access feature) Are per user db credentials enabled. Enabling will remove previously set username and password,
user_attribute_fields (Array[string]): Fields whose values map to user attribute names,
maintenance_cron (string): Cron string specifying when maintenance such as PDT trigger checks and drops should be performed,
last_regen_at (string, read-only): Unix timestamp at start of last completed PDT trigger check process,
last_reap_at (string, read-only): Unix timestamp at start of last completed PDT reap process,
sql_runner_precache_tables (boolean): Precache tables in the SQL Runner,
after_connect_statements (string): SQL statements (semicolon separated) to issue after connecting to the database. Requires custom_after_connect_statements license feature,
pdt_context_override (DBConnectionOverride): db_connection_override for this connection in the pdt maintenance context,
managed (boolean, read-only): Is this connection created and managed by Looker,
tunnel_id (string): The Id of the ssh tunnel this connection uses,
pdt_concurrency (long): 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
}
Dialect {
name (string, read-only): The name of the dialect,
label (string, read-only): The human-readable label of the connection,
supports_cost_estimate (boolean, read-only): Whether the dialect supports query cost estimates,
persistent_table_indexes (string, read-only): PDT index columns,
persistent_table_sortkeys (string, read-only): PDT sortkey columns,
persistent_table_distkey (string, read-only): PDT distkey column,
supports_streaming (boolean, read-only): Suports streaming results,
automatically_run_sql_runner_snippets (boolean, read-only): Should SQL Runner snippets automatically be run,
connection_tests (Array[string], read-only): Array of names of the tests that can be run on a connection using this dialect,
supports_inducer (boolean, read-only): Is supported with the inducer (i.e. generate from sql),
supports_multiple_databases (boolean, read-only): Can multiple databases be accessed from a connection using this dialect,
supports_persistent_derived_tables (boolean, read-only): Whether the dialect supports allowing Looker to build persistent derived tables,
has_ssl_support (boolean, read-only): Does the database have client SSL support settable through the JDBC string explicitly?
}
Snippet {
name (string, read-only): Name of the snippet,
label (string, read-only): Label of the snippet,
sql (string, read-only): SQL text of the snippet
}
DBConnectionOverride {
context (string): Context in which to override (pdt is the only allowed value),
host (string): Host name/address of server,
port (string): Port number on server,
username (string): Username for server authentication,
password (string): (Write-Only) Password for server authentication,
has_password (boolean, read-only): 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).,
file_type (string): (Write-Only) Certificate keyfile type - .json or .p12,
database (string): Database name,
schema (string): Scheme name,
jdbc_additional_params (string): Additional params to add to JDBC connection string,
after_connect_statements (string): SQL statements (semicolon separated) to issue after connecting to the database. Requires custom_after_connect_statements license feature
}

Parameters

Parameter Required? Description Parameter Type Data Type
connection_name true Name of connection string string
fields false Requested fields. string string

Response Messages

HTTP Status Code Reason Response Model
400 Bad Request
Error {
message (string, read-only, required): Error details,
documentation_url (string, read-only, required): Documentation link
}
404 Not Found
Error {
message (string, read-only, required): Error details,
documentation_url (string, read-only, required): Documentation link
}

Update Connection

PATCH/api/4.0/connections/{connection_name}
update_connection(connection_name, body)

Implementation Notes

Update a connection using the specified configuration.

Response Class

DBConnection {
can (object, read-only): Operations the current user is able to perform on this object,
name (string): Name of the connection. Also used as the unique identifier,
dialect (Dialect, read-only): (Read-only) SQL Dialect details,
snippets (Array[Snippet], read-only): SQL Runner snippets for this connection,
pdts_enabled (boolean, read-only): True if PDTs are enabled on this connection,
host (string): Host name/address of server,
port (long): Port number on server,
username (string): Username for server authentication,
password (string): (Write-Only) Password for server authentication,
uses_oauth (boolean, read-only): Whether the connection uses OAuth for authentication.,
certificate (string): (Write-Only) Base64 encoded Certificate body for server authentication (when appropriate for dialect).,
file_type (string): (Write-Only) Certificate keyfile type - .json or .p12,
database (string): Database name,
db_timezone (string): Time zone of database,
query_timezone (string): Timezone to use in queries,
schema (string): Scheme name,
max_connections (long): Maximum number of concurrent connection to use,
max_billing_gigabytes (string): Maximum size of query in GBs (BigQuery only, can be a user_attribute name),
ssl (boolean): Use SSL/TLS when connecting to server,
verify_ssl (boolean): Verify the SSL,
tmp_db_name (string): Name of temporary database (if used),
jdbc_additional_params (string): Additional params to add to JDBC connection string,
pool_timeout (long): Connection Pool Timeout, in seconds,
dialect_name (string): (Read/Write) SQL Dialect name,
created_at (string, read-only): Creation date for this connection,
user_id (string, read-only): Id of user who last modified this connection configuration,
example (boolean, read-only): Is this an example connection?,
user_db_credentials (boolean): (Limited access feature) Are per user db credentials enabled. Enabling will remove previously set username and password,
user_attribute_fields (Array[string]): Fields whose values map to user attribute names,
maintenance_cron (string): Cron string specifying when maintenance such as PDT trigger checks and drops should be performed,
last_regen_at (string, read-only): Unix timestamp at start of last completed PDT trigger check process,
last_reap_at (string, read-only): Unix timestamp at start of last completed PDT reap process,
sql_runner_precache_tables (boolean): Precache tables in the SQL Runner,
after_connect_statements (string): SQL statements (semicolon separated) to issue after connecting to the database. Requires custom_after_connect_statements license feature,
pdt_context_override (DBConnectionOverride): db_connection_override for this connection in the pdt maintenance context,
managed (boolean, read-only): Is this connection created and managed by Looker,
tunnel_id (string): The Id of the ssh tunnel this connection uses,
pdt_concurrency (long): 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
}
Dialect {
name (string, read-only): The name of the dialect,
label (string, read-only): The human-readable label of the connection,
supports_cost_estimate (boolean, read-only): Whether the dialect supports query cost estimates,
persistent_table_indexes (string, read-only): PDT index columns,
persistent_table_sortkeys (string, read-only): PDT sortkey columns,
persistent_table_distkey (string, read-only): PDT distkey column,
supports_streaming (boolean, read-only): Suports streaming results,
automatically_run_sql_runner_snippets (boolean, read-only): Should SQL Runner snippets automatically be run,
connection_tests (Array[string], read-only): Array of names of the tests that can be run on a connection using this dialect,
supports_inducer (boolean, read-only): Is supported with the inducer (i.e. generate from sql),
supports_multiple_databases (boolean, read-only): Can multiple databases be accessed from a connection using this dialect,
supports_persistent_derived_tables (boolean, read-only): Whether the dialect supports allowing Looker to build persistent derived tables,
has_ssl_support (boolean, read-only): Does the database have client SSL support settable through the JDBC string explicitly?
}
Snippet {
name (string, read-only): Name of the snippet,
label (string, read-only): Label of the snippet,
sql (string, read-only): SQL text of the snippet
}
DBConnectionOverride {
context (string): Context in which to override (pdt is the only allowed value),
host (string): Host name/address of server,
port (string): Port number on server,
username (string): Username for server authentication,
password (string): (Write-Only) Password for server authentication,
has_password (boolean, read-only): 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).,
file_type (string): (Write-Only) Certificate keyfile type - .json or .p12,
database (string): Database name,
schema (string): Scheme name,
jdbc_additional_params (string): Additional params to add to JDBC connection string,
after_connect_statements (string): SQL statements (semicolon separated) to issue after connecting to the database. Requires custom_after_connect_statements license feature
}

Parameters

Parameter Required? Description Parameter Type Data Type
connection_name true Name of connection string string
body true Connection body
DBConnection {
can (object, read-only): Operations the current user is able to perform on this object,
name (string): Name of the connection. Also used as the unique identifier,
dialect (Dialect, read-only): (Read-only) SQL Dialect details,
snippets (Array[Snippet], read-only): SQL Runner snippets for this connection,
pdts_enabled (boolean, read-only): True if PDTs are enabled on this connection,
host (string): Host name/address of server,
port (long): Port number on server,
username (string): Username for server authentication,
password (string): (Write-Only) Password for server authentication,
uses_oauth (boolean, read-only): Whether the connection uses OAuth for authentication.,
certificate (string): (Write-Only) Base64 encoded Certificate body for server authentication (when appropriate for dialect).,
file_type (string): (Write-Only) Certificate keyfile type - .json or .p12,
database (string): Database name,
db_timezone (string): Time zone of database,
query_timezone (string): Timezone to use in queries,
schema (string): Scheme name,
max_connections (long): Maximum number of concurrent connection to use,
max_billing_gigabytes (string): Maximum size of query in GBs (BigQuery only, can be a user_attribute name),
ssl (boolean): Use SSL/TLS when connecting to server,
verify_ssl (boolean): Verify the SSL,
tmp_db_name (string): Name of temporary database (if used),
jdbc_additional_params (string): Additional params to add to JDBC connection string,
pool_timeout (long): Connection Pool Timeout, in seconds,
dialect_name (string): (Read/Write) SQL Dialect name,
created_at (string, read-only): Creation date for this connection,
user_id (string, read-only): Id of user who last modified this connection configuration,
example (boolean, read-only): Is this an example connection?,
user_db_credentials (boolean): (Limited access feature) Are per user db credentials enabled. Enabling will remove previously set username and password,
user_attribute_fields (Array[string]): Fields whose values map to user attribute names,
maintenance_cron (string): Cron string specifying when maintenance such as PDT trigger checks and drops should be performed,
last_regen_at (string, read-only): Unix timestamp at start of last completed PDT trigger check process,
last_reap_at (string, read-only): Unix timestamp at start of last completed PDT reap process,
sql_runner_precache_tables (boolean): Precache tables in the SQL Runner,
after_connect_statements (string): SQL statements (semicolon separated) to issue after connecting to the database. Requires custom_after_connect_statements license feature,
pdt_context_override (DBConnectionOverride): db_connection_override for this connection in the pdt maintenance context,
managed (boolean, read-only): Is this connection created and managed by Looker,
tunnel_id (string): The Id of the ssh tunnel this connection uses,
pdt_concurrency (long): 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
}
Dialect {
name (string, read-only): The name of the dialect,
label (string, read-only): The human-readable label of the connection,
supports_cost_estimate (boolean, read-only): Whether the dialect supports query cost estimates,
persistent_table_indexes (string, read-only): PDT index columns,
persistent_table_sortkeys (string, read-only): PDT sortkey columns,
persistent_table_distkey (string, read-only): PDT distkey column,
supports_streaming (boolean, read-only): Suports streaming results,
automatically_run_sql_runner_snippets (boolean, read-only): Should SQL Runner snippets automatically be run,
connection_tests (Array[string], read-only): Array of names of the tests that can be run on a connection using this dialect,
supports_inducer (boolean, read-only): Is supported with the inducer (i.e. generate from sql),
supports_multiple_databases (boolean, read-only): Can multiple databases be accessed from a connection using this dialect,
supports_persistent_derived_tables (boolean, read-only): Whether the dialect supports allowing Looker to build persistent derived tables,
has_ssl_support (boolean, read-only): Does the database have client SSL support settable through the JDBC string explicitly?
}
Snippet {
name (string, read-only): Name of the snippet,
label (string, read-only): Label of the snippet,
sql (string, read-only): SQL text of the snippet
}
DBConnectionOverride {
context (string): Context in which to override (pdt is the only allowed value),
host (string): Host name/address of server,
port (string): Port number on server,
username (string): Username for server authentication,
password (string): (Write-Only) Password for server authentication,
has_password (boolean, read-only): 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).,
file_type (string): (Write-Only) Certificate keyfile type - .json or .p12,
database (string): Database name,
schema (string): Scheme name,
jdbc_additional_params (string): Additional params to add to JDBC connection string,
after_connect_statements (string): SQL statements (semicolon separated) to issue after connecting to the database. Requires custom_after_connect_statements license feature
}

Response Messages

HTTP Status Code Reason Response Model
400 Bad Request
Error {
message (string, read-only, required): Error details,
documentation_url (string, read-only, required): Documentation link
}
404 Not Found
Error {
message (string, read-only, required): Error details,
documentation_url (string, read-only, required): Documentation link
}
422 Validation Error
ValidationError {
message (string, read-only, required): Error details,
errors (Array[ValidationErrorDetail], read-only): Error detail array,
documentation_url (string, read-only, required): Documentation link
}
ValidationErrorDetail {
field (string, read-only): Field with error,
code (string, read-only): Error code,
message (string, read-only): Error info message,
documentation_url (string, read-only, required): Documentation link
}
429 Too Many Requests
Error {
message (string, read-only, required): Error details,
documentation_url (string, read-only, required): Documentation link
}

Delete Connection

DELETE/api/4.0/connections/{connection_name}
delete_connection(connection_name)

Implementation Notes

Delete a connection.

Response Class

  None

Parameters

Parameter Required? Description Parameter Type Data Type
connection_name true Name of connection string string

Response Messages

HTTP Status Code Reason Response Model
400 Bad Request
Error {
message (string, read-only, required): Error details,
documentation_url (string, read-only, required): Documentation link
}
404 Not Found
Error {
message (string, read-only, required): Error details,
documentation_url (string, read-only, required): Documentation link
}
429 Too Many Requests
Error {
message (string, read-only, required): Error details,
documentation_url (string, read-only, required): Documentation link
}
204 Successfully deleted. string

Delete Connection Override

DELETE/api/4.0/connections/{connection_name}/connection_override/{override_context}
delete_connection_override(connection_name, override_context)

Implementation Notes

Delete a connection override.

Response Class

  None

Parameters

Parameter Required? Description Parameter Type Data Type
connection_name true Name of connection string string
override_context true Context of connection override string string

Response Messages

HTTP Status Code Reason Response Model
400 Bad Request
Error {
message (string, read-only, required): Error details,
documentation_url (string, read-only, required): Documentation link
}
404 Not Found
Error {
message (string, read-only, required): Error details,
documentation_url (string, read-only, required): Documentation link
}
429 Too Many Requests
Error {
message (string, read-only, required): Error details,
documentation_url (string, read-only, required): Documentation link
}
422 Validation Error
ValidationError {
message (string, read-only, required): Error details,
errors (Array[ValidationErrorDetail], read-only): Error detail array,
documentation_url (string, read-only, required): Documentation link
}
ValidationErrorDetail {
field (string, read-only): Field with error,
code (string, read-only): Error code,
message (string, read-only): Error info message,
documentation_url (string, read-only, required): Documentation link
}
204 Successfully deleted. string

Test Connection

PUT/api/4.0/connections/{connection_name}/test
test_connection(connection_name, tests)

Implementation Notes

Test an existing connection.

Note that a connection’s ‘dialect’ property has a ‘connection_tests’ property that lists the specific types of tests that the connection supports.

This API is rate limited.

Unsupported tests in the request will be ignored.

Response Class

  array

Parameters

Parameter Required? Description Parameter Type Data Type
connection_name true Name of connection string string
tests false Array of names of tests to run array array

Response Messages

HTTP Status Code Reason Response Model
429 Too Many Requests
Error {
message (string, read-only, required): Error details,
documentation_url (string, read-only, required): Documentation link
}
400 Bad Request
Error {
message (string, read-only, required): Error details,
documentation_url (string, read-only, required): Documentation link
}
404 Not Found
Error {
message (string, read-only, required): Error details,
documentation_url (string, read-only, required): Documentation link
}
422 Validation Error
ValidationError {
message (string, read-only, required): Error details,
errors (Array[ValidationErrorDetail], read-only): Error detail array,
documentation_url (string, read-only, required): Documentation link
}
ValidationErrorDetail {
field (string, read-only): Field with error,
code (string, read-only): Error code,
message (string, read-only): Error info message,
documentation_url (string, read-only, required): Documentation link
}

Test Connection Configuration

PUT/api/4.0/connections/test
test_connection_config(body, tests)

Implementation Notes

Test a connection configuration.

Note that a connection’s ‘dialect’ property has a ‘connection_tests’ property that lists the specific types of tests that the connection supports.

This API is rate limited.

Unsupported tests in the request will be ignored.

Response Class

  array

Parameters

Parameter Required? Description Parameter Type Data Type
body true Connection body
DBConnection {
can (object, read-only): Operations the current user is able to perform on this object,
name (string): Name of the connection. Also used as the unique identifier,
dialect (Dialect, read-only): (Read-only) SQL Dialect details,
snippets (Array[Snippet], read-only): SQL Runner snippets for this connection,
pdts_enabled (boolean, read-only): True if PDTs are enabled on this connection,
host (string): Host name/address of server,
port (long): Port number on server,
username (string): Username for server authentication,
password (string): (Write-Only) Password for server authentication,
uses_oauth (boolean, read-only): Whether the connection uses OAuth for authentication.,
certificate (string): (Write-Only) Base64 encoded Certificate body for server authentication (when appropriate for dialect).,
file_type (string): (Write-Only) Certificate keyfile type - .json or .p12,
database (string): Database name,
db_timezone (string): Time zone of database,
query_timezone (string): Timezone to use in queries,
schema (string): Scheme name,
max_connections (long): Maximum number of concurrent connection to use,
max_billing_gigabytes (string): Maximum size of query in GBs (BigQuery only, can be a user_attribute name),
ssl (boolean): Use SSL/TLS when connecting to server,
verify_ssl (boolean): Verify the SSL,
tmp_db_name (string): Name of temporary database (if used),
jdbc_additional_params (string): Additional params to add to JDBC connection string,
pool_timeout (long): Connection Pool Timeout, in seconds,
dialect_name (string): (Read/Write) SQL Dialect name,
created_at (string, read-only): Creation date for this connection,
user_id (string, read-only): Id of user who last modified this connection configuration,
example (boolean, read-only): Is this an example connection?,
user_db_credentials (boolean): (Limited access feature) Are per user db credentials enabled. Enabling will remove previously set username and password,
user_attribute_fields (Array[string]): Fields whose values map to user attribute names,
maintenance_cron (string): Cron string specifying when maintenance such as PDT trigger checks and drops should be performed,
last_regen_at (string, read-only): Unix timestamp at start of last completed PDT trigger check process,
last_reap_at (string, read-only): Unix timestamp at start of last completed PDT reap process,
sql_runner_precache_tables (boolean): Precache tables in the SQL Runner,
after_connect_statements (string): SQL statements (semicolon separated) to issue after connecting to the database. Requires custom_after_connect_statements license feature,
pdt_context_override (DBConnectionOverride): db_connection_override for this connection in the pdt maintenance context,
managed (boolean, read-only): Is this connection created and managed by Looker,
tunnel_id (string): The Id of the ssh tunnel this connection uses,
pdt_concurrency (long): 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
}
Dialect {
name (string, read-only): The name of the dialect,
label (string, read-only): The human-readable label of the connection,
supports_cost_estimate (boolean, read-only): Whether the dialect supports query cost estimates,
persistent_table_indexes (string, read-only): PDT index columns,
persistent_table_sortkeys (string, read-only): PDT sortkey columns,
persistent_table_distkey (string, read-only): PDT distkey column,
supports_streaming (boolean, read-only): Suports streaming results,
automatically_run_sql_runner_snippets (boolean, read-only): Should SQL Runner snippets automatically be run,
connection_tests (Array[string], read-only): Array of names of the tests that can be run on a connection using this dialect,
supports_inducer (boolean, read-only): Is supported with the inducer (i.e. generate from sql),
supports_multiple_databases (boolean, read-only): Can multiple databases be accessed from a connection using this dialect,
supports_persistent_derived_tables (boolean, read-only): Whether the dialect supports allowing Looker to build persistent derived tables,
has_ssl_support (boolean, read-only): Does the database have client SSL support settable through the JDBC string explicitly?
}
Snippet {
name (string, read-only): Name of the snippet,
label (string, read-only): Label of the snippet,
sql (string, read-only): SQL text of the snippet
}
DBConnectionOverride {
context (string): Context in which to override (pdt is the only allowed value),
host (string): Host name/address of server,
port (string): Port number on server,
username (string): Username for server authentication,
password (string): (Write-Only) Password for server authentication,
has_password (boolean, read-only): 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).,
file_type (string): (Write-Only) Certificate keyfile type - .json or .p12,
database (string): Database name,
schema (string): Scheme name,
jdbc_additional_params (string): Additional params to add to JDBC connection string,
after_connect_statements (string): SQL statements (semicolon separated) to issue after connecting to the database. Requires custom_after_connect_statements license feature
}
tests false Array of names of tests to run array array

Response Messages

HTTP Status Code Reason Response Model
400 Bad Request
Error {
message (string, read-only, required): Error details,
documentation_url (string, read-only, required): Documentation link
}
404 Not Found
Error {
message (string, read-only, required): Error details,
documentation_url (string, read-only, required): Documentation link
}
429 Too Many Requests
Error {
message (string, read-only, required): Error details,
documentation_url (string, read-only, required): Documentation link
}

Get All Dialect Infos

GET/api/4.0/dialect_info
all_dialect_infos(fields)

Implementation Notes

Get information about all dialects.

Response Class

  array

Parameters

Parameter Required? Description Parameter Type Data Type
fields false Requested fields. string string

Response Messages

HTTP Status Code Reason Response Model
400 Bad Request
Error {
message (string, read-only, required): Error details,
documentation_url (string, read-only, required): Documentation link
}
404 Not Found
Error {
message (string, read-only, required): Error details,
documentation_url (string, read-only, required): Documentation link
}

Get All SSH Servers beta

GET/api/4.0/ssh_servers
all_ssh_servers(fields)

Implementation Notes

Get information about all SSH Servers.

Response Class

  array

Parameters

Parameter Required? Description Parameter Type Data Type
fields false Requested fields. string string

Response Messages

HTTP Status Code Reason Response Model
400 Bad Request
Error {
message (string, read-only, required): Error details,
documentation_url (string, read-only, required): Documentation link
}
404 Not Found
Error {
message (string, read-only, required): Error details,
documentation_url (string, read-only, required): Documentation link
}

Create SSH Server beta

POST/api/4.0/ssh_servers
create_ssh_server(body)

Implementation Notes

Create an SSH Server.

Response Class

SshServer {
ssh_server_id (string, read-only): A unique id used to identify this SSH Server,
ssh_server_name (string): The name to identify this SSH Server,
ssh_server_host (string): The hostname or ip address of the SSH Server,
ssh_server_port (long): The port to connect to on the SSH Server,
ssh_server_user (string): The username used to connect to the SSH Server,
finger_print (string, read-only): The md5 fingerprint used to identify the SSH Server,
sha_finger_print (string, read-only): The SHA fingerprint used to identify the SSH Server,
public_key (string, read-only): The SSH public key created for this instance,
status (string, read-only): The current connection status to this SSH Server
}

Parameters

Parameter Required? Description Parameter Type Data Type
body true SSH Server body
SshServer {
ssh_server_id (string, read-only): A unique id used to identify this SSH Server,
ssh_server_name (string): The name to identify this SSH Server,
ssh_server_host (string): The hostname or ip address of the SSH Server,
ssh_server_port (long): The port to connect to on the SSH Server,
ssh_server_user (string): The username used to connect to the SSH Server,
finger_print (string, read-only): The md5 fingerprint used to identify the SSH Server,
sha_finger_print (string, read-only): The SHA fingerprint used to identify the SSH Server,
public_key (string, read-only): The SSH public key created for this instance,
status (string, read-only): The current connection status to this SSH Server
}

Response Messages

HTTP Status Code Reason Response Model
400 Bad Request
Error {
message (string, read-only, required): Error details,
documentation_url (string, read-only, required): Documentation link
}
404 Not Found
Error {
message (string, read-only, required): Error details,
documentation_url (string, read-only, required): Documentation link
}
409 Resource Already Exists
Error {
message (string, read-only, required): Error details,
documentation_url (string, read-only, required): Documentation link
}
422 Validation Error
ValidationError {
message (string, read-only, required): Error details,
errors (Array[ValidationErrorDetail], read-only): Error detail array,
documentation_url (string, read-only, required): Documentation link
}
ValidationErrorDetail {
field (string, read-only): Field with error,
code (string, read-only): Error code,
message (string, read-only): Error info message,
documentation_url (string, read-only, required): Documentation link
}
429 Too Many Requests
Error {
message (string, read-only, required): Error details,
documentation_url (string, read-only, required): Documentation link
}

Get SSH Server beta

GET/api/4.0/ssh_server/{ssh_server_id}
ssh_server(ssh_server_id)

Implementation Notes

Get information about an SSH Server.

Response Class

SshServer {
ssh_server_id (string, read-only): A unique id used to identify this SSH Server,
ssh_server_name (string): The name to identify this SSH Server,
ssh_server_host (string): The hostname or ip address of the SSH Server,
ssh_server_port (long): The port to connect to on the SSH Server,
ssh_server_user (string): The username used to connect to the SSH Server,
finger_print (string, read-only): The md5 fingerprint used to identify the SSH Server,
sha_finger_print (string, read-only): The SHA fingerprint used to identify the SSH Server,
public_key (string, read-only): The SSH public key created for this instance,
status (string, read-only): The current connection status to this SSH Server
}

Parameters

Parameter Required? Description Parameter Type Data Type
ssh_server_id true Id of SSH Server string string

Response Messages

HTTP Status Code Reason Response Model
400 Bad Request
Error {
message (string, read-only, required): Error details,
documentation_url (string, read-only, required): Documentation link
}
404 Not Found
Error {
message (string, read-only, required): Error details,
documentation_url (string, read-only, required): Documentation link
}

Update SSH Server beta

PATCH/api/4.0/ssh_server/{ssh_server_id}
update_ssh_server(ssh_server_id, body)

Implementation Notes

Update an SSH Server.

Response Class

SshServer {
ssh_server_id (string, read-only): A unique id used to identify this SSH Server,
ssh_server_name (string): The name to identify this SSH Server,
ssh_server_host (string): The hostname or ip address of the SSH Server,
ssh_server_port (long): The port to connect to on the SSH Server,
ssh_server_user (string): The username used to connect to the SSH Server,
finger_print (string, read-only): The md5 fingerprint used to identify the SSH Server,
sha_finger_print (string, read-only): The SHA fingerprint used to identify the SSH Server,
public_key (string, read-only): The SSH public key created for this instance,
status (string, read-only): The current connection status to this SSH Server
}

Parameters

Parameter Required? Description Parameter Type Data Type
ssh_server_id true Id of SSH Server string string
body true SSH Server body
SshServer {
ssh_server_id (string, read-only): A unique id used to identify this SSH Server,
ssh_server_name (string): The name to identify this SSH Server,
ssh_server_host (string): The hostname or ip address of the SSH Server,
ssh_server_port (long): The port to connect to on the SSH Server,
ssh_server_user (string): The username used to connect to the SSH Server,
finger_print (string, read-only): The md5 fingerprint used to identify the SSH Server,
sha_finger_print (string, read-only): The SHA fingerprint used to identify the SSH Server,
public_key (string, read-only): The SSH public key created for this instance,
status (string, read-only): The current connection status to this SSH Server
}

Response Messages

HTTP Status Code Reason Response Model
400 Bad Request
Error {
message (string, read-only, required): Error details,
documentation_url (string, read-only, required): Documentation link
}
404 Not Found
Error {
message (string, read-only, required): Error details,
documentation_url (string, read-only, required): Documentation link
}
422 Validation Error
ValidationError {
message (string, read-only, required): Error details,
errors (Array[ValidationErrorDetail], read-only): Error detail array,
documentation_url (string, read-only, required): Documentation link
}
ValidationErrorDetail {
field (string, read-only): Field with error,
code (string, read-only): Error code,
message (string, read-only): Error info message,
documentation_url (string, read-only, required): Documentation link
}
429 Too Many Requests
Error {
message (string, read-only, required): Error details,
documentation_url (string, read-only, required): Documentation link
}

Delete SSH Server beta

DELETE/api/4.0/ssh_server/{ssh_server_id}
delete_ssh_server(ssh_server_id)

Implementation Notes

Delete an SSH Server.

Response Class

  None

Parameters

Parameter Required? Description Parameter Type Data Type
ssh_server_id true Id of SSH Server string string

Response Messages

HTTP Status Code Reason Response Model
400 Bad Request
Error {
message (string, read-only, required): Error details,
documentation_url (string, read-only, required): Documentation link
}
404 Not Found
Error {
message (string, read-only, required): Error details,
documentation_url (string, read-only, required): Documentation link
}
429 Too Many Requests
Error {
message (string, read-only, required): Error details,
documentation_url (string, read-only, required): Documentation link
}
204 Successfully deleted. string

Test SSH Server beta

GET/api/4.0/ssh_server/{ssh_server_id}/test
test_ssh_server(ssh_server_id)

Implementation Notes

Test the SSH Server.

Response Class

SshServer {
ssh_server_id (string, read-only): A unique id used to identify this SSH Server,
ssh_server_name (string): The name to identify this SSH Server,
ssh_server_host (string): The hostname or ip address of the SSH Server,
ssh_server_port (long): The port to connect to on the SSH Server,
ssh_server_user (string): The username used to connect to the SSH Server,
finger_print (string, read-only): The md5 fingerprint used to identify the SSH Server,
sha_finger_print (string, read-only): The SHA fingerprint used to identify the SSH Server,
public_key (string, read-only): The SSH public key created for this instance,
status (string, read-only): The current connection status to this SSH Server
}

Parameters

Parameter Required? Description Parameter Type Data Type
ssh_server_id true Id of SSH Server string string

Response Messages

HTTP Status Code Reason Response Model
400 Bad Request
Error {
message (string, read-only, required): Error details,
documentation_url (string, read-only, required): Documentation link
}
404 Not Found
Error {
message (string, read-only, required): Error details,
documentation_url (string, read-only, required): Documentation link
}

Get All SSH Tunnels beta

GET/api/4.0/ssh_tunnels
all_ssh_tunnels(fields)

Implementation Notes

Get information about all SSH Tunnels.

Response Class

  array

Parameters

Parameter Required? Description Parameter Type Data Type
fields false Requested fields. string string

Response Messages

HTTP Status Code Reason Response Model
400 Bad Request
Error {
message (string, read-only, required): Error details,
documentation_url (string, read-only, required): Documentation link
}
404 Not Found
Error {
message (string, read-only, required): Error details,
documentation_url (string, read-only, required): Documentation link
}

Create SSH Tunnel beta

POST/api/4.0/ssh_tunnels
create_ssh_tunnel(body)

Implementation Notes

Create an SSH Tunnel.

Response Class

SshTunnel {
tunnel_id (string, read-only): Unique ID for the tunnel,
ssh_server_id (string): SSH Server ID,
ssh_server_name (string, read-only): SSH Server name,
ssh_server_host (string, read-only): SSH Server Hostname or IP Address,
ssh_server_port (long, read-only): SSH Server port,
ssh_server_user (string, read-only): Username used to connect to the SSH Server,
last_attempt (string, read-only): Time of last connect attempt,
local_host_port (long, read-only): Localhost Port used by the Looker instance to connect to the remote DB,
database_host (string): Hostname or IP Address of the Database Server,
database_port (long): Port that the Database Server is listening on,
status (string, read-only): Current connection status for this Tunnel
}

Parameters

Parameter Required? Description Parameter Type Data Type
body true SSH Tunnel body
SshTunnel {
tunnel_id (string, read-only): Unique ID for the tunnel,
ssh_server_id (string): SSH Server ID,
ssh_server_name (string, read-only): SSH Server name,
ssh_server_host (string, read-only): SSH Server Hostname or IP Address,
ssh_server_port (long, read-only): SSH Server port,
ssh_server_user (string, read-only): Username used to connect to the SSH Server,
last_attempt (string, read-only): Time of last connect attempt,
local_host_port (long, read-only): Localhost Port used by the Looker instance to connect to the remote DB,
database_host (string): Hostname or IP Address of the Database Server,
database_port (long): Port that the Database Server is listening on,
status (string, read-only): Current connection status for this Tunnel
}

Response Messages

HTTP Status Code Reason Response Model
400 Bad Request
Error {
message (string, read-only, required): Error details,
documentation_url (string, read-only, required): Documentation link
}
404 Not Found
Error {
message (string, read-only, required): Error details,
documentation_url (string, read-only, required): Documentation link
}
409 Resource Already Exists
Error {
message (string, read-only, required): Error details,
documentation_url (string, read-only, required): Documentation link
}
422 Validation Error
ValidationError {
message (string, read-only, required): Error details,
errors (Array[ValidationErrorDetail], read-only): Error detail array,
documentation_url (string, read-only, required): Documentation link
}
ValidationErrorDetail {
field (string, read-only): Field with error,
code (string, read-only): Error code,
message (string, read-only): Error info message,
documentation_url (string, read-only, required): Documentation link
}
429 Too Many Requests
Error {
message (string, read-only, required): Error details,
documentation_url (string, read-only, required): Documentation link
}

Get SSH Tunnel beta

GET/api/4.0/ssh_tunnel/{ssh_tunnel_id}
ssh_tunnel(ssh_tunnel_id)

Implementation Notes

Get information about an SSH Tunnel.

Response Class

SshTunnel {
tunnel_id (string, read-only): Unique ID for the tunnel,
ssh_server_id (string): SSH Server ID,
ssh_server_name (string, read-only): SSH Server name,
ssh_server_host (string, read-only): SSH Server Hostname or IP Address,
ssh_server_port (long, read-only): SSH Server port,
ssh_server_user (string, read-only): Username used to connect to the SSH Server,
last_attempt (string, read-only): Time of last connect attempt,
local_host_port (long, read-only): Localhost Port used by the Looker instance to connect to the remote DB,
database_host (string): Hostname or IP Address of the Database Server,
database_port (long): Port that the Database Server is listening on,
status (string, read-only): Current connection status for this Tunnel
}

Parameters

Parameter Required? Description Parameter Type Data Type
ssh_tunnel_id true Id of SSH Tunnel string string

Response Messages

HTTP Status Code Reason Response Model
400 Bad Request
Error {
message (string, read-only, required): Error details,
documentation_url (string, read-only, required): Documentation link
}
404 Not Found
Error {
message (string, read-only, required): Error details,
documentation_url (string, read-only, required): Documentation link
}

Update SSH Tunnel beta

PATCH/api/4.0/ssh_tunnel/{ssh_tunnel_id}
update_ssh_tunnel(ssh_tunnel_id, body)

Implementation Notes

Update an SSH Tunnel.

Response Class

SshTunnel {
tunnel_id (string, read-only): Unique ID for the tunnel,
ssh_server_id (string): SSH Server ID,
ssh_server_name (string, read-only): SSH Server name,
ssh_server_host (string, read-only): SSH Server Hostname or IP Address,
ssh_server_port (long, read-only): SSH Server port,
ssh_server_user (string, read-only): Username used to connect to the SSH Server,
last_attempt (string, read-only): Time of last connect attempt,
local_host_port (long, read-only): Localhost Port used by the Looker instance to connect to the remote DB,
database_host (string): Hostname or IP Address of the Database Server,
database_port (long): Port that the Database Server is listening on,
status (string, read-only): Current connection status for this Tunnel
}

Parameters

Parameter Required? Description Parameter Type Data Type
ssh_tunnel_id true Id of SSH Tunnel string string
body true SSH Tunnel body
SshTunnel {
tunnel_id (string, read-only): Unique ID for the tunnel,
ssh_server_id (string): SSH Server ID,
ssh_server_name (string, read-only): SSH Server name,
ssh_server_host (string, read-only): SSH Server Hostname or IP Address,
ssh_server_port (long, read-only): SSH Server port,
ssh_server_user (string, read-only): Username used to connect to the SSH Server,
last_attempt (string, read-only): Time of last connect attempt,
local_host_port (long, read-only): Localhost Port used by the Looker instance to connect to the remote DB,
database_host (string): Hostname or IP Address of the Database Server,
database_port (long): Port that the Database Server is listening on,
status (string, read-only): Current connection status for this Tunnel
}

Response Messages

HTTP Status Code Reason Response Model
400 Bad Request
Error {
message (string, read-only, required): Error details,
documentation_url (string, read-only, required): Documentation link
}
404 Not Found
Error {
message (string, read-only, required): Error details,
documentation_url (string, read-only, required): Documentation link
}
422 Validation Error
ValidationError {
message (string, read-only, required): Error details,
errors (Array[ValidationErrorDetail], read-only): Error detail array,
documentation_url (string, read-only, required): Documentation link
}
ValidationErrorDetail {
field (string, read-only): Field with error,
code (string, read-only): Error code,
message (string, read-only): Error info message,
documentation_url (string, read-only, required): Documentation link
}
429 Too Many Requests
Error {
message (string, read-only, required): Error details,
documentation_url (string, read-only, required): Documentation link
}

Delete SSH Tunnel beta

DELETE/api/4.0/ssh_tunnel/{ssh_tunnel_id}
delete_ssh_tunnel(ssh_tunnel_id)

Implementation Notes

Delete an SSH Tunnel.

Response Class

  None

Parameters

Parameter Required? Description Parameter Type Data Type
ssh_tunnel_id true Id of SSH Tunnel string string

Response Messages

HTTP Status Code Reason Response Model
400 Bad Request
Error {
message (string, read-only, required): Error details,
documentation_url (string, read-only, required): Documentation link
}
404 Not Found
Error {
message (string, read-only, required): Error details,
documentation_url (string, read-only, required): Documentation link
}
429 Too Many Requests
Error {
message (string, read-only, required): Error details,
documentation_url (string, read-only, required): Documentation link
}
204 Successfully deleted. string

Test SSH Tunnel beta

GET/api/4.0/ssh_tunnel/{ssh_tunnel_id}/test
test_ssh_tunnel(ssh_tunnel_id)

Implementation Notes

Test the SSH Tunnel.

Response Class

SshTunnel {
tunnel_id (string, read-only): Unique ID for the tunnel,
ssh_server_id (string): SSH Server ID,
ssh_server_name (string, read-only): SSH Server name,
ssh_server_host (string, read-only): SSH Server Hostname or IP Address,
ssh_server_port (long, read-only): SSH Server port,
ssh_server_user (string, read-only): Username used to connect to the SSH Server,
last_attempt (string, read-only): Time of last connect attempt,
local_host_port (long, read-only): Localhost Port used by the Looker instance to connect to the remote DB,
database_host (string): Hostname or IP Address of the Database Server,
database_port (long): Port that the Database Server is listening on,
status (string, read-only): Current connection status for this Tunnel
}

Parameters

Parameter Required? Description Parameter Type Data Type
ssh_tunnel_id true Id of SSH Tunnel string string

Response Messages

HTTP Status Code Reason Response Model
400 Bad Request
Error {
message (string, read-only, required): Error details,
documentation_url (string, read-only, required): Documentation link
}
404 Not Found
Error {
message (string, read-only, required): Error details,
documentation_url (string, read-only, required): Documentation link
}

Get SSH Public Key beta

GET/api/4.0/ssh_public_key
ssh_public_key()

Implementation Notes

Get the SSH public key.

Get the public key created for this instance to identify itself to a remote SSH server.

Response Class

SshPublicKey {
public_key (string, read-only): The SSH public key created for this instance
}

Parameters

  None

Response Messages

HTTP Status Code Reason Response Model
400 Bad Request
Error {
message (string, read-only, required): Error details,
documentation_url (string, read-only, required): Documentation link
}
404 Not Found
Error {
message (string, read-only, required): Error details,
documentation_url (string, read-only, required): Documentation link
}
Top