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:

  • Uploaded data onto the Data Republic platform. Note: The uncompressed size of the data must be less than 2GB. If your data is larger 2GB, please split into separate files and load each file individually into the table.

  • Created a database and tables

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. Either select a single data file (such as CSV or TSV, either in plain text or gzipped); or select a folder. When uploading a folder, every file will be loaded into the table. This is the preferred method for loading a large number of files into a single table.

  2. Note: Compressed files should have the extension .csv.gz. Uncompressed files should have the extension .csv.

  3. Select how the data is separated (e.g. comma, tab, pipe).

  4. Select 'append'. Note: 'replace' is not currently an option.

  5. Important! If there are header rows (e.g. for field names), select how many rows comprise the header. These rows are skipped. Note: When loading a folder, all files should have zero header rows.

  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.

PRO TIP: If you are loading multiple files to a table, you can select the folder during the load process and that will load all files within that folder to the table. It is important that none of the files contain header rows.

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 the name of the database you want to create a table for.

  3. Click 'Create table'. For more information, refer to Creating a table in the database.

To delete a table:

  1. Navigate to the Databases tab on the Manage Data screen.

  2. Click 'Delete Table'.

Next step: 

Checking that the data loaded successfully

Did this answer your question?