Synapse tables are used to organize web-accessible, sharable, and queryable data. Tables may be queried and edited with the Synapse web clientUI, as well as with the Synapse programmatic clients. This article guides you through the process of creating a table in Synapse.
For information about how to query a table, see Searching Querying Tables, Views, and ViewsDatasets.
To learn more about creating tables and creating queries using one of the Synapse programmatic clients, see:
Tables in Python Docs
Tables in R Docs
...
Creating a New Table From a File
Tables require structured data contained in a .csv
or .tsv
file. If your structured data is saved in an Excel format such as .xls
or .xlsx
, you must “save-as” to convert the file to a .csv
before you proceed in Synapse. Navigate to the Tables tab in your project and select Upload a Table. If you provide a .csv
or .tsv
file, Synapse will infer your table schema based on the column headers. You may further customize the schema by selecting Schema Options.
For very large files, it may take time for the table to be built and indexed completely before it can be viewed. You may navigate away from the table once you have clicked Create, and you will not lose any data.
...
Creating an Empty Table
You have the option to create an empty table by clicking on the Tables Tools menu and Add Table. To build a new table, you must specify the table structure, column by column. Select Add Column to specify each column’s properties.
...
Click the + sign to add rows. To delete rows, check the boxes of the rows and click the Trash Can icon.
...
Modifying a Table Schema
Select Table Tools, Show Table Schema, and then select the Edit Schema button to modify the existing table structure. From Edit Schema, you can delete columns, add new columns, and modify existing columns.
...
Searching a Table
You can search for data within a table in two ways. The default search is a simple search menu to the left of your table. Use the facets to filter your dataset and narrow down your search. Table data can also be retrieved by using a SQL-like query language either through the web portal or through the analytical clients. See Searching Tables and Views
See Querying Tables, Views, and Datasets for more information.
...
Deleting a Table
To delete the entire table, click on the Table Tools menu and then select Delete Table. If you do not see this option, you do not have permission to delete the table. Contact an administrator for the project to get permission.
Learn more about permissions on the at Sharing Settings and Permissions page, Permissions, and Conditions for Use.
...
Adding Files to a Table
In addition to structured data, you can also add individual files to a table in Synapse. In the example below, this feature is used to add image files to a table containing histology data.
...
You can create a version history for any table in Synapse. Versioning helps you keep a record of what changes you made to the table and when you made them.
For more information on versioning a table, see the Versioning tables and views page.
Related Articles
Annotations and Queries, Downloading Data, Versioning Tables and ViewsVersioning Tables, Views, and Datasets.