remorph_snowflake_to_databricks_sql_dialect_translation.py

1from remorph import Remorph
2from remorph.config import Config
3
4# Initialize the Remorph engine
5# By default, it uses the configuration provided in the library
6config = Config()
7remorph = Remorph(config)
8
9# Define a source SQL query (e.g., Snowflake dialect)
10snowflake_query = """
11SELECT 
12    id, 
13    TO_DATE('2023-01-01') as start_date,
14    IFF(status = 'active', 1, 0) as is_active
15FROM 
16    my_table
17"""
18
19# Translate the query to Databricks Spark SQL
20translated_query = remorph.translate(
21    sql=snowflake_query,
22    source_dialect="snowflake"
23)
24
25print("Translated Query:")
26print(translated_query)