Views with variable

Question

Raj0125 511

Hi,

I need create views with variable as below.

Create view view_name as

Select * from table where tas_id = V_Taskid

V_taskid is variable which are passing during run time from ADF pipeline

Is it possible to pass variable like above in view

Please suggest.

Thanks

Dillon Silzer 57,826 Reputation points Volunteer Moderator

2022-07-13T21:16:56.72+00:00

Where are you passing the variable to? Databricks? A function?
Raj0125 511 Reputation points

2022-07-14T00:14:03.173+00:00

I am passing from Azur data factory pipe line
Ronen Ariely 15,206 Reputation points

2022-07-14T00:32:13.363+00:00

Did you read my answer? Should I follow it or I am wasting my time and you do not read the answers?!?
Ronen Ariely 15,206 Reputation points

2022-07-14T08:31:18.66+00:00

Why did you deleted you last respond?!?

Fortunately as Moderator I can see the deleted messages...

You gave great new information

In fact, as I suspected and mentioned in the post this is a total new question now. With the new information it is clear that we had here an XY Problem as I wrote and now with the new information we can point to the right road...

Unfortunately you deleted the new information. Why?

Do you want me to restore it? do you want to add the information as respond to my answer? Do you want to close this thread?

Your original question was fully answered. In the post, I explain full why it is problematic to use variables in a few scenarios and a trick to use it anyway if you want

----------

Ronen Ariely
Personal Site | Blog | Facebook | Linkedin
Raj0125 511 Reputation points

2022-07-14T10:27:56.147+00:00

Pls restore it by mistake it's deleted

Thank you

2 answers

Dillon Silzer 57,826 Reputation points Volunteer Moderator

2022-07-13T21:16:56.72+00:00

Where are you passing the variable to? Databricks? A function?
Raj0125 511 Reputation points

2022-07-14T00:14:03.173+00:00

I am passing from Azur data factory pipe line
Ronen Ariely 15,206 Reputation points

2022-07-14T00:32:13.363+00:00

Did you read my answer? Should I follow it or I am wasting my time and you do not read the answers?!?
Ronen Ariely 15,206 Reputation points

2022-07-14T08:31:18.66+00:00

Why did you deleted you last respond?!?

Fortunately as Moderator I can see the deleted messages...

You gave great new information

In fact, as I suspected and mentioned in the post this is a total new question now. With the new information it is clear that we had here an XY Problem as I wrote and now with the new information we can point to the right road...

Unfortunately you deleted the new information. Why?

Do you want me to restore it? do you want to add the information as respond to my answer? Do you want to close this thread?

Your original question was fully answered. In the post, I explain full why it is problematic to use variables in a few scenarios and a trick to use it anyway if you want

----------

Ronen Ariely
Personal Site | Blog | Facebook | Linkedin
Raj0125 511 Reputation points

2022-07-14T10:27:56.147+00:00

Pls restore it by mistake it's deleted

Thank you

Answer 1

Ronen Ariely 15,206

Hi,

you can use a session Key/Value instead of variable for the task using the function SESSION_CONTEXT

For full explanation of the limitations and the solution you can check this post:

----------

Answer 2

Olaf Helper 47,436

I need create views with variable as below.

You can not use variables in a view, you have to use a stored procedure with a parameter (=variable) instead.