科技回声

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. Useful for when you need to join data together that's stored in two separate data warehouses (e.g. finance and product data).

For small datasets, this is good, but for anything significant, using the database's native bulk load will be more efficient than INSERT statements.

This is neat! Correct me if I'm wrong, but don't a lot of systems already have the ability to ingest CSV data? Why this intermediate step?

There are many browser based solutions for quick CSV to SQL also - i.e. www.convertcsv.com/csv-to-sql.htm

One can do this with the sqlite3 CLI tool.

For small datasets, this is good, but for anything significant, using the database's native bulk load will be more efficient than INSERT statements.

This is neat! Correct me if I'm wrong, but don't a lot of systems already have the ability to ingest CSV data? Why this intermediate step?

There are many browser based solutions for quick CSV to SQL also - i.e. www.convertcsv.com/csv-to-sql.htm

One can do this with the sqlite3 CLI tool.

Show HN: Turn CSV Files into SQL Statements for Quick Database Transfers

4 条评论

Show HN: Turn CSV Files into SQL Statements for Quick Database Transfers

4 条评论