SQLLabBootstrapDatabase

allow_ctasboolean

allow_cvasboolean

allow_dmlboolean

allow_file_uploadboolean

allow_multi_catalogboolean

allow_run_asyncboolean

allows_cost_estimatebooleannullable

allows_subqueryboolean

allows_virtual_table_exploreboolean

backendstring

The database backend

database_namestring

The database name

disable_data_previewboolean

disable_drill_to_detailboolean

engine_information object

Dialect capabilities, including identifier_quote

disable_ssh_tunnelingboolean

SSH tunnel is not available to the database

encrypted_extra_expirations object

On /connection only: JSONPath of each stored sensitive encrypted_extra field holding a JWT with an exp claim, and when it expires. The signature is not verified.

property name* EncryptedExtraExpiration

expiredboolean

Whether the stored JWT has expired

expires_atstring<date-time>

When the stored JWT expires, from its exp claim, in UTC

encrypted_extra_sensitive_fields object

JSONPath of each sensitive encrypted_extra field and its label. On the database GET and on available: the engine's declared patterns. On /connection: the fields present in the stored encrypted_extra.

property name*string

identifier_quote object

Characters used to quote identifiers for this dialect

endstring

Character that closes a quoted identifier

escape_by_doublingboolean

Whether an embedded closing-quote character is escaped by doubling it (True) or with a backslash escape (False, e.g. BigQuery's GoogleSQL backtick identifiers)

startstring

Character that opens a quoted identifier

oauth2_enabledboolean

OAuth2 authentication is enabled on this connection

supports_dynamic_catalogboolean

The database supports multiple catalogs in a single connection

supports_file_uploadboolean

Users can upload files to the database

supports_oauth2boolean

The database supports OAuth2

supports_offsetboolean

The database supports OFFSET in SQL queries. Engines like Elasticsearch SQL return False.

supports_schemasboolean

The database uses schemas to organize tables

expose_in_sqllabboolean

force_ctas_schemastringnullable

idinteger

The database id

SQLLabBootstrapDatabase

{
  "allow_ctas": true,
  "allow_cvas": true,
  "allow_dml": true,
  "allow_file_upload": true,
  "allow_multi_catalog": true,
  "allow_run_async": true,
  "allows_cost_estimate": true,
  "allows_subquery": true,
  "allows_virtual_table_explore": true,
  "backend": "string",
  "database_name": "string",
  "disable_data_preview": true,
  "disable_drill_to_detail": true,
  "engine_information": {
    "disable_ssh_tunneling": true,
    "encrypted_extra_expirations": {},
    "encrypted_extra_sensitive_fields": {},
    "identifier_quote": {
      "end": "string",
      "escape_by_doubling": true,
      "start": "string"
    },
    "oauth2_enabled": true,
    "supports_dynamic_catalog": true,
    "supports_file_upload": true,
    "supports_oauth2": true,
    "supports_offset": true,
    "supports_schemas": true
  },
  "expose_in_sqllab": true,
  "force_ctas_schema": "string",
  "id": 0
}