Snowflake

Snowflake is a modern, efficient, scalable and easy to use cloud data warehouse. Snowflake is provided as a SaaS solution and enables fast and easy to use data storage, processing, and analytic solution.

Snowflake is built on custom SQL query engine and its architecture is built natively for the cloud.

Omni Loader

We support Snowflake directly. No additional drivers are required.

Snowflake data types we support

Integral

bigint, int (integer), smallint

Decimal

decimal (number, numeric), double (real, double precision, float, float4, float8)

Text

char (character), varchar (string, text)

Binary

binary (varbinary)

Date/Time

date, time, timestamp (datetime, timestamp_ltz, timestamp_ntz, timestampntz, timestamp without time zone, timestampltz, timestamp with local time zone), timestamp_with_tz (timestamp with time zone)

Large objects

geography

Other

array, boolean, variant