Apache Superset/Metabase/Apache Zeppelin Query CSV/Excel/Parquet files from MindsDB

CA Amit Singh
Free or Open Source software’s
4 min readJan 2, 2024

Learn to upload CSV/Excel/Parquet File in MindsDB & Query from Apache Superset/Metabase/Apache Zeppelin.

Step 01: Click on Upload File.

Step 02: Click on Import a File.

Step 03: Select a CSV File from Your System and click on Open.

Step 04: Or Select Excel file from your system and click on open

Step 05: Or Choose Parquet File from your system and click on Open.

Step 06 : Name your CSV and click on save and continue

Step 07: Or Name your Excel file and click on save and continue

Step 08: Or Name your Parquet file and click on save and continue.

Step 09: Now click on CSV File to see the data under files section.

Step 10: Now click on Excel file to see your data under Files section.

Step 11: Now click on Parquet file to see your data under files section.

Step 12: Now write the SQL Queries in Apache Zeppelin to Query CSV files as shown in below screenshot step by step.

Step 13: Now write the SQL Queries in Apache Zeppelin to Query Excel files as shown in below screenshot step by step.

Step 14: Now write the SQL Queries in Apache Zeppelin to Query Parquet files as shown in below screenshot step by step.

Step 15: Now in Metabase, Click on SQL Query to write simple query for CSV Files.

Step 16: Now select your database as mindsdb and write simple SQL select command for CSV File and click on run as shown in below screenshot step by step

Step 17: Now select your database as mindsdb and write simple SQL select command for Excel File and click on run as shown in below screenshot step by step

Step 18: Now select your database as mindsdb and write simple SQL select command for Parquet File and click on run as shown in below screenshot step by step

Step 19: In Apache Superset, Click on SQL Lab to run queries on selected data source.

Step 20: Now follow the screenshot steps to run query on CSV Files

Step 21: Now follow the screenshot steps to run query on Excel Files

Step 22: Now follow the screenshot steps to run query on Parquet Files

How to Upload Parquet File in MindsDB and Run SQL on Parquet File in Metabase

How to Upload Parquet File in MindsDB and Run SQL on Parquet File in Apache Zeppelin

How to Upload Excel File in MindsDB and Run SQL on Excel File in Apache Zeppelin

How to Upload Excel File in MindsDB and Run SQL on Excel File in Metabase

How to Upload Excel in MindsDB and Query in Apache Superset

How to Upload Parquet file in MindsDB and Query in Apache Superset

How to Upload CSV in MindsDB and Run SQL on CSV in Metabase

How to Upload CSV in MindsDB and Query in Apache Zeppelin

How to Upload CSV in MindsDB and Run SQL on CSV in Apache Superset

--

--

CA Amit Singh
Free or Open Source software’s

Qualified Chartered Accountant & Multi Technology Trainer with 24 yrs of Multi Technology/ Multi Industry Experience. www.linkedin.com/in/ca-amit-singh-07babb