Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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. For information about searching a Table, see Search Tables and Views.

You can define Table columns to contain common data types like text, numbers, and dates, or you can define columns to include references to other Synapse objects, like Files and Folders.

To learn more about creating Tables and creating queries using one of the Synapse programmatic clients, see:

...

A schema is the structure of your dataset. In a Table, a schema defines the structure by specifying the column names, types, and sizes. A schema may also define the values or types of data allowed in each column.

You can define Table columns to contain common data types like text, numbers, and dates, or you can define columns to include references to other Synapse objects, like Files and Folders. Synapse currently supports several kinds of text columns (STRING, LARGE TEXT), dates (as TIMESTAMP), a variety of numeric columns (INTEGER, DOUBLE), and various Synapse identifiers (ENTITYID, USER). For a complete list of column types and definitions, please see the REST docs on columnTypes.

...