Script Component in Data Pipeline - Trying to Target a Lakehouse

[Julian_Lee]

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?

[v-cboorla-msft]

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.

[Julian_Lee]

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.

[v-cboorla-msft · Accepted solution]

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.

[Julian_Lee]

Hi v-cboorla-msft,

That's great. Nicely explained.

[v-cboorla-msft]

Hi @Julian_Lee 

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

Thank you.

[Anonymous]

Could be similar to:
Solved: Can't delete files from Lakehouse using "Delete Da... - Microsoft Fabric Community