Workspace Lakebase

Get fork status

get
Authorizations
AuthorizationstringRequired

API key issued via POST /v1/{workspace_id}/api-keys. Pass the returned api_key value as a Bearer token.

Path parameters
workspace_idstring · uuidRequired
Responses
chevron-right
200

Successful Response

application/json
or
nullOptional
get
/v1/{workspace_id}/fork

Create a Lakebase fork (sandbox)

post
Authorizations
AuthorizationstringRequired

API key issued via POST /v1/{workspace_id}/api-keys. Pass the returned api_key value as a Bearer token.

Path parameters
workspace_idstring · uuidRequired
Body
ttl_daysinteger · min: 1 · max: 30OptionalDefault: 7
Responses
post
/v1/{workspace_id}/fork

Destroy fork

delete
Authorizations
AuthorizationstringRequired

API key issued via POST /v1/{workspace_id}/api-keys. Pass the returned api_key value as a Bearer token.

Path parameters
workspace_idstring · uuidRequired
Responses
delete
/v1/{workspace_id}/fork

No content

Execute SQL against workspace Lakebase

post
Authorizations
AuthorizationstringRequired

API key issued via POST /v1/{workspace_id}/api-keys. Pass the returned api_key value as a Bearer token.

Path parameters
workspace_idstring · uuidRequired
Body
sqlstring · min: 1 · max: 50000Required
Responses
chevron-right
200

Successful Response

application/json
columnsany ofOptional
string[]Optional
or
nullOptional
rowsany ofOptional
or
nullOptional
row_countintegerRequired
post
/v1/{workspace_id}/lakebase/query

List query tools

get
Authorizations
AuthorizationstringRequired

API key issued via POST /v1/{workspace_id}/api-keys. Pass the returned api_key value as a Bearer token.

Path parameters
workspace_idstring · uuidRequired
Query parameters
limitinteger · max: 20OptionalDefault: 10
continuation_tokenintegerOptionalDefault: 0
Responses
chevron-right
200

Successful Response

application/json
has_morebooleanRequired
continuation_tokenany ofOptional
integerOptional
or
nullOptional
totalany ofOptional
integerOptional
or
nullOptional
get
/v1/{workspace_id}/query-tools

Create a query tool

post
Authorizations
AuthorizationstringRequired

API key issued via POST /v1/{workspace_id}/api-keys. Pass the returned api_key value as a Bearer token.

Path parameters
workspace_idstring · uuidRequired
Body
namestring · min: 1 · max: 256Required
descriptionstring · max: 2000OptionalDefault: ""
querystring · min: 1 · max: 50000Required
targetconst: lakebaseOptionalDefault: lakebase
Responses
post
/v1/{workspace_id}/query-tools

Delete a query tool

delete
Authorizations
AuthorizationstringRequired

API key issued via POST /v1/{workspace_id}/api-keys. Pass the returned api_key value as a Bearer token.

Path parameters
workspace_idstring · uuidRequired
tool_idstring · uuidRequired
Responses
delete
/v1/{workspace_id}/query-tools/{tool_id}

No content

Update a query tool

patch
Authorizations
AuthorizationstringRequired

API key issued via POST /v1/{workspace_id}/api-keys. Pass the returned api_key value as a Bearer token.

Path parameters
workspace_idstring · uuidRequired
tool_idstring · uuidRequired
Body
nameany ofOptional
string · min: 1 · max: 256Optional
or
nullOptional
descriptionany ofOptional
string · max: 2000Optional
or
nullOptional
parametersany ofOptional
or
nullOptional
queryany ofOptional
string · min: 1 · max: 50000Optional
or
nullOptional
enabledany ofOptional
booleanOptional
or
nullOptional
Responses
chevron-right
200

Successful Response

application/json
idstringRequired
workspace_idstringRequired
namestringRequired
descriptionstringRequired
querystringRequired
targetconst: lakebaseRequired
enabledbooleanRequired
created_atany ofOptional
stringOptional
or
nullOptional
updated_atany ofOptional
stringOptional
or
nullOptional
patch
/v1/{workspace_id}/query-tools/{tool_id}

Test a query tool with sample parameters

post
Authorizations
AuthorizationstringRequired

API key issued via POST /v1/{workspace_id}/api-keys. Pass the returned api_key value as a Bearer token.

Path parameters
workspace_idstring · uuidRequired
tool_idstring · uuidRequired
Body
Responses
chevron-right
200

Successful Response

application/json
columnsany ofOptional
string[]Optional
or
nullOptional
rowsany ofOptional
or
nullOptional
row_countintegerRequired
post
/v1/{workspace_id}/query-tools/{tool_id}/test

Last updated

Was this helpful?