Snowflake Reference
Reference material for Snowflake Publishing -- data type mappings and CLI arguments.
Data Type Mapping
LakeXpress maps source types to Snowflake types automatically.
PostgreSQL to Snowflake
| PostgreSQL Type | Snowflake Type |
|---|---|
INTEGER, INT4 | NUMBER(38,0) |
BIGINT, INT8 | NUMBER(38,0) |
SMALLINT, INT2 | NUMBER(38,0) |
NUMERIC(p,s) | NUMBER(p,s) |
REAL, FLOAT4 | FLOAT |
DOUBLE PRECISION | DOUBLE |
VARCHAR(n) | VARCHAR(n) |
TEXT | VARCHAR(16777216) |
DATE | DATE |
TIMESTAMP | TIMESTAMP_NTZ |
BOOLEAN | BOOLEAN |
JSON, JSONB | VARIANT |
SQL Server to Snowflake
| SQL Server Type | Snowflake Type |
|---|---|
INT | NUMBER(38,0) |
BIGINT | NUMBER(38,0) |
DECIMAL(p,s) | NUMBER(p,s) |
FLOAT | DOUBLE |
NVARCHAR(n) | VARCHAR(n) |
VARCHAR(MAX) | VARCHAR(16777216) |
DATE | DATE |
DATETIME, DATETIME2 | TIMESTAMP_NTZ |
BIT | BOOLEAN |
CLI Reference
Snowflake Publishing Arguments
| Option | Type | Description |
|---|---|---|
--publish_target ID | String | Credential ID for Snowflake publishing |
--publish_schema_pattern PATTERN | String | Schema naming pattern (default: EXT_{schema} for external, {schema} for internal) |
--publish_table_pattern PATTERN | String | Table naming pattern (default: {table}) |
--snowflake_table_type TYPE | Enum | external or internal (default: external) |
--snowflake_no_views | Flag | Skip view creation (external tables only) |
--snowflake_view_prefix PREFIX | String | View name prefix (default: V_) |
--snowflake_pk_constraints | Flag | Add PRIMARY KEY constraints (internal tables only) |
Deprecated Arguments
| Old Argument | New Argument | Notes |
|---|---|---|
--publish | --publish_target | Removed in v0.1.12+ |
See Also
- Snowflake Publishing - Setup and usage guide
- CLI Reference - All command-line options