Re: SQL compilation error while connecting to snow...

Kaviprakash_S · ‎06-09-2024

Hi All,

I'm trying to connect to the snowflake database from databricks notebook either to read the data or write the data. However I'm getting an weird error. The code and error are provided as follows,

snowflake_table = (spark.read

.format("snowflake")

.option("host", "******.east-us-2.azure.snowflakecomputing.com")

.option("user", "******")

.option("password", "*********")

.option("sfWarehouse", "Compute_WH")

.option("database", "SalesDevDB")

.option("schema", "gold") # Optional - will use default schema "public" if not specified.

.option("dbtable", "test")

.load()

)

Error:

net.snowflake.client.jdbc.SnowflakeSQLException: SQL compilation error:

brickster_2018 · ‎06-10-2024

Can you try the below code snippet? And share the stacktrace if the issue persists.

snowflake_table = spark.read \
  .format("snowflake") \
  .option("host", "******.east-us-2.azure.snowflakecomputing.com") \
  .option("user", "******") \
  .option("password", "*********") \
  .option("sfWarehouse", "Compute_WH") \
  .option("database", "SalesDevDB") \
  .option("schema", "gold") \
  .option("dbtable", "test") \
  .load()

Kaviprakash_S · ‎06-10-2024

I don't think adding the "\" will work in this case. Infact its not required in this dataframe operation.

Kaviprakash_S · ‎06-11-2024

@Retired_mod Could you please help with this ?

SQL compilation error while connecting to snowflake from Databricks