Home / Companies / Tinybird / Blog / Post Details
Content Deep Dive

Querying large CSVs online with SQL

Blog post from Tinybird

Post Details
Company
Date Published
Author
Xoel Lopez
Word Count
605
Language
English
Hacker News Points
-
Summary

Tinybird offers a solution for quickly uploading and querying large CSV files without the need for additional software installations or reliance on cumbersome online tools. Users can upload CSVs from local sources or remote URLs, perform swift SQL queries directly in their browser leveraging ClickHouse technology, and easily share results via snapshots or dynamic API endpoints. Tinybird supports a variety of file types, including NDJSON and Parquet, and enables users to execute complex operations like joins and aggregations efficiently. The platform allows for the creation of API endpoints from query results, facilitating data sharing in multiple formats such as CSV, JSON, and Parquet. Additionally, Tinybird provides a free plan allowing users to store up to 10 GB of data and perform up to 1,000 API requests daily without cost, making it a versatile tool for managing and analyzing extensive datasets.