Creating a new table
1
Open the Tables tab
In the Workshop, open the Tables tab and click Create Table.
2
Name the table
Enter a Name, for example
Customers. Names can be up to 56 characters and must be unique in the workspace.3
Choose the primary key
Primary keys are UUID (random) by default. Under Advanced, you can change this to an Auto-increment integer instead. This can’t be changed later.
4
Note the identifier
The Identifier is generated from the name. It is what you use in SQL and the API, and it never changes. You can find it in the table’s Settings tab, under General.
5
Create the table
Importing a table
Import a.csv or .xlsx file to create a new table or append rows to an existing one. Imports are all-or-nothing: if any value doesn’t match its column type, no rows are imported.
Column types are detected from the file. Afterwards, a column can switch between Text and Number if all its values fit. Files can’t be imported; upload them to a File column in the table instead.
How files are read
How files are read
- CSV: the Encoding (UTF-8 or Latin-1) and Delimiter (comma, semicolon or tab) are detected automatically, and you can change them.
- Excel: when the workbook has more than one visible sheet, pick one under Sheet. The first visible sheet is used by default.
- Header row: You can choose which row is read as the Header row; rows above it are skipped.
- Blank rows are skipped.
- Values are trimmed, and empty values are stored as empty (null).
Other ways to create a table
- Genie: ask Genie to create a table with the columns you describe. See Tables with Genie.
- Flow import: importing a flow that was exported with its dependencies creates the tables it uses. See Tables in Flows.
- SDK:
client.tables.create(...). See Tables in the SDK. - REST API: Create table and Import CSV.
Column types
Column types are set at creation or inferred on import, and can be changed later when the conversion is valid. Columns are managed in the table’s Settings tab. Tables can have columns of the following data types:
Reference columns can’t change type or have a default value.
Converting column types
Built-in columns
Every table has these columns. They are set automatically, and their names are reserved, so they can’t be used for your own columns.Default values for columns can be set only through the API, and only on Text, Number and Boolean columns.