Introduction

Welcome to Snowflake SnowConvert for Apache Hive. Let us be your guide on the road to a successful migration.

This is a deprecated version of the SnowConvert documentation, please visit the official site HERE.

What is SnowConvert for Apache Hive?

SnowConvert is a software that understands Apache Hive SQL and HPL/SQL Procedural Language, and performs the following conversions:

• Apache Hive SQL to Snowflake SQL

• HPL/SQL Procedural Language to Snowflake Scripting SQL.

SnowConvert for Apache Hive is still under a development phase and therefore, some functionality is still pending to be implemented.

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.

• HPL/SQL: Procedural Language for SQL. This is the language used in Apache Hive to define procedures.

• SnowConvert: the software that converts securely and automatically your Apache Hive files 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: parse or parsing is an initial process done by SnowConvert to understand the source code, and build up an internal data structure to process the conversion rules.

Let's dive into the code conversions that SnowConvert can perform.