...
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
...
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.
Column Name | Choose a name for the column that will appear in the header. Column names must be 256 characters or less. There are three reserved words that cannot be used for Column Name: ROW_ID, ROW_VERSION, ROW_ETAG (case insensitive). |
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, 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 Bulk Edit Table Cell Values (pencil icon) to edit rows.
...