Hive-Spark- Databricks SQL

Welcome to Snowflake SnowConvert for Hive, Spark - Databricks SQL. Let us be your guide on the road to a successful migration.

Important Notice: Migration of Documentation Website

Please be advised that our documentation website is currently undergoing a migration to a new platform. To ensure you have access to the most up-to-date information, we kindly request that you visit our new documentation website located at:

Official Snowflake Snowconvert Documentation

For any immediate assistance or if you encounter any issues, please contact our support team at [email protected].

Thank you for your understanding.

What is SnowConvert for Hive-Spark- Databricks SQL?

SnowConvert is a software that understands SQL scripts and converts this source code into functionally equivalent Snowflake code.

Conversion Types

Specifically, SnowConvert performs the following conversions:

Hive-Spark- Databricks SQL to Snowflake SQL

SnowConvert understands the Hive- Spark - Databricks SQL source code and converts the Data Definition Language (DDL), Data Manipulation Language (DML), and functions in the source code to the corresponding SQL in the target: Snowflake.

Sample code

Hive - Spark - Databricks SQL basic input code:

IN -> Databricks_01.sql

CREATE TABLE films (
    code        char(5) CONSTRAINT firstkey PRIMARY KEY,
    title       varchar(40) NOT NULL,
    did         integer NOT NULL,
    date_prod   date
);

Snowflake SQL output code:

OUT -> Databricks_01.sql

CREATE TABLE films (
    code        char(5) CONSTRAINT firstkey PRIMARY KEY,
    title       varchar(40) NOT NULL,
    did         integer NOT NULL,
    date_prod   date
)
COMMENT = '{ "origin": "sf_sc", "name": "snowconvert", "version": {  "major": 0,  "minor": 0,  "patch": "0" }, "attributes": {  "component": "databricks",  "convertedOn": "04/24/2025",  "domain": "test" }}';

As you can see, most of the structure remains the same. For example, some cases require the data types to be transformed.

SnowConvert Terminology

Before we get lost in the magic of these code conversions, here are a few terms/definitions so you know what we mean when we start dropping them all over the documentation:

• SQL (Structured Query Language): the standard language for storing, manipulating, and retrieving data in most modern database architectures.

• SnowConvert: the software that converts your PostgreSQL & based languages files securely and automatically to the Snowflake cloud data platform.

• Conversion rule or transformation rule: rules that allow SnowConvert to convert from a portion of source code to the expected target code.

• Parse: Parsing is an initial process by SnowConvert to understand the source code and build up an internal data structure required for executing the conversion rules.

On the following few pages, you'll learn more about the kind of conversions that SnowConvert for Hive -Spark - Databricks SQL is capable of. If you're ready, visit the Getting Started page in this documentation.