Josh Koppelman

UnauthorizedAccessException where connection worked previously

4

I have a very simple Sharepoint source connection that worked fine up until this morning. With no changes to the yaml, I am now getting: `Error: failed to sync v3...

dbsqlcli does not correctly handle fields that contain a newline in csv table format. `SELECT '\n' AS col1;` This query does not output any quotes at all.

Support for staging_allowed_local_path

1

In order to upload a local file to a Volume (via PUT) and access the associated data (via read_files), it is necessary to pass set staging_allowed_local_path when initiating sql.connect() https://docs.databricks.com/en/dev-tools/python-sql-connector.html

If you try to execute a sql script that ends with a comment, the confirm_destructive_query method (prompt_utils.py) calls queries_start_with, and query_starts_with throws an exception "list index out of range". It...

Support for Parameter Markers

1

It doesn't look like databricks-sql-cli supports passing [parameter markers](https://learn.microsoft.com/en-us/azure/databricks/sql/language-manual/sql-ref-parameter-marker), though the Databricks CLI supports them (example [here](https://docs.databricks.com/en/dev-tools/sql-execution-tutorial.html#step-1-execute-a-sql-statement-and-save-the-data-result-as-json)). Would you consider adding?

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