Column templates are reusable sets of columns that can be applied across multiple tables and views in your project. The AI assistant can perform the following operations:
1. Attach a Column Template to Tables/Views
Apply an existing column template to one or more tables or views at once. The template's columns are automatically added to all selected objects, making it easy to enforce consistent column standards across your data model.
2. Detach a Column Template from Tables/Views
Remove a column template from one or more tables or views. When detaching, you can choose to:
- Keep the columns that the template contributed
- Remove the columns that the template contributed
3. Query Column Template Information
Retrieve details about column templates in the project, including:
- Template names and identifiers
- Column definitions (name, data type, nullability)
- Which tables and views have a given template attached
Limitations
The AI assistant cannot create or modify column template definitions — this is managed through the application UI. To create a new template or edit its columns, use the column template manager in the application directly.
Common Use Cases
- Attaching an audit template (
created_at,updated_at,created_by) to all fact and dimension tables - Enforcing SCD Type 2 columns (
effective_date,expiry_date,is_current) across dimension tables - Applying data lineage metadata (
source_system,batch_id,load_timestamp) consistently across ingestion tables - Cleaning up by detaching templates that are no longer relevant to specific tables