How to choose database tools
Choose a group by the operation you need to perform. Analyze Tools covers queries and measurements, Compare Tools covers differences, and Convert Tools changes Parquet data into CSV. The input and output formats point you to the matching page. Check both the file format and the operation before opening a page.
Query CSV and JSON with SQL
Open Analyze Tools to inspect or measure database data. Its child page, SQL Query Tool for CSV and JSON, runs SQL against CSV and JSON files. Choose this group when those are your input formats and the result you need is a query result.
Compare Parquet files and SQL schemas
Choose Compare Tools when you need to examine differences. Parquet Diff compares Parquet files. SQL Schema Diff compares SQL schemas. Use the first page for file comparisons and the second for schema comparisons.
Convert Parquet data to CSV
Use Convert Tools when the required output is a different file format. Parquet to CSV Converter converts Parquet data into CSV. Choose it when Parquet is the input and CSV is the output.
Where database tools come up
- You have CSV or JSON data and need to query it with SQL. Open SQL Query Tool for CSV and JSON.
- You need to compare two SQL schemas. Open SQL Schema Diff.
- You need to compare Parquet files. Open Parquet Diff.
- You have Parquet data and need CSV output. Open Parquet to CSV Converter.
Start in the right data tools group
Match Analyze Tools with CSV or JSON queries and measurements. Match Compare Tools with Parquet-file or SQL-schema differences. Match Convert Tools with Parquet-to-CSV conversion. For cleaning, validating, merging, or another data format, open the broader Data Tools category.
Frequently asked questions
Which database tool should I use to query CSV or JSON?
Use SQL Query Tool for CSV and JSON to run SQL against CSV or JSON data. It belongs to Analyze Tools.
How can I compare two Parquet files?
Use Parquet Diff to compare two Parquet files. It belongs to Compare Tools.
What compares SQL schemas?
SQL Schema Diff compares SQL schemas. Choose it for schema differences.
How do I convert a Parquet file to CSV?
Use Parquet to CSV Converter to convert Parquet data to CSV. It belongs to Convert Tools.