Skip to main content

Documentation index: llms.txt. This page is also available as markdown: append .md to this URL or send Accept: text/markdown.

GetTableQueriesOutput

Paginated response from the executed query or mutation

type GetTableQueriesOutput {
  greatestId: String
  nbPerPage: Int!
  page: Int
  totalCount: Int!
  data: [TableQueryOutput!]!
}

Fields​

GetTableQueriesOutput.greatestId ● String scalar general​

The greatest id returned, to pass as the next 'greaterThanId' when using cursor-based pagination. Returned only when page is not used.

GetTableQueriesOutput.nbPerPage ● Int! non-null scalar general​

Number of entities to return per page

GetTableQueriesOutput.page ● Int scalar general​

The page number (start at 0). Returned only when greaterThanId is not used.

GetTableQueriesOutput.totalCount ● Int! non-null scalar general​

The total number of entities

GetTableQueriesOutput.data ● [TableQueryOutput!]! non-null object sql-queries​

Field containing the response from the executed query or mutation

Example​

{
  "greatestId": "fffe43cb-a92f-48d9-9527-3fcc4e5f6dba",
  "nbPerPage": 50,
  "page": 0,
  "totalCount": 100,
  "data": [
    {
      "author": "John Doe",
      "databaseIds": [
        "fffe43cb-a92f-48d9-9527-3fcc4e5f6dba"
      ],
      "hash": "be5c52a479672162630a89dfee974ec7",
      "isHidden": true,
      "query": "SELECT * FROM users",
      "queriesDuration": 10.5,
      "queryType": "SELECT",
      "rowsProduced": 1000,
      "schemaIds": [
        "fffe43cb-a92f-48d9-9527-3fcc4e5f6dba"
      ],
      "snowflakeWarehouseSize": "Small",
      "sourceUserId": "fffe43cb-a92f-48d9-9527-3fcc4e5f6dba",
      "tables": [
        {
          "id": "fffe43cb-a92f-48d9-9527-3fcc4e5f6dba",
          "name": "TABLE",
          "path": "\"fffe43cb-a92f-48d9-9527-3fcc4e5f6dba\".\"Snowflake\".\"DB\".\"SCHEMA\".\"TABLE\""
        }
      ],
      "timestamp": "2025-09-20T12:00:00.000Z",
      "warehouseIds": [
        "fffe43cb-a92f-48d9-9527-3fcc4e5f6dba"
      ]
    }
  ]
}

Returned By​