Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-14-2023 11:31 AM
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?
Labels:
- Labels:
-
Dataframe
-
Query Table