# Osmos Dataset

## Osmos Dataset Destination Connector Overview

The Osmos Dataset Destination Connector is used to store records in an Osmos Dataset.   The Osmos Dataset Destination Connector can be created via two methods.  First, it can be automatically created from a Osmos Dataset Table.  When you select create Osmos Uploader from your Table, it will create both an Osmos Uploader *and* a new Osmos Dataset Connector.   The second method is through the standard connector creation process.    This connector can be leveraged with both an Uploader or a Pipeline.

## Automatic Creation

When you select create Osmos Uploader from your Table, it will create both an Osmos Uploader *and* a new Osmos Dataset Connector.  The Osmos Dataset Connector will populate the fields, including schema, based on your Table layout.

Note:  Automatic creation is the recommended method over Manual Creation

<figure><img src="https://353417064-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MYrsDW6vGBTygB1qqSE%2Fuploads%2FTB0hauAVLFjZw2QoeJ13%2FCleanShot%202023-04-11%20at%2022.38.38%402x.png?alt=media&#x26;token=badccdbe-6808-410b-9745-5ed051a27f1a" alt=""><figcaption></figcaption></figure>

<figure><img src="https://353417064-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MYrsDW6vGBTygB1qqSE%2Fuploads%2FdWDqJFQFXjjoLxGkMBWi%2FCleanShot%202023-04-11%20at%2022.39.25%402x.png?alt=media&#x26;token=f486221e-44cc-4e55-a341-92b5a98499cc" alt=""><figcaption><p>Table Information passed onto the Destination Connector</p></figcaption></figure>

## Manual Creation

An Osmos Dataset Destination Connector can be created through the standard connector creation process.  &#x20;

## **Prerequisites**

Required information:

1. Osmos [Dataset](https://docs.osmos.io/datasets/getting-started)
2. Osmos [Table](https://docs.osmos.io/datasets/getting-started/uploading-data-to-your-table)

## Creating a Osmos Dataset Destination Connector

**Step 1:** After selecting **+ New Connector**, under the **System** prompt, click **Osmos Dataset.**

<figure><img src="https://353417064-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MYrsDW6vGBTygB1qqSE%2Fuploads%2FmVr8iepwopIQ7neg85vm%2FCleanShot%202023-04-13%20at%2010.39.27%402x.png?alt=media&#x26;token=0a6ebe94-e5e9-47e7-8f02-d81695fbb9f0" alt="" width="249"><figcaption></figcaption></figure>

**Step 2:** Provide a **Connector Name.**

**Step 3:** Select **Destination Connector.**

**Step 4:** Select the **Dataset.**

**Step 5:** Select the **Table.**

**Step 6:** Check the box if you wish for the data to **Upsert** **.**

#### Insert/Upsert

By default Osmos Uploaders created automatically will be configured to insert data, and fail in the case that Primary Keys overlap. If an uploader should be configured to upsert data, an uploader should be manually created with this configuration. &#x20;

**Step 7:** Hit **Save.**

<figure><img src="https://353417064-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MYrsDW6vGBTygB1qqSE%2Fuploads%2FRUDW6P7HgfUFWh32guNV%2FCleanShot%202023-06-02%20at%2012.07.10.png?alt=media&#x26;token=f3a82801-81f0-401f-acc7-343b80ddea86" alt=""><figcaption></figcaption></figure>

Note: The Osmos Dataset Connector will be linked to your Osmos Table

Resulting Connector detail:&#x20;

<figure><img src="https://353417064-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MYrsDW6vGBTygB1qqSE%2Fuploads%2F56IO7KtdcL7dgIfoxyz3%2FCleanShot%202023-05-25%20at%2011.51.22.png?alt=media&#x26;token=261eb918-60d6-46cd-8595-8c2b6afa199d" alt=""><figcaption></figcaption></figure>

Note the original Inventory table from the Master Records Dataset:

<figure><img src="https://353417064-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MYrsDW6vGBTygB1qqSE%2Fuploads%2F2okf2AaFhgyQC6LRddsO%2FCleanShot%202023-05-25%20at%2011.52.44.png?alt=media&#x26;token=5fade6a2-6004-46db-b821-2839c3688ad2" alt=""><figcaption></figcaption></figure>

## Connector Options

The connector can be deleted, edited and duplicated.

Duplication

To save time, the connector can be duplicated.  This new connector needs to be named and can be edited, as needed.

<figure><img src="https://353417064-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MYrsDW6vGBTygB1qqSE%2Fuploads%2FEyIEMPa6mseHoYSjd7a2%2FCleanShot%202024-01-04%20at%2020.53.21%402x.png?alt=media&#x26;token=f90d048d-6bb2-4807-8278-ba26bfc4870e" alt="" width="563"><figcaption></figcaption></figure>
