Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Jerome22
Advocate II
Advocate II

execute activities in another workspace?

Hi,

 

How can I execute activities like a stored procedure but where the warehouse is in another workspace than where my pipeline is stored?

 

I have a first workspace "Finance data" and a second one "Compliance data".

in the finance data workspace I have a pipeline in place to refresh some data, but I have to refresh data in my warehouse stored in the compliance data workspace.

I want to run a pipeline there or (at least) want to run stored procedures in the warehouse from this second workspace.

 

how can I do that?

3 REPLIES 3
Anonymous
Not applicable

Hi @Jerome22 ,

Thanks for using Fabric Community.
We don't have direct connection or way to do it. But we have a work around to achieve this goal.

Can you please check the below steps:

Open the Warehouse in another workspace and copy the SQL Connection String -

vgchennamsft_0-1714048513409.png


Add stored procedure and click external connection -

vgchennamsft_1-1714048635509.png


Please paste the SQL Connection String here ans Sign in to Organizational Account -

vgchennamsft_3-1714048776695.png


Please select the warehouse and stored procedure present in different workspace -

vgchennamsft_4-1714048827929.png


Hope this is helpful. Please let me know incase of further queries.

Anonymous
Not applicable

Hi @Jerome22 ,

We haven’t heard from you on the last response and was just checking back to see if your query was answered.
Otherwise, will respond back with the more details and we will try to help .

Thanks

Anonymous
Not applicable

Hi @Jerome22 ,

We haven’t heard from you on the last response and was just checking back to see if your query was answered.
Otherwise, will respond back with the more details and we will try to help .

Thanks

Helpful resources

Announcements
Sept Fabric Carousel

Fabric Monthly Update - September 2024

Check out the September 2024 Fabric update to learn about new features.

Expanding the Data Factory Forums

New forum boards available in Data Factory

Ask questions in Apache Airflow Job and Mirroring.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.