Does Sigma support Snowflake views?

klch · November 17, 2023, 5:48pm

I have created a view in snowflake. When I try to access it in Sigma, it is not visiable there.
However when I create a table in snowflake under the same schema, it does show up in Sigma and I can use it.
My question is, does Sigma support views created in Snowflake?

Brett · November 17, 2023, 7:59pm

Thanks for writing in! We definitely support views. If its not showing up i would check what schema objects the role specified at the connection level has access to to confirm its got the grant for views in addition to tables.

Also, can you write customSQL in Sigma like
SELECT *
FROM db.schema.view
?
Here is a quick example of a view in Snowflake and in Sigma