Home / Companies / Census / Blog / Post Details
Content Deep Dive

Two Ways to Enrich Directly in the Warehouse

Blog post from Census

Post Details
Company
Date Published
Author
Ellen Perfect
Word Count
656
Company Posts That Month
4
Language
English
Hacker News Points
-
Post removed?
No
Summary

We developed a method for performing API enrichments in the warehouse using Snowflake external functions, allowing us to cut down on API usage, keep our data fresh, and maintain consistency across all apps. However, this process was time-consuming and grew in complexity with every provider. We've now made it easier by introducing HTTP columns in Census, which enables users to set up enrichments from any API endpoint directly in the platform, without lengthy setup or SQL maintenance. This allows users to sync enriched datasets directly to any connection, and can be used for free or low-cost APIs such as MaxMind, US Postal Service, or internal services.

Trends Found in this Post
Trend Post Mentions Total Month Mentions Posts Companies MoM
Data Pipeline 1 439 171 69 -12%
Use This Data

Use this post, company, and trend context to find content marketing opportunities, perform competitive analysis, or address product feature gaps via the Plushcap MCP server or the Plushcap API.