[BUG]: Issue in Windows version with paths containing spaces and trailing backslash

[mattjslack]

Is there an existing issue for this?

• I have searched the existing issues

Category of Bug / Issue

Analyzer bug

Current Behavior

databricks labs lakebridge analyze --source-directory "C:\SQL2022\scripts 2\" --report-file "c:\sql2022\scripts 2\test.xlsx" 14:00:00 ERROR [src/databricks/labs/lakebridge.analyze] TypeError: analyze() missing 1 required positional argument: 'report_file'

With the trailing backslash, it returns the error about the missing report_file parameter.

Expected Behavior

It should work with the trailing backslash.

Steps To Reproduce

Put the source directory containing spaces in quotes, with a trailing backslash.

databricks labs lakebridge analyze --source-directory "C:\SQL2022\scripts 2" --report-file "c:\sql2022\scripts 2\test.xlsx"

Relevant log output or Exception details

14:00:00    ERROR [src/databricks/labs/lakebridge.analyze] TypeError: analyze() missing 1 required positional argument: 'report_file'`

Sample Query

Operating System

Windows

Version

latest via Databricks CLI