Parameterising KQL connection in Fabric data pipeline

Question

Hi Fabricators,&nbsp;Has anyone tried to parameterise a KQL connection in&nbsp; 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 .&nbsp;I am able to parameterise the connection and workspaceid, but not the queryservice uri&nbsp;Any help is appreciated.&nbsp;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&nbsp;Thanks in advance for your help&nbsp;Cheers,AK

anonymous · Accepted Answer

Hi&nbsp;Amit_K&nbsp;,
From what I found, it seems that parameterizing the Query Service URI directly isn't supported yet.
&nbsp;
So now I think you can only use&nbsp;one single eventhouse with different lifecycle databases.&nbsp;
&nbsp;
You can also look at this document. It is the Configure KQL Database documentation:&nbsp;
Configure KQL Database in a copy activity - Microsoft Fabric | Microsoft Learn
&nbsp;
&nbsp;
Best Regards
Yilong Zhou
If this post&nbsp;helps, then please consider&nbsp;Accept it as the solution&nbsp;to help the other members find it more quickly.

Forum Discussion

Related content

Fabric Pipeline Parameterisation

Connection failed using a Folder connection in a pipeline

Parameterized connections in Data pipelines

Fabric Pipeline Error - Connection

Connect warehouse lakehouse to Fabric pipeline.