Synapse tables are used to organize web-accessible, sharable, and queryable data. Tables may be queried and edited with the Synapse web client, as well as with the Synapse programmatic clients. This article guides you through the process of creating a table in Synapse. For information about searching how to query a table, see Search Searching Tables and Views.
To learn more about creating tables and creating queries using one of the Synapse programmatic clients, see:
...
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 set the Column Name, Column Type, Size, Default Value, and Restrict Values. If specify each column’s properties.
Column Name | Choose a name for the column that will appear in the header. |
Column Type | Select the type of data that will be entered into this column. For detailed descriptions of each column type, see the REST docs. |
Size | For certain column types, such as String or Link, you must specify the maximum size of a single value. The default value is 50 characters, but you can limit the maximum size to be between 1 and 1000 characters. For column types that are lists (such as StringList or IntegerList), this number specifies the character maximum for all values in the column. |
Max List Length | For some list column types (such as StringList or IntegerList), you must specify a maximum list length. This number describes the maximum number of values that can appear in your list. For example, a Max List Length of 3 means that you may enter a list of up to three items. |
Default Value (optional) | Choose a default value to pre-populate in every new row of the column. Leave this field blank if you do not want to specify a default. |
Restrict Values (optional) | If you want to restrict the values for a particular column, enter the list of allowed values to create a dropdown menu. You can then select entries from this menu when adding table rows. Leave this field blank if you do not want to restrict the values. |
Facet | Select columns to be included in a faceted search to the left of your table. Choose Values to filter from a list of all possible entries for this column. Choose Range to filter with a slider, which is recommended for numeric values. Select a blank field to remove this column from the faceted search. |
After you create an empty table, you will need to click on select Table Tools and Upload Data to Table to upload data from a .csv or .tsv file. The first line of your file must match the table structure specified.
Alternatively, you may add rows and table data manually. To add, delete, or modify existing rows, click on the Edit Query Results (pencil icon) to edit rows.
...
Click the + sign to add rows. To delete rows, check the boxes of the rows and click the Trash Can icon.
...
Select Table Tools, Show Table Schema, and then select the Edit Schema to button to modify the existing table structure. From Edit Schema, you can delete columns, add new columns, and modify existing columns, define default column values, restrict column values, and add facet values.
Search 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 the Search tables Tables and viewsViews page for more information.
...
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. See Also:
Related Articles
Annotations and Queries, Downloading Data, Versioning Tables and Views
...