Forum Discussion
Script Component in Data Pipeline - Trying to Target a Lakehouse
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?
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.
6 Replies
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.
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.
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.
