Is there a way to set session context to the SQL code generated by Looker?

Hi there,

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]
FROM 
    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?

Thanks

Ashwita

0 2 180
2 REPLIES 2
Top Labels in this Space
Top Solution Authors