SQLLabBootstrapSchema

active_tab object

activeboolean

autorunboolean

database_idinteger

extra_jsonobject

hide_left_barboolean

idstring

labelstring

latest_query object

changed_onstring<date-time>

ctasboolean

dbstring

dbIdinteger

endDttmnumber

errorMessagestringnullable

executedSqlstring

extraobject

idstring

limitinteger

limitingFactorstring

progressinteger

queryIdinteger

resultsKeystring

rowsinteger

schemastring

serverIdinteger

sqlstring

sqlEditorIdstring

startDttmnumber

statestring

tabstring

tempSchemastringnullable

tempTablestringnullable

trackingUrlstringnullable

userstring

userIdinteger

query_limitinteger

saved_queryobjectnullable

schemastring

sqlstring

table_schemas object[]

Array [

database_idinteger

descriptionstring

expandedboolean

idinteger

schemastring

tab_state_idinteger

tablestring

]

user_idinteger

databases object

property name* 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

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

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

queries object

property name* QueryResult

changed_onstring<date-time>

ctasboolean

dbstring

dbIdinteger

endDttmnumber

errorMessagestringnullable

executedSqlstring

extraobject

idstring

limitinteger

limitingFactorstring

progressinteger

queryIdinteger

resultsKeystring

rowsinteger

schemastring

serverIdinteger

sqlstring

sqlEditorIdstring

startDttmnumber

statestring

tabstring

tempSchemastringnullable

tempTablestringnullable

trackingUrlstringnullable

userstring

userIdinteger

tab_state_idsstring[]

SQLLabBootstrapSchema

{
  "active_tab": {
    "active": true,
    "autorun": true,
    "database_id": 0,
    "extra_json": {},
    "hide_left_bar": true,
    "id": "string",
    "label": "string",
    "latest_query": {
      "changed_on": "2024-07-29T15:51:28.071Z",
      "ctas": true,
      "db": "string",
      "dbId": 0,
      "endDttm": 0,
      "errorMessage": "string",
      "executedSql": "string",
      "extra": {},
      "id": "string",
      "limit": 0,
      "limitingFactor": "string",
      "progress": 0,
      "queryId": 0,
      "resultsKey": "string",
      "rows": 0,
      "schema": "string",
      "serverId": 0,
      "sql": "string",
      "sqlEditorId": "string",
      "startDttm": 0,
      "state": "string",
      "tab": "string",
      "tempSchema": "string",
      "tempTable": "string",
      "trackingUrl": "string",
      "user": "string",
      "userId": 0
    },
    "query_limit": 0,
    "saved_query": {},
    "schema": "string",
    "sql": "string",
    "table_schemas": [
      {
        "database_id": 0,
        "description": "string",
        "expanded": true,
        "id": 0,
        "schema": "string",
        "tab_state_id": 0,
        "table": "string"
      }
    ],
    "user_id": 0
  },
  "databases": {},
  "queries": {},
  "tab_state_ids": [
    "string"
  ]
}