Hi In our DWH (an ASQL DB), we use a SP at the start of the ADF Pipeline to write some metadata about the Pipeline into an Audit log (table in DB). The following code is an excerpt of the code:
insert into logging.adf_run_log (master_pl_run_id, parent_pl_run_id, pl_run_id, execution_object, source_object, layer, status, start_time)
select ISNULL(@master_pl_run_id,cast('00000000-0000-0000-0000-000000000000' as uniqueidentifier))
, ISNULL(@parent_pl_run_id,cast('00000000-0000-0000-0000-000000000000' as uniqueidentifier))
, @execution_object, @source_object, @layer, 'RUNNING', getdate()
While the code works smoothly in the ASQL DB, we get an error message in Fabric. "OUTPUT is not supported. Msg 15868, level 16, state 11, code line 35 Each SQL statement is executed as an independent session. The session context is not maintained across SQL statements."