Smart Columns

Learn how to use Smart Columns to extend your datasets in Census

Smart Columns gives you the ability to add additional columns to your datasets a variety of different ways that can be hard to do directly in SQL

• AI Columns - Use an LLM of your choice to generate complex logic, format, or connect to tools

• Enrichment Columns - Connect to an external firmographic service or any HTTP API to populate your columns

• Computed Columns - No-code way to define formulas and aggregations

Check out each section for more details on how Smart Columns can extend your data.