​

Column Bulk Operations

​

Overview

Modern data platforms collect data from many systems. APIs generate application data. Databases such as MySQL, PostgreSQL, and Oracle store operational records. Data warehouses such as Snowflake or BigQuery power analytics. Files land in storage systems like S3. Search indexes also hold structured data. Across all these systems, many columns represent the same concept. For example:

• customer_id
• customer_email
• address
• order_id

These columns can appear thousands of times across tables and services. Managing governance metadata for each instance individually becomes difficult. You must update descriptions, tags, and glossary terms one asset at a time. Column Bulk Operations solves this problem by identifying unique column names across the platform and allowing you to manage their metadata in one place. A single update propagates across every instance of that column.

​

How Column Bulk Operations Works

The feature groups columns by their name across the entire metadata platform. For example, a column named customer_id might appear in:

• MySQL tables
• PostgreSQL tables
• Snowflake warehouse tables
• Data lake tables
• Search indexes

Although these columns live in different systems, they represent the same logical field. Column Bulk Operations treats them as a unique column group and lets you manage them together.

​

Accessing Column Bulk Operations

From the left navigation bar, select Governance > Column Bulk Operations. This page provides a centralized view of all unique columns along with:

• Number of occurrences
• Metadata completeness
• Governance metadata

This view helps you quickly identify where documentation or governance updates are missing.

​

Updating Columns in Bulk

Instead of editing columns one table at a time, you can apply governance metadata across all occurrences of a column in a single update.

1. From the left navigation bar, navigate to Governance > Column Bulk Operations.
2. Use the Search columns bar to find a column by name, or use the Service, Asset Type, or Has / Missing Metadata filters to narrow the list.
3. Expand a column group to view individual occurrences across assets, then select the rows you want to update using the checkboxes.
4. Click Edit (top right) to open the edit panel.
5. Fill in the following fields:
   • Display Name: Enter a human-readable name for the column.
   • Description: Provide a consistent business definition.
   • Tags: Apply classification labels such as PII or Sensitive.
   • Glossary Terms: Link the column to business concepts.
   
6. Click Save. Collate applies the update to every selected occurrence.

​

Metadata You Can Update

Column Bulk Operations supports the following governance updates:

• Display Name: Standardize a human-readable label across all occurrences.
• Description: Provide a consistent business definition.
• Tags: Apply classification labels such as PII or Sensitive.
• Glossary Terms: Connect columns to business concepts.

These updates ensure that the same column meaning is maintained across the data ecosystem.

​

Metadata Status

Use the Has / Missing Metadata filter to narrow columns by their metadata quality. The available statuses are:

• Missing: Columns with no description, tags, or glossary terms across any occurrence.
• Incomplete: Columns where some occurrences have metadata but others do not.
• Inconsistent: Columns where metadata differs across occurrences — for example, different descriptions or tags.
• Complete: Columns where all occurrences have consistent metadata.

These statuses help you quickly identify columns that need attention.

​

Columns Filters

Use filters to narrow the scope of governance work. You can filter by:

• Service: Narrow to a specific connected service such as Snowflake or BigQuery.
• Asset Type: Filter by entity type such as Table, Topic, or Container.
• Has / Missing Metadata: Filter by metadata status — Missing, Incomplete, Inconsistent, or Complete.
• Add Filter: Add additional filters by Domain, Tags, or Glossary Terms.

This lets you focus on specific domains or systems.

​

Lineage Propagation

Column Bulk Operations also works with lineage. As columns move through pipelines and transformations, the governance metadata remains consistent across the data flow. This ensures column definitions stay aligned even as data moves across systems.