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.

ColumnJoin

Represents a join relationship between two columns, including the number of times the join occurs. Each ColumnJoin links two columns and provides metadata about their association.

type ColumnJoin {
  id: ID!
  count: Int!
  firstColumnId: String!
  firstColumn: Column!
  secondColumnId: String!
  secondColumn: Column!
  createdAt: Timestamp!
  updatedAt: Timestamp!
}

Fields​

ColumnJoin.id ● ID! non-null scalar general​

Unique Catalog identifier of the resource

ColumnJoin.count ● Int! non-null scalar general​

The number of join linking the columns

ColumnJoin.firstColumnId ● String! non-null scalar general​

The first column id on which the join happens

ColumnJoin.firstColumn ● Column! non-null object columns​

The first column on which the join happens

ColumnJoin.secondColumnId ● String! non-null scalar general​

The second column id on which the join happens

ColumnJoin.secondColumn ● Column! non-null object columns​

The second column on which the join happens

ColumnJoin.createdAt ● Timestamp! non-null scalar general​

Date and time the resource was created

ColumnJoin.updatedAt ● Timestamp! non-null scalar general​

Date and time the resource was last updated

Example​

{
  "id": "fffe43cb-a92f-48d9-9527-3fcc4e5f6dba",
  "count": 5,
  "firstColumnId": "fffe43cb-a92f-48d9-9527-3fcc4e5f6dba",
  "firstColumn": {
    "dataType": "STRING",
    "descriptionRaw": "Contains customer email",
    "externalDescription": "Contains customer email",
    "externalDescriptionSource": "COALESCE",
    "externalId": "customer.email",
    "isDescriptionGenerated": false,
    "isNullable": true,
    "isPii": false,
    "isPrimaryKey": true,
    "name": "email",
    "sourceOrder": 0,
    "accountId": "fffe43cb-a92f-48d9-9527-3fcc4e5f6dba",
    "databaseId": "fffe43cb-a92f-48d9-9527-3fcc4e5f6dba",
    "describedByColumnId": "fffe43cb-a92f-48d9-9527-3fcc4e5f6dba",
    "schemaId": "fffe43cb-a92f-48d9-9527-3fcc4e5f6dba",
    "sourceId": "fffe43cb-a92f-48d9-9527-3fcc4e5f6dba",
    "tableId": "fffe43cb-a92f-48d9-9527-3fcc4e5f6dba",
    "table": {
      "deprecatedAt": 1758555879800,
      "descriptionStateLexical": {
        "root": {
          "children": [
            {
              "type": "paragraph",
              "version": 1
            }
          ],
          "direction": null,
          "format": "",
          "indent": 0,
          "type": "root",
          "version": 1
        }
      },
      "lastQueriedAt": 1758555879800,
      "lastRefreshedAt": 1758555879800,
      "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",
            "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
          },
          "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"
          }
        }
      ],
      "schema": {
        "description": "Default Postgres schema",
        "isHidden": false,
        "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
    },
    "tagEntities": []
  },
  "secondColumnId": "fffe43cb-a92f-48d9-9527-3fcc4e5f6dba"
}

Member Of​