SQL is the secret sauce that gives Census so much flexibility. A data warehouse gives you access to the complete view of data across the business but SQL makes it easy to select the exact data you need to provide to a sales team or to drive the next marketing campaign.
SQL gurus have super powers. But even a SQL guru knows the pain of getting all of the column names and table paths right on the first go. One more reason to put off getting started on that integration.
Today we’re excited to lend a helping hand. Now you can use AI directly inside Census to help write your SQL! Describe what you’re looking for and let AI get you started. Tweak and save!
SQL generation uses your existing Gemini, Anthropic, and OpenAI API keys you’ve created for AI Columns so that you are covered by the data terms of the provider you are selected. And Census does not send your actual data to any model for any reason, only the dataset name and column metadata is provided as a hint to write the SQL.
Use this to write a quick report on Salesforce conversions, or figure out how to join a recently uploaded CSV with the rest of your contacts in Hubspot. Today this is available for Datasets in Census Store, but stay tuned, we’ll be expanding to other data warehouse sources in the near future!