Forum Discussion
Advocate IParameterising KQL connection in Fabric data pipeline
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
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.
1 Reply
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.