What is tap?

Learn about how tap can make working with data files easy.

Data can often be found in files, whether you work with them everyday in spreadsheets, came across an interesting open dataset, or they're just the easiest way to get data out of a legacy system. tap simplifies the transformation, joining and serving of data from these files with flexible and powerful SQL queries and documented, secured APIs.

With tap you can:

1. Upload CSV, JSONL, Parquet and other files or folders of any size.
2. Analyse, transform, join and enrich your datasets with SQL.
3. Create documented, secured and performant APIs with customisable filters.

This will allow you to:

1. Enhance your data wrangling capabilities and share with downstream development teams or stakeholders.
2. Focus on user value, removing the toil of consuming open or internal data, via Data APIs.
3. Unlock the social value of public and private data. Speak to us about your data sharing needs.

For example, if you are a developer a typical workflow in tap to go from a static file to a documented, secured, monitored and performant API looks as follows:

1. Upload the files to a storage bucket provided by tap or ensure the data at rest never leaves your infrastructure by bringing your own storage (get in touch).
2. Use SQL to join between datasets, transform columns or just expose the data from the file as is. See the SQL reference for more details.
3. Set up the URL and configure your desired filters for the API. See the Filter reference for more details.
4. Share API keys for the API with your consumer(s)/application.

That's it! You are ready to programmatically consume your data!

Next: learn the key concepts.