i need to read a snowflake view in ataccama either in one web or one desktop (preferably one web). but one problem here.
View name - employee_sal
in order to see the records in snowflake we have to use the below 2 commands
set start_date=’2025-04-01’;
select * from schema.employee_sal;
how can i use the set command in sql catalog . i tried with the same command above but it is showing error as $start_date as error.
Note : In snowflake it is view not a table . and the view is secure and we are not authorized for the definition of the view and also no access to the base tables. but we can access the view. In snowlfake itself in order to access the view we have to use set command . Solution for this is appreciated.