You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
When I attempt to see if a table exists (inspection.has_table(table_name='x', schema='y'), I get an error saying that the catalog name
must be surrounded by back-quote.
Recreation Steps:
Build a sqlalchemy connection to databricks
Put sqlalchemy engine into a variable
Put inspection (sqlachemy.inspect) into a variable.
The engine will be an parameter for inspect (e.g. inspect = inspect(engine))
Attempt to use has table
inspect.has_table(table_name='y', schema='x')
Expected: You will get no error message
Actual: You get an error message:
[INVALID_IDENTIFIER] The identifier intelli-intelli-curvgh is invalid. Please, consider quoting it with back-quotes as intelli-intelli-curvgh.(line 1, pos 22)
This issue also happens when you try to show the table names in a schema.
inspect.get_table_names('<schema_name>')
Error Message:
[INVALID_IDENTIFIER] The identifier intelli-intelli-curvgh is invalid. Please, consider quoting it with back-quotes as intelli-intelli-curvgh.(line 1, pos 24)
== SQL ==
SHOW TABLES FROM intelli-intelli-curvgh.mortalitystudy_2020_deidentified
The update is the same. I'm re-implementing all of sqlalchemy for compatibility with sqla2. This will be captured in those changes. I haven't touched this specifically yet since we're overhauling everything. If you watch the PR's on this repository in the next few days you'll see it pop through. It won't be released until 3.0.0 later this month.
Issue:
When I attempt to see if a table exists (inspection.has_table(table_name='x', schema='y'), I get an error saying that the catalog name
must be surrounded by back-quote.
Recreation Steps:
The engine will be an parameter for inspect (e.g. inspect = inspect(engine))
inspect.has_table(table_name='y', schema='x')
Expected: You will get no error message
Actual: You get an error message:
[INVALID_IDENTIFIER] The identifier intelli-intelli-curvgh is invalid. Please, consider quoting it with back-quotes as
intelli-intelli-curvgh
.(line 1, pos 22)== SQL ==
DESCRIBE TABLE intelli-intelli-curvgh.dm2_mortality_in.diagnosis_pre
Environment Info:
OS Windows
Python = 3.10
Python Libraries:
databricks-sql-connector==2.9.3
sqlalchemy==1.4.49
The text was updated successfully, but these errors were encountered: