Learn how to generate a dedicated Workspace Data table to hold workspace-level resources.
Why use a Workspace Data table?
The Workspace Data table can hold variables and resources - like the genomic reference sequence file, or a Docker container - that stay the same regardless of the particular sample data analyzed. Keeping these workspace-level resources in one place can make your analysis more efficient.
Save time and reduce errors
The Workspace Data table lets you configure resource files once and point to them in the workflow configuration pane whenever you need them. Not only will you not need to look up reference file paths (URL), but if you update the resource files, you only need to update in one place.
Workspace Data table in Terra workspace
The Workspace Data table (above) includes reference files (URL under Values column) and a key. The files can be called in any workflow analysis, regardless of what data is analysed.
How to add a Workspace Data table
Follow the directions below to generate and add a Workspace Data table. Note that you can edit the table in Terra. To learn more, see How to edit and modify data tables.
Step 1: Create the TSV file
1.1. Download a template Workspace Data table here.
1.2. Open in your favorite spreadsheet editor.
1.3. Complete the top left column with the first reference file key after "workspace:".
1.4. Fill in the cloud location of the first reference file in the second row of the first column.
1.5. Fill in the key and cloud locations fields (in the header and 2nd row, respectively) for the rest of your workspace-level reference files.
Workspace Data TSV file in a spreadsheet
- Parts in red (i.e. "workspace:" must be typed exactly as shown.
- Customize the resource file key (header row) and full path (second row).
- Note that Terra will reorganize the files in alphabetical order.
Step 2: Save in tab separated values or tab delimited text format
Your editor may give you a warning, but we assure you, it's fine! Also, Terra will completely ignore the name you give the file. The "workspace:" formatting will tell Terra it is a Workspace data table.
A note about
.txt file extensions Depending on what spreadsheet editor you use, when you save in the proper format your spreadsheet may have either a ".tsv" or a ".txt" extension. Terra will accept either one.
Step 3. Upload the TSV file to your workspace
3.1. Click the Import Data button at the top left of the workspace data page.
3.2. Select Upload TSV and follow the directions.
The screenshot below is what you'll see when you upload the spreadsheet above to a Workspace Data table. The first column (the "key" - circled on the left) identifies what the file is. The other (circled on the right) includes a link to the cloud location of the file (for example, in a Google bucket):
Example: Workspace Data table in Terra
See these articles for more detailed information on different aspects of data tables.