Creating a New Data Asset
The process of creating new Data Assets is different depending upon the type of Data Asset being created.
Was this helpful?
The process of creating new Data Assets is different depending upon the type of Data Asset being created.
Was this helpful?
You can add a new Data Asset from the My Data page or from a Capsule/Pipeline:
Navigate to the My DataDashboard.
Click + New Data to select a source.
After clicking a source, an interactive form will appear.
Click +New Data.
Choose Local Files.
Drag & drop the file or folders you want to upload from your local drive or click Choose Files to browse.
Complete the fields:
Source Data Name (required) — Use a meaningful name so that others can find the Data Asset easily.
Folder Name (required) — The folder name inside a Capsule. Use a name that’s similar to the dataset name. Spaces and some special characters are not allowed here.
Description (optional) — Add markdown supported text to make the Data Asset easy to find and understand.
Tags (required) — Tags are another way to help people find your Data Asset.
Custom Metadata — These are administrator-defined fields for which you can provide values.
Click Create Source Data to finish.
Click + New Data.
Choose AWS S3 or Google Cloud and then click Next.
Provide information about the bucket you want to use.
You can upload the entire bucket or a specific folder.
Complete the fields:
Source Data Name (required) — Use a meaningful name so that others can find the Data Asset easily.
Folder Name (required) — The folder name inside a Capsule. Use a name that’s similar to the dataset name. Spaces and some special characters are not allowed here.
Description (optional) — Add markdown supported text to make the Data Asset easy to find and understand.
Tags (required) — Tags are another way to help collaborators find your dataset.
Custom Metadata — These are administrator-defined fields for which you can provide values.
Click Create Source Data to finish.
In addition to importing from AWS S3 and Google Cloud buckets, data can be imported from a variety of other external sources using the Data Connectors accessible via the "New Data" menu. These allow you to submit a query to the specified data source and automatically save the results as an Internal Data Asset. Details regarding using each of these Data Connectors are below.
Provide the required information and add any optional tags, custom metadata, etc. Below is an explanation of the required information specific to the AWS Athena Data Connector.
Query: This is the query that will run in AWS Athena to fetch your data. It's the results of this query which will be saved as a file in your new Data Asset.
Temporary S3 Bucket: AWS Athena requires an S3 Bucket to output the initial query results (referred to as OutputLocation in the Athena SDK).
File Name: The name you'd like to give the query output in your new Data Asset.
File Type: Select the file type for the output of the query.
Select Secret: This is the secret which will be used to access Athena and the temporary S3 output bucket.
Click + New Data.
Click AWS S3 and then click Next.
Specify the Bucket Name and the Folder Name.
Select Link to S3 Bucket.
You can upload the entire bucket or a specific folder.
Complete the fields:
Source Data Name (required)—Use a meaningful name so that others can find the dataset easily.
Folder Name (required)—The folder name inside a Capsule. Use a name that’s similar to the dataset name. Spaces and some special characters are not allowed here.
Description (optional)—Add markdown supported text to make the Data Asset easy to find and understand.
Tags (required)—Tags are another way to help collaborators find your dataset.
Custom Metadata — These are administrator-defined fields for which you can provide values.
Click Create Source Data to finish.
External Data Assets are indexed upon creation and contents can be viewed in the Data Asset UI.
External Data Assets are available to be attached to a Capsule in a Cloud Workstation even if indexing has not fully completed.
To create a Data Asset from the /scratch folder in a Cloud Workstation:
From the dropdown list click Create New Data Asset.
2. Complete the fields:
Data Asset Name (required)—Use a meaningful name so that others can find the dataset easily.
Folder Name (required)—The folder name inside a Capsule. Use a name that’s similar to the dataset name. Spaces and some special characters are not allowed here.
Description (optional)—Add markdown supported text to make the Data Asset easy to find and understand.
Tags (required)—Tags are another way to help people find your dataset.
Custom Metadata — These are administrator-defined fields for which you can provide values.
To create a Combined Data Asset:
Click +New Data.
Choose Combined Data.
Check the box next to the External Data Assets you want to include in the Combined Data Asset.
Click Combine.
Complete the fields:
Combined Data Name (required) — Use a meaningful name so that others can find the Data Asset easily.
Folder Name (required) — The folder name inside a Capsule. Use a name that’s similar to the dataset name. Spaces and some special characters are not allowed here.
Description (optional) — Add markdown supported text to make the Data Asset easy to find and understand.
Tags (required) — Tags are another way to help people find your Data Asset.
Custom Metadata — These are administrator-defined fields for which you can provide values.
Click Combine to finish.
Once Created, you'll be able to see your Combined Data in the My Data Dashboard.
By default, a new Data Asset is private (i.e. only the owner can see it). To learn more about sharing a Data Asset with others, go to .
For AWS users, select Import from S3 Bucket. To add a remote Data Asset, read the next section: .
For Private Buckets, if the Secret or Role is already in your Code Ocean account, the system will automatically use it to access the bucket. If there is no Secret or Role that provides access, you will be prompted to create a user secret (see if you need help creating a secret).
Your SQL Warehouse's Workspace Hostname, Port, Endpoint HTTP Path can be found by navigating to your SQL Warehouse in Databricks and opening the Connection Details as explained in the Databricks Documentation . You can find the "Catalog" by navigating to the Data page in your Databricks account, finding the dataset you wish to query, and copying the Catalog name.
For Private Buckets, if the Secret or Role is already in your Code Ocean account, the system will automatically use it to access the bucket. If there is no Secret or Role that provides access, you will be prompted to create a user secret (see if you need help creating a secret).
To run a Pipeline with a Combined Data Asset, must be configured in your deployment by a Code Ocean admin.
