When using partner connect to connect Serverless Databricks to my BI tool Preset, you must manually define the schema that Preset has access to. In my case, I individually selected all databases currently in my hive_metastore:
The problem is, once created, you don't have the option to add additional schema to this setup. If I create a new database that I want to connect, it looks like I have to delete the partner connect, re-add partner connect, then re-select all schema available. Partner connect does create a service principal called PRESET_USER that has a personal access token which links Preset to Databricks. In user management we can generate secrets and add permissions, but not explicitly add a new schema to its access. Looking at the serverless warehouse, there are also no explicit settings related to schema allowance. I also looked at the JDBC connection, including its connection arguments, but that does not explicitly define schema either.
The only other thought I had to update available schema is in Workspace Settings for SQL warehouses and serverless compute. There is an option for Data Security that allows us to enter key-value pairs for data access. These seem to be spark settings though and not schema settings.
Does anyone know if there is a way to update schema for this sql serverless warehouse connection?
