I need to set session context before the SQL code to be able to retrieve results from the DB.
sp_set_session_context N'AccountID', 1234;
SELECT TOP (500)
account_v2.AccountId AS [account_v2.account_id]
dbo.account AS account_v2
How can I achieve this in Looker?
So the session context must be set before the SQL code is run.
Can anyone help please?