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.

Julian_Lee's avatar
Julian_Lee
Frequent Visitor
2 years ago

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's avatar
v-cboorla-msft
Icon for Microsoft Employee rankMicrosoft 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.