Parameterising KQL connection in Fabric data pipeline

[Amit_K]

Hi Fabricators,

Has anyone tried to parameterise a KQL connection in  a fabric pipeline.

I am using KQL databases for ETL logging and depending on my lifecycle, I want to be able to write to the corresponding workspace holding the eventhouse .

I am able to parameterise the connection and workspaceid, but not the queryservice uri

Any help is appreciated.

Alternatively, I can use one single eventhouse with different lifecycle databases, but that is not going to be great as the resources are set at the Eventhouse level and not at the database level

Thanks in advance for your help

Cheers,

AK

[Anonymous · Accepted solution]

Hi @Amit_K ,

From what I found, it seems that parameterizing the Query Service URI directly isn't supported yet.

So now I think you can only use one single eventhouse with different lifecycle databases. 

You can also look at this document. It is the Configure KQL Database documentation: 

Configure KQL Database in a copy activity - Microsoft Fabric | Microsoft Learn

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.