Uploading Data to your Table

In this section you will learn how to upload data into a table.

Overview

Once you have created your table, you will need to upload data. The easiest way to import data is through the Osmos Uploader. It is a one-step process to create an Osmos Uploader and an Osmos Dataset Destination Connector.

Building an Osmos Uploader with Your Table

Create an Uploader directly from your newly created Table.

Step 1: From the Table list select Create Uploader.

Osmos automatically creates both the Uploader and a new Destination Connector. When creating the Uploader directly from the Table, the name of both the Uploader and the Connector will be a combination of the dataset & table names.

Your new Osmos Uploader is ready for use!

Uploading Table Data

You can use the Osmos Uploader within Osmos to import data into your table. All standard Osmos Uploader functionality applies. Click here to learn more about Osmos Uploaders.

Dataset Table Actions

From a Dataset Table, you can take three actions:

1. View Table Schema

2. Download data in the table

3. Clone a Table.

View Table Schema

In the table schema, you can Clone the table, delete the table, view the schema, and view related connectors.

Default view displays the schema:

Selecting the Connectors tab displays the related connector(s).

Download and View Data

Clicking on the download icon under Actions downloads all of the data that resides in your Table. This will download your dataset into a CSV file format for review.

Other methods:

1. Click on the Query Builder icon for the Dataset. This will launch the Query Builder for you to create the table or cross-table view.

2. Click on the individual Table Name. This will launch table detail via the Query Builder.

3. You can also view the imported data directly from the Uploader. You can link directly by clicking on the Uploader Status field or the Actions, on the right.

Cloning Table Data

Tables can be duplicated into existing Datasets or a different Dataset. Note, that this process will duplicate all of the data in addition to the schema. You can edit the schema before the completion of the cloning.

Step 1: From the Table list select the Clone Table icon.

Step 2: Select a Project ID.

Step 3: Select a Dataset Name.

Step 4: Provide a Table Name.

Step 5: Select Clone.

Step 6: Make any edits to the newly created table. These include adding/deleting/changing field names, field types, and required status', along with setting primary keys.

Step 7: Select Save.