Is there any way to set variables to before executing snowflake statement
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-26-2021 10:00 AM
I would like to execute the 2 set variable statements before executing the select * from viewname. This view internally uses VAR1 and VAR2 variables.
set VAR1 = ‘ABC’;
set VAR2 = ‘XYZ’;
Select * from dbname.schemaname.viewname ;
Is there anyway to set variables before executing select statement
1 REPLY 1
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-27-2023 08:12 AM
Hi, have you found a way to do this and use this variable in execution
