Querying CSV and Parquet exports inside a SQL IDE with DuckDB

Описание и применение

Используйте omni-sql для импорта CSV/Parquet и выполнения 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.

Источник