Apache Spark to Snowflake Migration

SQLines provides tools to help you convert database schema (DDL), views, queries and SQL scripts from Apache Spark and Databricks SQL to Snowflake.

  • SQLines SQL Converter - SQL scripts assessment and conversion tool

Databases:

  • Apache Spark 3.x and 2.x
  • Snowflake any release

Migration Reference

Built-in SQL Functions

Converting datetime functions:

Spark Snowflake
1 FROM_UNIXTIME(epoch) Get the timestamp from epoch seconds TO_TIMESTAMP(epoch)

Converting data type casting functions:

Spark Snowflake
1 INT(exp) Convert to integer value CAST(exp AS INT)