Title: Hi HN,<p>We&#x27;re Allison and Steve of Syndetic (<a href="https:&#x2F;&#x2F;www.getsyndetic.com" rel="nofollow">https:&#x2F;&#x2F;www.getsyndetic.com</a>). Syndetic is a web app that data providers use to explain their datasets to their customers. Think ReadMe but for datasets instead of APIs.<p>Every exchange of data ultimately comes down to a person at one company explaining their data to a person at another. Data buyers need to understand what&#x27;s in the dataset (what are the fields and what do they mean) as well as how valuable it can be to them (how complete is it? how relevant?). Data providers solve this problem today with a &quot;data dictionary&quot; which is a meta spreadsheet explaining a dataset. This gets shared alongside some sample data over email. These artifacts are constantly getting stale as the underlying data changes.<p>Syndetic replaces this with software connected directly to the data that&#x27;s being exchanged. We scan the data and automatically summarize it through statistics (e.g., cardinality), coverage rates, frequency counts, and sample sets. We do this continuously to monitor data quality over time. If a field gets removed from the file or goes from 1% null to 20% null we automatically alert the provider so they can take a look. For an example of what we produce but on an open dataset check out the results of the NYC 2015 Tree census at <a href="https:&#x2F;&#x2F;www.getsyndetic.com&#x2F;publish&#x2F;datasets&#x2F;f1691c5d-56a9-47d4-8df7-a373a2894c8b" rel="nofollow">https:&#x2F;&#x2F;www.getsyndetic.com&#x2F;publish&#x2F;datasets&#x2F;f1691c5d-56a9-4...</a>.<p>We met at SevenFifty, a tech startup connecting the three tiers of the beverage alcohol trade in the United States. SevenFifty integrates with the backend systems of 1,000+ beverage wholesalers to produce a complete dataset of what a restaurant can buy wholesale, at what price, in any zipcode in America. While the core business is a marketplace between buyers and sellers of alcohol, we built a side product providing data feeds back to beverage wholesalers about their own data. Syndetic grew out of the problems we experienced doing that. Allison kept a spreadsheet in dropbox of our data schema, which was very difficult to maintain, especially across a distributed team of data engineers and account managers. We pulled sample sets ad hoc, and ran stats over the samples to make sure the quality was good. We spent hours on the phone with our customers putting it all together to convey the meaning and the value of our data. We wondered why there was no software out there specifically built for data-as-a-service.<p>We also have backgrounds in quantitative finance (D. E. Shaw, Tower Research, BlackRock), large purchasers of external data, where we&#x27;ve seen the other side of this problem. Data purchasers spend a lot of time up-front evaluating the quality of a dataset, but they often don’t monitor how the quality changes over time. They also have a hard time assessing the intersection of external datasets with data they already have. We&#x27;re focusing on data providers first but expect to expand to purchasers down the road.<p>Our tech stack is one monolithic repo split into the frontend web app and backend data scanning. The frontend is a rails app and the data scanning is written in rust (we forked the amazing library xsv). One quirk is that we want to run the scanning in the same region as our customers&#x27; data to keep bandwidth costs and transfer time down, so we&#x27;re actually running across both GCP and AWS.<p>If you&#x27;re interested in this field you might enjoy reading the paper &quot;Datasheets for datasets&quot; (<a href="https:&#x2F;&#x2F;arxiv.org&#x2F;pdf&#x2F;1803.09010.pdf" rel="nofollow">https:&#x2F;&#x2F;arxiv.org&#x2F;pdf&#x2F;1803.09010.pdf</a>) which proposes a standardized method for documenting datasets modeled after the spec sheets that come with electronics. The authors propose that “for dataset creators, the primary objective is to encourage careful reflection on the process of creating, distributing, and maintaining a dataset, including any underlying assumptions, potential risks or harms, and implications of use.” We agree with them that as more and more data is sold, the chance of misunderstanding what’s in the data increases. We think we can help here by building qualitative questions into Syndetic alongside automation.<p>We have lots of ideas of where we could go with this, like fancier type detection (e.g. is this a phone number), validations, visualizations, anomaly detection, stability scores, configurable sampling, and benchmarking. We&#x27;d love feedback and to hear about your challenges working with datasets!
Upvote: