Dynamic pipelines to use across workspaces

Hi Matthew_G 
Thanks for using Fabric Community.
You need to select the "Add dynamic content" option within the drop down and pass in the GUID.

You need to create a new parameter for the stored procedure activity.
The parameter value should be Lakehouse/Data Warehouse/KQL Database object ID. To get your Lakehouse/Data Warehouse/KQL Database object ID, open your Lakehouse/Data Warehouse/KQL Database in your workspace, and the ID is after /lakehouses/or /datawarehouses/ or /databases/ in your URL.

Please refer to this link for more information: Link1
Hope this helps. Please let me know if you have any further questions.

Thanks, it looks a bit different for the Stored Procedure Activity.

When you add dynamic content to the Warehouse it then also requests a SQL connection string.

I then added two parameters, the connection string and the warehouse guid, adding it as dynamic content.

This now works.