get-sample

Fetch sample data rows from a database table or column for a project connection

Request Body

application/json

projectId*string

Project ID

envId*string

Environment ID

connectionId*string

Connection ID

schemaName*string

Database schema name

tableName*string

Database table name

columnName?|

Column name to sample. Omit to get all columns from the table.

offset?|

Row offset for pagination. Omit to start from the first row.

Response Body

`application/json`

Input

{
  "projectId": "string",
  "envId": "string",
  "connectionId": "string",
  "schemaName": "string",
  "tableName": "string",
  "columnName": "string",
  "offset": 0
}

Output

{
  "columnNames": [
    "string"
  ],
  "rows": [
    [
      "string"
    ]
  ],
  "errorMessage": "string"
}

get-query-info

Get query info for a chart, dashboard, or report. Returns query status, SQL, malloy and data.

get-schemas

Fetch database schemas (tables, columns, relationships, indexes) for project SQL connections

Request Body

Response Body

200application/json

Input

Output

On this page

`application/json`