This project makes it easy to move excel, CSV, JSON, and other data into your data warehouse so you can analyze adhoc data sets with less data prep.

Search code, repositories, users, issues, pull requests...

submited by
Style Pass
2024-06-10 12:30:03

This project makes it easy to move excel, CSV, JSON, and other data into your data warehouse so you can analyze adhoc data sets with less data prep. Simply upload a file or paste what you need into SQLGeneator and it will turn it into the SQL you need to either filter your existing data or ingest it directly into your warehouse. Great for when you need to run adhoc analyses on data that's not natively available in a single warehouse.

It's hosted at sqlgenerator.io and runs everything client-side, so you can use this tool without sharing your data. However, if you'd like to clone it and host it on your own tools for added safety, please provide attribution to the project on GitHub.

Additionally the initial structure was developed using plandex, an open source, terminal-based AI coding engine that helps you complete large tasks, work around bad output, and maximize productivity.

1/ In-Clause Generator. Generates SQL in-clauses from pasted data. Great when you have a CSV containing identifiers like customer or order IDs that you want to filter an existing table on.

Leave a Comment