Birkini
  • Platform
  • Twitter
  • Discord
  • Blog
  • Overview
    • Introduction
    • Product Suite
  • Data Warehouse
    • Quickstart
    • System Architecture
    • Python SDK
    • Typescript SDK
    • Replication
    • Organization
    • Jupyter Notebooks
    • Model Context Protocol
    • Looker Studio
    • Dune
  • Data Marketplace
    • Introduction
    • Featured Data Shares
  • Data Scout
    • Introduction
    • FAQ
  • Default
  • Models
Powered by GitBook
On this page

Default

PreviousFAQNextModels

Shutdown Server

post
Header parameters
AuthorizationstringRequired
Responses
200
Server shutdown
application/json
post
POST /api/v1/servers/shutdown HTTP/1.1
Host: 
Authorization: text
Accept: */*
200

Server shutdown

{
  "message": "text"
}

List Databases

get
Header parameters
AuthorizationstringRequired
Responses
200
List of databases
application/json
get
GET /api/v1/databases HTTP/1.1
Host: 
Authorization: text
Accept: */*
200

List of databases

{
  "databases": [
    "text"
  ],
  "count": 1
}

Get Database Info

get
Path parameters
namestringRequired
Header parameters
AuthorizationstringRequired
Responses
200
Database information
application/json
get
GET /api/v1/databases/{name} HTTP/1.1
Host: 
Authorization: text
Accept: */*
200

Database information

{
  "id": "text",
  "name": "text",
  "createdAt": "text",
  "lastAccessed": "text",
  "lastSynced": "text",
  "sizeBytes": 1,
  "isAttached": true,
  "local": true,
  "schemas": {}
}

Delete Database

delete
Path parameters
namestringRequired
Header parameters
AuthorizationstringRequired
Responses
200
Database deleted
application/json
delete
DELETE /api/v1/databases/{name} HTTP/1.1
Host: 
Authorization: text
Accept: */*
200

Database deleted

{
  "message": "text",
  "name": "text"
}

Get Table Syncs

get
Header parameters
AuthorizationstringRequired
Responses
200
Table syncs grouped by replication
application/json
get
GET /api/replication/table_syncs_v1 HTTP/1.1
Host: 
Authorization: text
Accept: */*
200

Table syncs grouped by replication

{
  "databases": [
    {
      "id": "text",
      "name": "text",
      "source": {
        "credentials": {}
      },
      "destination": {
        "credentials": {}
      },
      "tables": [
        {
          "id": "text",
          "source_details": {},
          "destination_details": {}
        }
      ]
    }
  ]
}
  • POSTGenerate Token
  • GETServer Health Check
  • POSTShutdown Server
  • GETList Databases
  • POSTCreate Database
  • GETGet Database Info
  • DELETEDelete Database
  • POSTExecute Query
  • GETGet Table Syncs
  • POSTRun Table Sync

Server Health Check

get
Header parameters
AuthorizationstringRequired
Responses
200
Server health status
application/json
get
GET /api/v1/servers/ping HTTP/1.1
Host: 
Authorization: text
Accept: */*
200

Server health status

{
  "status": "text",
  "message": "text",
  "username": "text",
  "bucketName": "text",
  "region": "text"
}

Generate Token

post
Body
accessKeystringRequired
secretKeystringRequired
usernamestringRequired
Responses
201
Token created
application/json
post
POST /api/v1/servers HTTP/1.1
Host: 
Content-Type: application/json
Accept: */*
Content-Length: 57

{
  "accessKey": "text",
  "secretKey": "text",
  "username": "text"
}
201

Token created

{
  "token": "text",
  "username": "text",
  "message": "text",
  "bucketName": "text",
  "bucketRegion": "text",
  "tags": {},
  "groupMembership": "text"
}

Create Database

post
Header parameters
AuthorizationstringRequired
Body
namestringRequired
Responses
201
Database created
application/json
post
POST /api/v1/databases HTTP/1.1
Host: 
Authorization: text
Content-Type: application/json
Accept: */*
Content-Length: 15

{
  "name": "text"
}
201

Database created

{
  "message": "text",
  "name": "text"
}

Execute Query

post
Header parameters
AuthorizationstringRequired
Body
sqlstringRequired
parametersstring[]Optional
Responses
200
Query result
application/json
post
POST /api/v1/query HTTP/1.1
Host: 
Authorization: text
Content-Type: application/json
Accept: */*
Content-Length: 36

{
  "sql": "text",
  "parameters": [
    "text"
  ]
}
200

Query result

{
  "columns": [
    "text"
  ],
  "rows": [
    [
      "text"
    ]
  ]
}

Run Table Sync

post
Header parameters
AuthorizationstringRequired
Body
tableSyncIdstringRequired
incrementalbooleanOptional
Responses
200
Table sync triggered
application/json
Responseobject
post
POST /api/replication/table_syncs_v1 HTTP/1.1
Host: 
Authorization: text
Content-Type: application/json
Accept: */*
Content-Length: 41

{
  "tableSyncId": "text",
  "incremental": true
}
200

Table sync triggered

{}