Skip to main content

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.

IMO this is wrong by nature, because it turns declarative query logic into procedural (by concatenating commands).

I'd recommend to remodel the view with (perhaps session) variable to UDTF that explicitly allows to specify parameter value declaratively
https://docs.snowflake.com/developer-guide/udf/sql/udf-sql-tabular-functions

Still, fixing value in SQL catalog item means you possibly have many of them and will need to create new over time - I consider it laborious at least.


As i mentioned it is a secure view. i dont have any control over it.


Reply