Snowflake has many advantages:
Please share your migration tips with us.
Unlike Redshift or MySQL, Snowflake is case sensitive. All unquoted table/column names are converted to upper case while quoted names keep their case.
So if you want to create the following table,
all of these commands will work
while this one will not:
Be especially careful when setting up input and output mappings. In the KBC UI, it is necessary to enter all table names using the exact casing because all table names referenced by mappings are automatically quoted by KBC.
When writing your transformation script, we recommend quoting all table names as well.
By default, Snowflake uses the
DY, DD MON YYYY HH24:MI:SS TZHTZM format
when converting the timestamp column to a character string.
This means that if you create a table in a transformation which uses a
the table value will come out as
Wed, 19 Oct 2016 01:24:21 -0700 in Storage. If you
want to output it in a different format, you have to cast the column to a string first, for example:
Do not use
ALTER SESSION queries to modify the default timestamp format, as the loading and unloading sessions are separate from your transformation/sandbox session and the format may change unexpectedly.
Important: Snowflake works with time zones (and Daylight Savings Time), requiring you to distinguish between various conversion functions: