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 any HTTP API to populate your columns

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

• Embedding Columns - Use OpenAI to generate vector embeddings for your dataset, which can then be synced to vector databases like turbopuffer or Pinecone

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