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