Not able to put parameter for Lakehouse in Fabric Pipeline

[YoussefBOUKARAM]

Details

I am using Azure Data Factory to configure a pipeline with a copy data step. When using automatically the lakehouse, it works fine. However, when I try to set a parameter in the pipeline to use in the lakehouse copy data step, it doesn't work. I am putting the correct name in the parameters value, but I am getting an error that says:

JavaScriptCopy

ErrorCode=AdlsGen2OperationFailed,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=ADLS Gen2 operation failed for: Operation returned an invalid status code 'BadRequest'. Account: ''. FileSystem: '3fb7192f-f276-49d1-a0c7-01047a2d313d'. Path: 'DemoAcquireEmployeeDataLakehouse/Tables/EmployeesWorldWide/_delta_log'. ErrorCode: 'BadRequest'. Message: 'Bad Request'. TimeStamp: 'Mon, 30 Oct 2023 10:21:56 GMT'..,Source=Microsoft.DataTransfer.ClientLibrary,''Type=Microsoft.Azure.Storage.Data.Models.ErrorSchemaException,Message=Operation returned an invalid status code 'BadRequest',Source=Microsoft.DataTransfer.ClientLibrary,'

How can I use a parameter for a lakehouse in a Fabric Pipeline without getting this error?

[YoussefBOUKARAM]

Hello Andy,

Thank you for the reply.

- I am using the  DAta Factory/ Data Pipelines with Fabric itself.

- All the other parameters in the pipeline are working fine, only the DataLake not working.

I was using the copy into the lakehouse,  using the following , it is working fine.

When I switch to use parameters, it is not working:

All the other parameters, are working fine even the EmployeesWorldWideTableName works, just the datalake. This is the name of myy datalake: DemoAcquireEmployeeDataLakehouse

[AndyDDC · Accepted solution]

You'll need to use the GUID of the Lakehouse instead of its name

You can get that from the URL when you browse the lakehouse itself 

[YoussefBOUKARAM]

Thank you Andy, it worked

[AndyDDC]

Hi, couple of questions:

• Are you using Data Factory/Data Pipelines within Fabric itself or the seperate Azure Data Factory service?
• How are you configuring the parameterized connection to the lakehouse, do you have screenshots?