Using Databricks SQL editor, when running a single query such as `use schema {schema_name}`, the selected schema in the UI is not updated. Then any su...

[kietay]

Using Databricks SQL editor, when running a single query such as `use schema {schema_name}`, the selected schema in the UI is not updated. Then any subsequent queries will use the UI schema. Leads to very confusing behaviour where you can run:

```

use schema x;

create table y (col_name type)

```

and table y gets created in `default` schema (if that is the schema selected in the UI)

[Kaniz]

Hi @Kieran Taylor​, Which DBR version are you using?

This applies to Databricks Runtime 10.2 and above.

[kietay]

Hey Kaniz, IIUC Databricks SQL endpoints don't have a specific DBR right?
Kieran Taylor
Senior Software Engineer, Data Platform