topic Re: Issue Adding Foreign Catalog Tables to Data Clean Room in Data Governance

Issue Adding Foreign Catalog Tables to Data Clean Room

RohithChippa — Tue, 03 Dec 2024 23:09:05 GMT

Hi,
I tried testing by adding a Snowflake table through Databricks foreign catalog into a Data Clean Room. I was able to:

Establish the connection.
Query the data in Databricks successfully.

However, I was unable to see the catalog when trying to add data assets in the Data Clean Room.

I also granted all privilege permissions for the catalog.

Am I missing something here? Any help would be greatly appreciated!

Re: Issue Adding Foreign Catalog Tables to Data Clean Room

MuthuLakshmi — Mon, 09 Dec 2024 10:04:40 GMT

@RohithChippa
Please check if you have the requirements to use clean room.
To be eligible to use clean rooms, you must:

Have an account that is enabled for serverless compute. See Enable serverless compute.
Have a workspace that is enabled for Unity Catalog. See Enable a workspace for Unity Catalog.

https://docs.databricks.com/en/clean-rooms/index.html

Re: Issue Adding Foreign Catalog Tables to Data Clean Room

RohithChippa — Mon, 16 Dec 2024 18:51:16 GMT

I am using the cleanroom I was able to run the notebook with added databricks delta tables from both collaborators, but when i want to add foreign catalog table, the catalog is not showing in add data assets in cleanroom.