Column Types

Description

This section configures the SQL type syntaxes used in type-related queries, such as casting and table creation. For example, if the value for string is varchar(255), then we will use it to create the following queries:

• CAST(column AS VARCHAR(255)), or
• CREATE TABLE table (text_column VARCHAR(255))

Available types

1. integer

2. bigint

   bigint is required in cases where arithmetic overflow might happen. If your database does not have a native bigint type, you may use decimal or other double precision data type here.

3. **float **

   floating point number

4. fixed

   fixed point number, such as decimal or numeric with specified precision and scale. You may also add a specific precision and scale here directly, such as decimal(38,8)

5. string

   Ideally we expect a text type that does not require size. If your database does not have such a type, you may use VARCHAR(255) or even a larger size if your database stores large texts.

6. date

7. timestamp

8. time

9. geometry