databricks-cli icon indicating copy to clipboard operation
databricks-cli copied to clipboard
verified publisher icon databricks

Can't export .sql queries

Open jeisey opened this issue 2 years ago • 2 comments

Hello, I'm trying to migrate our workspace over to Unity and only PYTHON files seem to export when I use the workspace Export tool (I tried DBC, HTML, and ZIP). Then I tried databricks-cli connections to our workspace URL for the Data Science & Engineering and the SQL, yet both still do not display any .sql queries. I am using the current version of databricks-cli and the url-lib workaround shared in the recent issue here. Any help would be appreciated on how I can migrate the entire directory (including all SQL queries) over to Unity.

jeisey avatar May 05 '23 13:05 jeisey

The urllib issue you mention has been fixed in a new patch release we published just now (version 0.17.7).

As for your other comment; do you mean SQL notebooks? Queries in DBSQL are not represented as files in the workspace.

pietern avatar May 08 '23 12:05 pietern

Hi @pietern yes I'm referring to the SQL queries that users save in this SQL workspace (user would create this in SQL Editor and then Save.)

jeisey avatar May 08 '23 13:05 jeisey