Columns

Get column grid with metadata grouping

Returns unique columns with metadata variations grouped for grid-based editing. Uses scalable Elasticsearch/OpenSearch aggregations with cursor-based pagination. Columns with the same name but different metadata (description, tags, etc.) are grouped by metadata hash, allowing efficient bulk editing of similar columns.

get/v1/columns/grid

Request

  • Base URL: https://demo.getcollate.io/api
  • URL: https://demo.getcollate.io/api/v1/columns/grid
  • Auth: HTTP bearer

Query parameters

sizeinteger

Number of columns per batch (max 10000)

cursorstring

Cursor for pagination

columnNamePatternstring

Column name pattern (wildcard search)

entityTypesstring

Filter by entity types (comma-separated)

serviceNamestring

Filter by service name

serviceTypesstring

Filter by service types (comma-separated)

databaseNamestring

Filter by database name

schemaNamestring

Filter by schema name

domainIdstring

Filter by domain ID

hasConflictsboolean

Show only columns with conflicting metadata

hasMissingMetadataboolean

Show only columns with missing metadata

metadataStatus'MISSING' | 'INCOMPLETE' | 'COMPLETE'

Filter by metadata status: MISSING (no description AND no tags), INCOMPLETE (has description OR tags, but not both), COMPLETE (has both description AND tags)

tagsstring

Filter by classification tags at column level (comma-separated tag FQNs)

glossaryTermsstring

Filter by glossary terms at column level (comma-separated glossary term FQNs)

Response

Column grid response with grouped metadata

totalUniqueColumnsinteger required
totalOccurrencesinteger required
cursorstring

Changes

No recorded changes to this operation across all 1 revision of this API.