Show HN: Census – Export for data warehouses
We’ve built a product that connects directly to your data warehouse and syncs into apps like Salesforce, Customer.io and even Google Sheets. In fact, your business teams won’t even need to rely on engineering to manage all these pipelines.
The tech stack for analyzing customer data in 2020 looks pretty great. You can load almost any data into an auto-scaling data warehouse (Snowflake, BigQuery) with easy point & click tools like Fivetran. You can build SQL models with dbt and create visual reports in Metabase. But you can’t easily push insights back into the marketing/sales/support apps.
You can’t solve this with direct app integrations or “event routers” like Zapier and you definitely shouldn’t over-engineer a solution with Spark/Kafka/Airflow. We designed Census to make your data warehouse a single source of truth for modeling and transformation before publishing data back into your SaaS tools quickly and reliably.
We’re proud of what we’ve built so far and there’s a lot more work to deliver on our dream of saving us all from generating & uploading yet another CSV file so we can spend more time actually building our products (or reading HN). You can check it out at https://www.getcensus.com.
Since this is HN, we’d love to hear everyone’s war stories on building internal ETL solutions!