topic Re: Can anyone let me know, Is there anyway In which we can access different workspace delta tables in a workspace where we run the pipelines using python... in Data Engineering

Can anyone let me know, Is there anyway In which we can access different workspace delta tables in a workspace where we run the pipelines using python...

Heman2 — Tue, 06 Dec 2022 11:51:15 GMT

Can anyone let me know, Is there anyway In which we can access different workspace delta tables in a workspace where we run the pipelines using python?

Re: Can anyone let me know, Is there anyway In which we can access different workspace delta tables in a workspace where we run the pipelines using python...

UmaMahesh1 — Tue, 06 Dec 2022 11:56:03 GMT

Are the other workspace delta table external tables or stored in dbfs itself ?

Re: Can anyone let me know, Is there anyway In which we can access different workspace delta tables in a workspace where we run the pipelines using python...

Ajay-Pandey — Tue, 06 Dec 2022 12:00:26 GMT

I think you can use the delta sharing option for the same or just mount the same storage to your workspace and try to access the hive table from the current workspace.

Re: Can anyone let me know, Is there anyway In which we can access different workspace delta tables in a workspace where we run the pipelines using python...

UmaMahesh1 — Tue, 06 Dec 2022 12:05:56 GMT

Exactly...If that's an external table, he can simply mount the storage in the workspace and proceed.

Re: Can anyone let me know, Is there anyway In which we can access different workspace delta tables in a workspace where we run the pipelines using python...

Hubert-Dudek — Tue, 06 Dec 2022 14:39:06 GMT

Yes mount of storage is the best option

Re: Can anyone let me know, Is there anyway In which we can access different workspace delta tables in a workspace where we run the pipelines using python...

Pat — Tue, 06 Dec 2022 22:48:44 GMT

Hi @Hemanth A ,

there are some details missing.

If you are using Unity Catalog then you can create a new workspace and attach it to the existing Unity Catalog so the data will be available in both workspaces (you have to grant access to the data itself), this is one of the many benefits of using UC.

You can also as was mentioned already create external tables to access the data.

if you are in a different region or databricks account or different cloud then you can also use delta sharing :).

thanks,

Pat.

Re: Can anyone let me know, Is there anyway In which we can access different workspace delta tables in a workspace where we run the pipelines using python...

Harish2122 — Sat, 10 Dec 2022 10:07:22 GMT

@Hemanth A

go to the workspace you want data from, in warehouse tab you will find connectivity in that copy host name, http path and generate token for it, by this credentials you can access the data of this workspace in any other workspace.