Company
Date Published
Author
Ellen Perfect
Word count
656
Language
English
Hacker News points
None

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.