# data.world Destination

Data.world helps you host and share your data, collaborate with your team, and capture context and conclusions as you work.

This guide serves as a reference for version 1 of Stitch’s data.world destination.

## Details and features

* [Stitch features](https://help.qlik.com/en-US/stitch/destinations/data-world/reference#stitch-features)

* [Destination details](https://help.qlik.com/en-US/stitch/destinations/data-world/reference#destination-details)

* [data.world pricing](https://help.qlik.com/en-US/stitch/destinations/data-world/reference#pricing)

### Stitch features

High-level details about Stitch’s implementation of data.world, such as supported connection methods, availability on Stitch plans, etc.

| **Release status<br><br><br>[the Help icon](https://help.qlik.com/en-US/stitch/destinations/data-world/reference)** | Released |
| --- | --- |
| **Stitch plan availability<br><br><br>[the Help icon](https://help.qlik.com/en-US/stitch/destinations/data-world/reference)** | All Stitch plans |
| **Stitch supported regions<br><br><br>[the Help icon](https://help.qlik.com/en-US/stitch/destinations/data-world/reference)** | <ul><li>North America (AWS us-east-1)</li></ul><br><br>Operating regions determine the location of the resources Stitch uses to process your data. [Learn more](https://help.qlik.com/en-US/stitch/security/supported-data-pipeline-regions). |
| **Supported versions<br><br><br>[the Help icon](https://help.qlik.com/en-US/stitch/destinations/data-world/reference)** | Not applicable |
| **Connect API availability<br><br><br>[the Help icon](https://help.qlik.com/en-US/stitch/destinations/data-world/reference)** | **Unsupported<br>the Remove iconNot supported**<br><br>This version of the data.world destination is not currently available in Stitch’s Connect API. |
| **SSH connections<br><br><br>[the Help icon](https://help.qlik.com/en-US/stitch/destinations/data-world/reference)** | **Unsupported<br>the Remove iconNot supported**<br><br>Stitch does not support using SSH tunnels to connect to data.world destinations. |
| **SSL connections<br><br><br>[the Help icon](https://help.qlik.com/en-US/stitch/destinations/data-world/reference)** | **Supported<br>the Success iconSupported**<br><br>Stitch will attempt to use SSL to connect by default. No additional configuration is needed. |
| **VPN connections<br><br><br>[the Help icon](https://help.qlik.com/en-US/stitch/destinations/data-world/reference)** | Not applicable |
| **Static IP addresses<br><br><br>[the Help icon](https://help.qlik.com/en-US/stitch/destinations/data-world/reference)** | **Supported<br>the Success iconSupported**<br><br>This version of the data.world destination has static IP addresses that can be whitelisted. |
| **Default loading behavior<br><br><br>[the Help icon](https://help.qlik.com/en-US/stitch/destinations/data-world/reference)** | **Upsert**<br><br>**Note**: Append-Only loading will be used if all conditions for Upsert are not met. [Learn more](https://help.qlik.com/en-US/stitch/replication/loading/understanding-loading-behavior). |
| **Nested structure support<br><br><br>[the Help icon](https://help.qlik.com/en-US/stitch/destinations/data-world/reference)** | **Supported**<br><br>the Success icon<br><br>Supported<br><br><br>[Learn more](https://help.qlik.com/en-US/stitch/destinations/data-world/reference#transformations--json-structures). |

### Destination details

Details about the destination, including object names, table and column limits, reserved keywords, etc.

**Note**: Exceeding the limits noted below will result in loading errors or rejected data.

| **Maximum record size<br><br><br>[the Help icon](https://help.qlik.com/en-US/stitch/destinations/data-world/reference)** | 20MB |
| --- | --- |
| **Table name length<br><br><br>[the Help icon](https://help.qlik.com/en-US/stitch/destinations/data-world/reference)** | None |
| **Column name length<br><br><br>[the Help icon](https://help.qlik.com/en-US/stitch/destinations/data-world/reference)** | None |
| **Maximum columns per table<br><br><br>[the Help icon](https://help.qlik.com/en-US/stitch/destinations/data-world/reference)** | None |
| **Maximum table size<br><br><br>[the Help icon](https://help.qlik.com/en-US/stitch/destinations/data-world/reference)** | None |
| **Maximum tables per database<br><br><br>[the Help icon](https://help.qlik.com/en-US/stitch/destinations/data-world/reference)** | None |
| **Case sensitivity<br><br><br>[the Help icon](https://help.qlik.com/en-US/stitch/destinations/data-world/reference)** | Not applicable |
| **Reserved keywords<br><br><br>[the Help icon](https://help.qlik.com/en-US/stitch/destinations/data-world/reference)** | None |

### data.world pricing

While Stitch is compatible with all of data.world plans, keep in mind that the number of private projects/datasets and the size maximum of those projects varies by plan.

For more information on data.world’s plans, refer to their [pricing page](https://data.world/pricing).

## Replication

* [Replication process overview](https://help.qlik.com/en-US/stitch/destinations/data-world/reference#replication-process-overview)

* [Loading behavior](https://help.qlik.com/en-US/stitch/destinations/data-world/reference#loading-behavior)

* [Incompatible sources](https://help.qlik.com/en-US/stitch/destinations/data-world/reference#replication--incompatible-sources)

### Replication process overview

[![](https://help.qlik.com/en-US/stitch/images/destinations/data-world-replication-process.png)](https://help.qlik.com/en-US/stitch/images/destinations/data-world-replication-process.png)

Click to enlarge

#### Steps 1 & 2: Data extraction

Stitch requests and extracts data from a data source. Refer to the [System overview guide](https://help.qlik.com/en-US/stitch/getting-started/basic-concepts-system-overview#system-architecture--extraction) for a more detailed explanation of the Extraction phase.

#### Step 3: Load data into shared S3 bucket

Stitch will loads the raw JSON data into an Amazon S3 bucket shared between Stitch and data.world.

#### Step 4: Notify data.world

After Stitch successfully finishes loading into Amazon S3, a webhook notification is sent to data.world to trigger the retrieval process.

#### Steps 5 & 6: data.world retrieves data from S3

Data.world retrieves the data destined for your account from the shared Amazon S3 bucket.

#### Step 7: data.world loads your data

Data.world loads the data into your data.world account. Refer to the [Loading behavior](https://help.qlik.com/en-US/stitch/destinations/data-world/reference#loading-behavior) section below for more info on how your data will be structured in data.world.

### Loading behavior

When data.world retrieves an integration’s data from the Amazon S3 bucket, it will be loaded into your data.world account as a project with child datasets.

![](https://help.qlik.com/en-US/stitch/images/destinations/data-world-workspace.png)

For each integration you connect to Stitch, a project with the same name will be created in data.world. The tables you set to replicate will be stored as JSON datasets within the project.

For example: If you named an integration `HubSpot` in Stitch and selected the `companies`, `contact_lists`, and `contacts` tables to replicate, your workspace in your data.world account would be the same as the image on the right.

The dataset schema will contain the attributes you set to replicate in Stitch along with a few `_sdc` columns.

### Incompatible sources

No compatibility issues have been discovered between data.world and Stitch's integration offerings.

See all [destination and integration incompatibilities.](https://help.qlik.com/en-US/stitch/destinations/destination-integration-compatibility)

## Transformations

* [System columns](https://help.qlik.com/en-US/stitch/destinations/data-world/reference#system-columns)

* [JSON structures](https://help.qlik.com/en-US/stitch/destinations/data-world/reference#json-structures)

### System columns

The dataset schema will contain the attributes you set to replicate in Stitch along with a few `_sdc` columns. These are [system columns generated by Stitch](https://help.qlik.com/en-US/stitch/replication/loading/system-tables-columns) for replicating data.

For information about the data available in SaaS integrations - including column descriptions and potential data values - refer to the [**Schema** section of any of our integrations docs](https://help.qlik.com/en-US/stitch/integrations/saas).

### JSON structures

All replicated data is stored as JSON, both in Amazon S3 and in data.world after the final load is complete. This means that nested structures are stored intact.