Databricks

Dale_Ware · 03-14-2023

I am trying to query a snowflake table from a databricks data frame similar to the following example.sql_query = "select * from Database.Schema.Table_/Name_/V"sqlContext.sql(f"{sql_query}" ) And I get an error like this.ParseException: [PARSE_SYNTAX_...

Dale_Ware · 03-15-2023

Your answer was close but still had the error. This is what we found to work in our snowflake query from a data bricks data frame:.option("query", "select * from Database.schema.\"Table_/Name_/V\"") \This was because the query was already inside quot...

Databricks

User Stats

User Activity

How to query a table with backslashes in the name.

Re: How to query a table with backslashes in the name.