...
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.
...