Census – Export for data warehouses
Hello Hacker News! We're a team of YC founders (Meldium W13, Draft S11, TapEngage S11) launching something new (https://www.getcensus.com). How many times has your business team asked you to generate yet another CSV file, write a ”quick report” in SQL, or send some custom data to a terrible API (looking at you Marketo)? 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…
What it does
In the maker’s words, at launch
Hello Hacker News! We're a team of YC founders (Meldium W13, Draft S11, TapEngage S11) launching something new (https://www.getcensus.com). How many times has your business team asked you to generate yet another CSV file, write a ”quick report” in SQL, or send some custom data to a terrible API (looking at you Marketo)? 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!
Does the same job
all alternatives →
- TCThe Canada census data in a SQLite file; advice appreciated2024 · github.com · ▲6
This is niche, I'll admit. I needed to look through the latest census data, but it was exported as multiple multi-gigabyte bespoke latin1-encoded CSV files. Pandas, Polars, and SQLite's CSV import tool weren't much help, so I shelved the project until recently, when I started taking a SQLite course online. I picked it up again, normalized the data, and now there's a database that can be queried through a SQL view that matches the headings in the original CSVs. I'm proud of the script I created to export the data, as well as automatically compress the artifact, make the diagrams and…
- PFPlatform for data scientists2013 · ▲7
Hi there Hacker News, I've started a side project http://datasourcehub.com which aims to be a platform for data scientists. The project is still in the idea phase so the UI/UX and functionality are all subject to change. Feel free to play around, below is a guest login, and make sure files are content type of 'text/csv'. All data is subject to deletion, it's just a sandbox right now! By reaching out to the Hacker News community I hope to reach expert data scientists and get their feedback. Below are some questions I'd like to answer and some proposed directions that this…
More dev tools this month
the category →
Open-source GTM skills for technical founders
Dev tools · 29d ago · gtmcofounder.com
OpenTrailPaper is open-source bike computer firmware for the LilyGO T5S3 4.7" E-Paper PRO. It supports offline maps, GPX routes, FIT recording and Bluetooth sensors.
Dev tools · 1d ago · opentrailpaper.com
Launched alongside, April 2020
the whole month →- AB
Life & fun · 2020 · youtube.com
- FM
Life & fun · 2020 · gitlab.com
