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.

TableQueryOutput

A SQL query being run on the warehouse either to READ or WRITE data

type TableQueryOutput {
  author: String
  databaseIds: [String!]!
  hash: ID!
  isHidden: Boolean!
  query: String!
  queriesDuration: Float
  queryType: QueryType!
  rowsProduced: Int
  schemaIds: [String!]!
  snowflakeWarehouseSize: String
  sourceUserId: String
  tables: [TableInQueryOutput!]!
  timestamp: Timestamp!
  warehouseIds: [String!]!
}

Fields​

TableQueryOutput.author ● String scalar general​

The query's author

TableQueryOutput.databaseIds ● [String!]! non-null scalar general​

The database ids

TableQueryOutput.hash ● ID! non-null scalar general​

The query identifier

TableQueryOutput.isHidden ● Boolean! non-null scalar general​

The query's visibility

TableQueryOutput.query ● String! non-null scalar general​

The query's content

TableQueryOutput.queriesDuration ● Float scalar general​

The query duration (in seconds)

TableQueryOutput.queryType ● QueryType! non-null enum sql-queries​

The query's type

TableQueryOutput.rowsProduced ● Int scalar general​

The number of rows produced by the query

TableQueryOutput.schemaIds ● [String!]! non-null scalar general​

The schema ids

TableQueryOutput.snowflakeWarehouseSize ● String scalar general​

The snowflake warehouse size used to run the query

TableQueryOutput.sourceUserId ● String scalar general​

The source user id associated to the query

TableQueryOutput.tables ● [TableInQueryOutput!]! non-null object sql-queries​

The tables used in the query

TableQueryOutput.timestamp ● Timestamp! non-null scalar general​

date of the execution of the query

TableQueryOutput.warehouseIds ● [String!]! non-null scalar general​

The warehouse ids

Example​

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

Member Of​