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.

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 general​

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 general​

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

Table.transformationSource ● TransformationSource enum general​

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 general​

The editors associated to this table

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 general​

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 general​

The table belongs to this schema

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

Tag associated to this table

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

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 general​

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​

{
  "entityEditors": [
    {
      "sourceUser": {
        "unifiedUser": {
          "teamIds": []
        }
      }
    }
  ],
  "externalLinks": [
    {}
  ],
  "ownerEntities": [
    {
      "ownerLabel": {},
      "user": {
        "ownerEntities": []
      }
    }
  ],
  "schema": {
    "database": {
      "warehouse": {}
    }
  },
  "tagEntities": [
    {
      "tag": {}
    }
  ],
  "teamOwnerEntities": [
    {
      "team": {
        "teamOwnerEntities": []
      }
    }
  ]
}

Returned By​

Member Of​