Hi, I have a sql merge statement in an orchestration sql component. I wanted to know if there is a way I can get the specific query ID or session ID during the merge statement execution

Suhayr November 8, 2021, 1:30pm 1

There are other jobs running simultaneously and its quite hard to get the specific query id for that merge execution. I want to store the query id for later.

I'm new to matillion so any help would be appreciated.

Topic		Replies	Views
SQL Script component multiple statements session issue Matillion ETL	9	2	January 24, 2024
Is there any way I can get some information about an orchestration like when was it first created or who created it using API Matillion ETL	1	0	March 6, 2023
How to retrieve automatically the SQL from within a Matillion Orchestration and Transformation job? Matillion ETL	5	4	November 17, 2020
Is there a way to convert a Matillion trn job into plain SQL? so we could see the job like a stored proc Matillion ETL	7	1	March 2, 2023
Evaluating Job Name / Component Name at run time? Matillion ETL	2	2	June 9, 2021

Hi, I have a sql merge statement in an orchestration sql component. I wanted to know if there is a way I can get the specific query ID or session ID during the merge statement execution

Related topics