databricks-sql-cli icon indicating copy to clipboard operation
databricks-sql-cli copied to clipboard

Database command line parameter does work with queries

Open jkoppelm opened this issue 1 year ago • 0 comments

The following command works:

python -m dbsqlcli.main -e "SELECT COUNT(*) FROM my_schema.my_database.my_table"

I would expect the following command to work similarly, but it does not:

python -m dbsqlcli.main -e "SELECT COUNT(*) FROM my_table" my_schema.my_database

The error is:

[TABLE_OR_VIEW_NOT_FOUND] The table or view `my_table` cannot be found. Verify the spelling and correctness of the schema and catalog.
If you did not qualify the name with a schema, verify the current_schema() output, or qualify the name with the correct schema and catalog.

jkoppelm avatar Dec 16 '24 00:12 jkoppelm