Forum Discussion

Julian_Lee's avatar
Julian_Lee
Frequent Visitor
2 years ago
Solved

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 lakehous...
pipelines
  • v-cboorla-msft's avatar
    v-cboorla-msft
    2 years ago

    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.

v-cboorla-msft's avatar
v-cboorla-msft
Microsoft Employee
2 years ago

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's avatar
Julian_Lee
Frequent Visitor
2 years ago

Hi v-cboorla-msft,

That's great. Nicely explained.

  • v-cboorla-msft's avatar
    v-cboorla-msft
    Microsoft Employee
    2 years ago

    Hi Julian_Lee 

     

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

     

    Thank you.