← Latest products

Turn CSV Files into SQL Statements for Quick Database Transfers

This package takes a CSV and generates SQL statements to create a temp table and insert the data within it into the temp table. Good when you need to move data between warehouses for ad hoc analysis and the warehouses are not otherwise connected. This package lets you unload a CSV from a warehouse, turn that CSV into SQL statements creating a temp table and inserting data with a CLI command, and copy those SQL statements into your query editor so you can start using the data in a different warehouse.

Open source

16 stars · GitHubexternal site

Visit github.comexternal site

Reactions (1)

Similar products

by description similarity

  1. SQL Generator

    github.com

    OS React App for SQL Table/Insert Statement Generation

    Hacker News12 pts

  2. Hacker News25 pts

  3. Sqlite3-dump

    github.com

    a fast SQLite to CSV and parquet

    Hacker News19 pts

  4. Build data pipelines with SQL and Python, ingest data from different sources, add quality checks, and build end-to-end flows.

    Hacker News200 pts

  5. Learn database internals by implementing it from scratch.

    Hacker News371 pts