SQL compilation error while connecting to snowflake from Databricks

[Kaviprakash_S]

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]

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]

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

[Kaviprakash_S]

@Kaniz Could you please help with this ?