So far, you have created a database and added tables to it but there is no data in it yet. This article shows you how to load your data into the table.

Prerequisites

You will have

This screen shows the newly created table. It has no data in it as indicated by the zero row count.

From the Database Screen, click Load table.  

On the Select Data to Load screen:

  1. Select a data file (such as csv or tsv, either in plain text or gzipped; please note  parquet file format is not supported).
  2. Select how the data is separated (e.g. comma, tab, pipe).
  3. Select 'append'. Note: 'replace' is not currently an option.
  4. If text fields are separated, how they are separated.
  5. Important! If there are header rows with the field names, select how many.
  6. When you have finished, click Done, Load Data.

A message pops up informing you that your job has been queued.

How long it takes for your data to be loaded will vary according to how much data is involved.

Click Go to Load Jobs.

The job is listed with a message to indicate that it has been loaded successfully. 

Managing errors

If there were errors, as shown in the second example, it is most likely due to a mismatch between the columns in the table and the data load. Click Show Errors to find the cause and then go back to create a new table.  For additional tips, refer to tips for creating a table.

Note: Once a table has been created, it cannot be edited. If you experienced errors when loading data to the table, you will need to create a new table to fix any errors, and load the data again. Once complete, you can delete any tables with errors.

To create a new table:

  1. Navigate to the Databases tab on the Manage Data screen.
  2. Click on 'View or Edit Database' next to the database you want to create a table for.
  3. Click 'Create table'. For more information, refer to Creating a table in the Senate database.

To delete a table:

  1. Navigate to the Databases tab on the Manage Data screen.
  2. Click the ellipsis button (3 dots), and select Delete table.

Next step: 

Checking that the data loaded successfully

Did this answer your question?