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* ImportV1Database

allow_csv_uploadboolean

allow_ctasboolean

allow_cvasboolean

allow_dmlboolean

allow_run_asyncboolean

cache_timeoutintegernullable

database_namestringrequired

encrypted_extrastringnullable

expose_in_sqllabboolean

external_urlstringnullable

extra object

allow_multi_catalogboolean

allows_virtual_table_exploreboolean

cancel_query_on_windows_unloadboolean

cost_estimate_enabledboolean

disable_data_previewboolean

disable_drill_to_detailboolean

engine_params object

property name*any

metadata_cache_timeout object

property name*integer

metadata_params object

property name*any

schema_options object

property name*any

schemas_allowed_for_csv_uploadstring[]

versionstringnullable

impersonate_userboolean

is_managed_externallybooleannullable

passwordstringnullable

sqlalchemy_uristringrequired

ssh_tunnel objectnullable

idintegernullable

SSH Tunnel ID (for updates)

passwordstring

private_keystring

private_key_passwordstring

server_addressstring

server_portinteger

usernamestring

uuidstring<uuid>required

versionstringrequired

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"
  ]
}