Two Ways to Enrich Directly in the Warehouse
Blog post from Census
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.
| Trend | Post Mentions | Total Month Mentions | Posts | Companies | MoM |
|---|---|---|---|---|---|
| Data Pipeline | 1 | 439 | 171 | 69 | -12% |
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.