Snowpark Migration Accelerator: Plataformas suportadas¶

Dialetos SQL¶

O Snowpark Migration Accelerator (SMA) pode analisar arquivos de código para identificar elementos SQL. Atualmente, o SMA pode detectar o código SQL escrito nos seguintes formatos:

• Spark SQL

• Hive QL

• Databricks SQL

SQL Assessment and Conversion Guidelines¶

Embora o Spark SQL e o Snowflake SQL sejam altamente compatíveis, alguns códigos SQL podem não ser convertidos perfeitamente.

SQL analysis is only possible when the SQL is received in the following ways:

• A SQL cell within a supported notebook file

• A .sql or .hql file

• A complete string passed to a spark.sql statement.

  Some variable substitutions are not supported. Here are a few examples:

  • Parsed:

    CopyExpand

    spark.sql("select * from TableA")
    

    Show lessSee more

    Scroll to top

    New SMA scenarios supported include the following:

    CopyExpand

    # explicit concatenation
    spark.sql("select * from TableA" + ' where col1 = 1')
    
    # implicit concatenation (juxtaposition)
    spark.sql("select * from TableA" ' where col1 = 1')
    
    # var initialized with sql in previous lines before execution on same scope
    sql = "select * from TableA"
    spark.sql(sql)
    
    # f-string interpolation:
    spark.sql(f"select * from {varTableA}")
    
    # format kindof interpolation
    spark.sql("select * from {}".format(varTableA))
    
    # mix var with concat and f-string interpolation
    sql = f"select * from {varTableA} " + f'where {varCol1} = 1'
    spark.sql(sql)
    

    Show lessSee more

    Scroll to top

  • Not Parsed:

    CopyExpand

    some_variable = "TableA"
    spark.sql("select * from" + some_variable)
    

    Show lessSee more

    Scroll to top

  SQL elements are accounted for in the object inventories, and a readiness score is generated specifically for SQL.