topic Re: Script Component in Data Pipeline - Trying to Target a Lakehouse in Pipelines

Script Component in Data Pipeline - Trying to Target a Lakehouse

Julian_Lee — Thu, 23 May 2024 10:08:19 GMT

Trying to add a script component to a pipeline. Can't see the connection to the lakehouse in the connection list (warehouse does appear). Should you be able to target a script component at a lakehouse or does this only work for warehouses?

Re: Script Component in Data Pipeline - Trying to Target a Lakehouse

Anonymous — Thu, 23 May 2024 10:50:44 GMT

Re: Script Component in Data Pipeline - Trying to Target a Lakehouse

v-cboorla-msft — Thu, 23 May 2024 13:35:36 GMT

Hi Julian_Lee

Thanks for using Microsoft Fabric Community.

Could you please share some additional information like sharing the screenshots of the issue that you are facing. This will help me to guide you in a better way.

Thank you.

Re: Script Component in Data Pipeline - Trying to Target a Lakehouse

Julian_Lee — Thu, 23 May 2024 14:39:23 GMT

Below is the Lakehouse setup within a Workspace: TDC - Bronze

I have created a pipeline with a script in it

In the Settings > Connection I expected to see the TDC_Bronze_Lakehouse but it doesn’t show up

But warehouses do.

Re: Script Component in Data Pipeline - Trying to Target a Lakehouse

v-cboorla-msft — Thu, 23 May 2024 16:23:19 GMT

Hi Julian_Lee

If you want to establish the connection for Lakehouse in Pipeline Script activity, please follow the below steps.

Click on the 3 dots and copy the SQL connection string.

Under Script activity select Azure SQL Database under Get data and paste the SQL connection string in server place and click connect.

You will be able to see the Lakehouse list.

I hope this information helps. Please do let us know if you have any futher queries.

Thank you.

Re: Script Component in Data Pipeline - Trying to Target a Lakehouse

Julian_Lee — Fri, 24 May 2024 08:31:55 GMT

Hi v-cboorla-msft,

That's great. Nicely explained.

Re: Script Component in Data Pipeline - Trying to Target a Lakehouse

v-cboorla-msft — Fri, 24 May 2024 15:50:42 GMT

Hi Julian_Lee

Glad that you query got resolved.
Please continue using Fabric Community for further queries.

Thank you.