If a specified target table does not exist, Flow infers the schema of each source and creates the target table.
Flow maps source data types to target table columns as follows. Flow supports only scalar data types.
Source Data Type | Target Data Type (Inferred) |
---|---|
BYTEINT | Same |
SMALLINT | |
INTEGER, INT | |
BIGINT | |
DOUBLE PRECISION, FLOAT, REAL | |
DECIMAL, DEC, NUMERIC | |
CHARACTER, CHAR | |
VARCHAR, CHARACTER VARYING | |
DATE | |
TIME | |
TIME WITH TIMEZONE | |
TIMESTAMP | |
TIMESTAMP WITH TIMEZONE | |
Other | VARCHAR |
You can override inferred types with Schema Hints.