Six years ago we built a homemade tool for our internal users to download CSV files based on a SQL query. There is two kind of users :

  • Admins who can define a SQL query with parameters
  • Users who can run a query specifying those parameters and download a CSV

I'm looking for a replacement of this tool, so far we have considered Tableau and the data importer feature of Excel. None of them were satisfying.

What I expect from the tool :

  • User Friendly & Web based (no need for any local installation)
  • Work with Millions of rows
  • Doesn't require SQL skill
  • Connect with any kind of Database
  • Queries can be parameterized

I'm turning around on this since a while.Thank you deeply for your answers.

  • What is the structure of your data? Could all of your data fit in a single huge CSV file, and if yes, how many columns would there be?
    – Nicolas Raoul
    Jul 18 '19 at 9:51
  • You want to run it with particular kind of database(like Postgresql or MySQL) or with any database ?
    – Bhushan
    Jul 19 '19 at 7:11
  • Usually a single big csv file is fine with up to 30 columns Jul 19 '19 at 17:42
  • Running on Impala in our case Jul 19 '19 at 17:42

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.