Upload a CSV

You can upload a dataset either by connecting to a database or by uploading a CSV. Ensure that a final version of the dataset is uploaded. The data pillar will have taken care of uploading important datasets onto Superset. If you have a CSV that you want to explore, upload a CSV.

../_images/upload_csv1.png

As an example, KHOJ dataset will be used in this handbook. Upon clicking upload CSV to database a settings window will open. You can leave most of the settings default. But make note of the following settings:

  1. Table Exists:

../_images/upload_csv_tableexists.png

  1. Parse dates:

../_images/upload_csv_parsedates.png

Once uploaded, a Dataset gets created in the Superset. You can check all the uploaded CSVs here:

../_images/upload_csv_datasets.png

By default every column in the Dataset will be GROUPABLE and FILTERABLE. However, if there are dates/times in any of the columns, those columns should be identified as TEMPORAL. It will help in building time series charts.

To enable such operations on each of the columns, edit the table that you uploaded. You can do that by clicking on the pen button at the end of the table row. Hover the cursor under the Actions column to find it.

../_images/upload_csv_edittable.png

With that you have succesfully uploaded a CSV on to the Superset.