Querying CSV and Parquet exports inside a SQL IDE with DuckDB

说明与用途

使用 omni-sql 将 CSV/Parquet 导入本地 DuckDB 并执行 SQL 查询，以快速分析数据，无需设置数据库。

问题

Investigate a CSV export for duplicates, grouping, or comparison without lengthy database setup.

结果

The joined query revealed that South reached 84% of its target, demonstrating the ability to combine external CSV data with database query results locally.

工作流

• Run the sales query on PostgreSQL and export the full result to a file.
• Import targets.csv into the local DuckDB workspace using omni-sql.
• Run a JOIN query in the local SQL tab to combine the query result with the CSV data.
• Review the output to identify gaps and target percentages.

证据

Someone sends you a CSV export and asks you to investigate it. You need to check duplicates, group records, or compare it with another export.

来源

You can import CSV or Parquet and query it with SQL inside the IDE.

来源

The demo uses fictional sales rows from PostgreSQL and a CSV of regional targets.

来源

The result shows South reaching 84% of its target.

来源

The app runs locally and doesn't require an account.

来源