If you’d like to upload data from a CSV to Mode’s public database, click on your avatar in the upper left corner of the screen and click Contribute Public Data in the drop down menu. Click the Choose and Upload button and select a CSV file up to 500 MB.
Setting names and data types
After the data uploads, you will have the opportunity to customize the name of the table and how the columns are stored. Note that the table will be uploaded to your namespace. When querying the table, you will be required to type the namespace first. In the example below, the user’s account name is “tutorial,” so the uploaded table name will include the “tutorial.” prefix:
Rules for naming tables:
- 4-63 characters
- must start with a lowercase letter
- must end with a number or letter
- no spaces or special characters (use underscores)
Once you decide on a table name, you can set the column names and types. Columns follow the same naming rules as tables, except that they can be as short as 2 characters.
If you are unsure about the data type for any particular column or would like a general overview of data types, check out the SQL School lesson.
When you are finished, click “Finish Import” at the bottom of the Customize Columns screen.
Last Updated February 28, 2017