Data Connections

Data Connections enable you to securely upload and update datasets in Anaconda Cloud. You can then provide access to other users, as well as import your datasets to a separate workbook to continue your data analysis from any machine, anytime.

Understanding connections

Let’s take a look at the different elements and tabs within Data Connections.

1. All

   Shows active workbook contents and all projects

2. Connections

   Displays datasets previously uploaded to or downloaded from Anaconda Cloud

3. New Project

   Create a new project to store and share datasets (sheets and tables)

4. Filters

   Apply filters to efficiently locate data in your catalog

5. This Workbook

   A collection of datasets in your current workbook

6. My Projects

   A collection of all your cloud projects and their nested datasets

7. User Shared Projects

   Projects to which you have access, owned by other individuals

8. Org Shared Projects

   Projects to which you have access, owned by organizations

9. Status Icons

   Indicates the connection status of your dataset

Creating a project

When you first access Data Connections, you are prompted to create a new project. You can think of projects as folders for storing your datasets.

Create a project at any time using the following steps:

1. From the All tab, click + New Project.

   

2. Enter a unique title for your project and an optional description.

3. Designate the project owner(s) for your project. By default, you are set as the only project owner.

   Note

   Administrators and project owners are the only users allowed to edit projects. Anaconda Cloud organization administrators have full permissions for any projects owned by their organization.

4. (Optional) Provide access to your project by inviting users from one of your organizations.

5. Click Save.

Sharing a project with other users

You can share a project to collaborate with others in your organization when creating a new project, or at any time using the following steps:

1. From the All tab, click actions beside a project for which you have edit permissions, then click Edit.

2. Provide access to your project by inviting users from one of your organizations.

   1. Under Your Organizations, select an organization.

   2. Under Organization Users, select a user to share your project with.

   3. Choose whether the user should have read or write access to your project.

3. Click Save.

Permissions

Access to projects and the actions you can perform in them are determined by your permission level for the project. By default, you as the owner of your project have admin permissions; for projects owned by an organization, the admins of that organization have admin permissions for that project.

Permission level	Actions
Read	View, download
Edit	View, download, upload
Admin	View, download, upload, share, delete

Uploading data

Protect your local datasets and increase their accessibility by saving them in Cloud Storage. If you experience hardware failure, or need to work on a different device, your projects will be right where you left them!

Upload sheets and tables to your projects using the following steps:

1. Select the All tab, then, under This Workbook, click upload beside the sheet or table you want to upload to the cloud.

   

2. Under Data to Connect, keep your existing data selection, switch sheets, or choose a specific range within a sheet.

   Note

   To upload a specific range, you must highlight the range prior to completing this step.

3. Under Project, select an existing project or create a new one to house your dataset.

4. Under Dataset Title, provide a title for your dataset.

5. Complete the upload by clicking Connect to Cloud.

From either the All or Connections tab, you can now see the established connection between your sheet or table and the newly created dataset.

When you make changes to the sheet or table, re-upload your sheet or table to update the dataset stored in the cloud.

Downloading data

If another user shares a project with you, or you’re working in a separate workbook from where you uploaded a dataset, that dataset appears with an accompanying download icon.

Click download beside the dataset you want to download. Under Workbook Placement, select the sheet where you want to insert the data. Complete the download by clicking Connect to Workbook.

Understanding status icons

Status icons appear by each dataset. Click the icons to perform the following functions:

Icon	Name	Function
	Upload	Click to upload a dataset in your workbook to Anaconda Cloud.
	Re-upload	Click to re-upload the dataset in your workbook to Anaconda Cloud.
	Download	Click to download a dataset from Anaconda Cloud to your workbook.
	Re-download	The dataset on Anaconda Cloud has been updated. Click to update the dataset in your Excel workbook with these changes.
	Synced	The dataset in your Excel workbook is up-to-date with the dataset in Anaconda Cloud.
	Conflict	The dataset on Anaconda Cloud has been updated and now conflicts with the dataset in your Excel Workbook. Click to resolve the conflict.