Custom Columns
Custom Columns let you enrich your cloud asset inventory with metadata from any source, like ownership, cost, security scores, lifecycle tags, and more, alongside your native cloud resource data.
CloudQuery’s Custom Columns feature allows you to define new columns on any asset table and populate them via SQL expressions (e.g., extracting tags or fields).
Once added, these columns become:
Filterable in the UI
Searchable via SQL
Queryable in reports and dashboards
Creating a Custom Column
You can create a Custom Column via the UI:
Navigate to: Settings → Custom Columns
Click: Add Column
Fill in:
Label: UI display name (e.g., “Team”)
Name: Backend ID (snake_case)
Description (optional): Purpose of the column
Enrichment Type:
From existing field → Use a SQL expression
From external source → Populate via API
Value Expression: SQL to extract or transform the value (e.g., tags['team'])
Once saved, the column appears in the asset inventory and can be filtered/searched just like native fields.
Supported SQL Expressions
Tag Extraction
JSON Parsing
Normalization / Cleanup
Conditional Defaults
Lifecycle Metadata
Example Use Cases
Column
Type
Expression / Source
Description
team
String
tags['team']
Surface team ownership
normalized_env
String
lower(tags['env'])
Normalize inconsistent tag values
scheduled_delete
Date
parseDateTimeBestEffort(tags['deletion'])
Track lifecycle cleanup dates
Query Examples
Last updated
Was this helpful?