Table

A table represents a collection of data stored in a database. Each table contains columns, metadata, documentation, and links to its related entities.

type Table {
  id: ID!
  deprecatedAt: Timestamp
  descriptionRaw: String
  descriptionStateLexical: JSON
  externalDescription: String
  externalDescriptionSource: TableExternalDescriptionSource
  externalId: String!
  isDescriptionGenerated: Boolean
  lastQueriedAt: Timestamp
  lastRefreshedAt: Timestamp
  name: String!
  numberOfQueries: Int
  popularity: Int
  slug: String!
  tableSize: Int
  tableType: TableType!
  transformationSource: TransformationSource
  url: String
  verifiedAt: Timestamp
  deprecatedByUserId: String
  entityEditors: [EntityEditor!]!
  externalLinks: [ExternalLink!]
  lastDescribedByUserId: String
  ownerEntities: [OwnerEntity!]!
  schemaId: String!
  schema: Schema!
  tagEntities: [TagEntity!]!
  teamOwnerEntities: [TeamOwnerEntity!]!
  verifiedByUserId: String
  verifiedBy: User
  createdAt: Timestamp!
  deletedAt: Timestamp
  updatedAt: Timestamp!
  description: String!
  isDeprecated: Boolean!
  isVerified: Boolean!
}

Fields

Table.id ● ID! non-null scalar general

Unique Catalog identifier of the resource

Table.deprecatedAt ● Timestamp scalar general

The time at which the table was deprecated

Table.descriptionRaw ● String scalar general

The Catalog documentation for this table, as raw text. Can contain Markdown.

Table.descriptionStateLexical ● JSON scalar general

Rich-text description of this table as lexical JSON

Table.externalDescription ● String scalar general

The documentation from the source for this table

Table.externalDescriptionSource ● TableExternalDescriptionSource enum tables

The source of the documentation for this table

Table.externalId ● String! non-null scalar general

The technical table identifier from the warehouse table structure

Table.isDescriptionGenerated ● Boolean scalar general

True if the description has been generated, false otherwise

Table.lastQueriedAt ● Timestamp scalar general

The last datetime at which we queried for this table freshness

Table.lastRefreshedAt ● Timestamp scalar general

The last known datetime of refresh for this table

Table.name ● String! non-null scalar general

The table name

Table.numberOfQueries ● Int scalar general

The number of queries on which popularity is based

Table.popularity ● Int scalar general

·The table popularity rated out of 1000000

Table.slug ● String! non-null scalar general

The Catalog slug of the table

Table.tableSize ● Int scalar general

The size of the table (in megabytes)

Table.tableType ● TableType! non-null enum tables

The type of table asset: e.g. view, table

Table.transformationSource ● TransformationSource enum tables

The transformation source technology of this table

Table.url ● String scalar general

The external url to the table

Table.verifiedAt ● Timestamp scalar general

The time at which the table was certified

Table.deprecatedByUserId ● String scalar general

The table was deprecated by the user belonging to this ID

Table.entityEditors ● [EntityEditor!]! non-null object users

The editors associated to this table

Table.externalLinks ● [ExternalLink!] list object external-links

External Links of a table

Table.lastDescribedByUserId ● String scalar general

The table was last described be the user belonging to this ID

Table.ownerEntities ● [OwnerEntity!]! non-null object ownerships

The individual owners of the table

Table.schemaId ● String! non-null scalar general

The table belongs to this schema ID

Table.schema ● Schema! non-null object schemas

The table belongs to this schema

Table.tagEntities ● [TagEntity!]! non-null object tags

Tag associated to this table

Table.teamOwnerEntities ● [TeamOwnerEntity!]! non-null object ownerships

The team owners of the table

Table.verifiedByUserId ● String scalar general

The table is verified by the user belonging to this ID

Table.verifiedBy ● User object users

The table is verified by this user

Table.createdAt ● Timestamp! non-null scalar general

Date and time the resource was created

Table.deletedAt ● Timestamp scalar general

Date and time the resource was deleted

Table.updatedAt ● Timestamp! non-null scalar general

Date and time the resource was last updated

Table.description ● String! non-null scalar general

The table custom rawDescription or the external one if empty

Table.isDeprecated ● Boolean! non-null scalar general

Whether this table has been marked as deprecated

Table.isVerified ● Boolean! non-null scalar general

Whether this table has been marked as verified

Example

{
  "id": "fffe43cb-a92f-48d9-9527-3fcc4e5f6dba",
  "deprecatedAt": 1758555879800,
  "descriptionRaw": "Information about our **customers**",
  "descriptionStateLexical": {
    "root": {
      "children": [
        {
          "type": "paragraph",
          "version": 1
        }
      ],
      "direction": null,
      "format": "",
      "indent": 0,
      "type": "root",
      "version": 1
    }
  },
  "externalDescription": "All stored information about customers",
  "externalDescriptionSource": "COALESCE",
  "externalId": "table-customers",
  "isDescriptionGenerated": false,
  "lastQueriedAt": 1758555879800,
  "lastRefreshedAt": 1758555879800,
  "name": "customers",
  "numberOfQueries": 100,
  "popularity": 80,
  "slug": "c-customers-table",
  "tableSize": 32,
  "tableType": "TABLE",
  "transformationSource": "COALESCE",
  "url": "https://app.snowflake.com/",
  "verifiedAt": 1758555879800,
  "deprecatedByUserId": "fffe43cb-a92f-48d9-9527-3fcc4e5f6dba",
  "entityEditors": [
    {
      "dashboardId": "fffe43cb-a92f-48d9-9527-3fcc4e5f6dba",
      "sourceUserId": "fffe43cb-a92f-48d9-9527-3fcc4e5f6dba",
      "sourceUser": {
        "avatarUrl": "https://example.com/avatar.png",
        "email": "john.doe@example.com",
        "sourceId": "fffe43cb-a92f-48d9-9527-3fcc4e5f6dba",
        "unifiedId": "fffe43cb-a92f-48d9-9527-3fcc4e5f6dba",
        "unifiedUser": {
          "role": "CONTRIBUTOR",
          "status": "ACTIVATED",
          "teamIds": [
            "fffe43cb-a92f-48d9-9527-3fcc4e5f6dba"
          ],
          "userId": "fffe43cb-a92f-48d9-9527-3fcc4e5f6dba",
          "createdAt": 1758555879800
        },
        "deletedAt": 1758555879800,
        "updatedAt": 1758555879800
      },
      "tableId": "fffe43cb-a92f-48d9-9527-3fcc4e5f6dba",
      "termId": "fffe43cb-a92f-48d9-9527-3fcc4e5f6dba",
      "refreshedAt": 1758555879800
    }
  ],
  "externalLinks": [
    {
      "technology": "GITLAB"
    }
  ],
  "lastDescribedByUserId": "fffe43cb-a92f-48d9-9527-3fcc4e5f6dba",
  "ownerEntities": [
    {
      "ownerLabelId": "fffe43cb-a92f-48d9-9527-3fcc4e5f6dba",
      "ownerLabel": {
        "label": "Data Steward"
      },
      "user": {
        "firstName": "John",
        "lastName": "Doe",
        "ownerEntities": [],
        "fullName": "John Doe"
      }
    }
  ],
  "schemaId": "fffe43cb-a92f-48d9-9527-3fcc4e5f6dba",
  "schema": {
    "description": "Default Postgres schema",
    "isHidden": false,
    "databaseId": "fffe43cb-a92f-48d9-9527-3fcc4e5f6dba",
    "database": {
      "warehouse": {
        "origin": "EXTRACTION",
        "type": "COMMUNICATION"
      }
    }
  },
  "tagEntities": [
    {
      "tagId": "fffe43cb-a92f-48d9-9527-3fcc4e5f6dba",
      "tag": {
        "color": "ALERT_COLOR",
        "linkedTermId": "fffe43cb-a92f-48d9-9527-3fcc4e5f6dba"
      }
    }
  ],
  "teamOwnerEntities": [
    {
      "teamId": "fffe43cb-a92f-48d9-9527-3fcc4e5f6dba",
      "team": {
        "slackChannel": "#emea-sales",
        "slackGroup": "@emea-sales",
        "source": "Slack",
        "teamOwnerEntities": []
      }
    }
  ],
  "verifiedByUserId": "fffe43cb-a92f-48d9-9527-3fcc4e5f6dba",
  "isDeprecated": false,
  "isVerified": false
}

Returned By

• createTables mutation
• updateTableDescriptions mutation
• updateTables mutation

Member Of

• Column object
• Comment object
• DataProduct object
• EntitiesLink object
• GetTablesOutput object
• QualityCheck object