Overview

You can load CSV or JSON to your {{home}} (Home Database )

Steps

1. Click on “Settings” in the left sidebar

2. Select “CSV”

   

3. Choose a table name

4. Drag a CSV into the “drop zone”

5. Use your table!

   select * 
   from {{home}}.my_table
   limit 10 
   

Notes

• All columns are loaded as String's. If your column is a different type, simply cast it using the CAST() or column_name::type

  SELECT select column_name::int/2 
  FROM {{home}}.table_name