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

How to query a table with backslashes in the name.

Dale_Ware — Tue, 14 Mar 2023 18:31:35 GMT

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_ERROR] Syntax error at or near '/'(line 1, pos 36)

== SQL ==

select * from Database.Schema.Table_/Name_/V

------------------------------------^^^

Does anyone know how I can escape those / characters?

Aviral-Bhardwaj — Wed, 15 Mar 2023 04:20:17 GMT

You can use Double Quotes to get the plan. Using quotes it is important to write the table names in capital letters.

SELECT * FROM "/TABLE/NAME"

Dale_Ware — Wed, 15 Mar 2023 15:16:34 GMT

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 quotes.