René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"allow read-only feature while using snowflake as (sql) registry host. ","articleBody":"**Is your feature request related to a problem? Please describe.**\r\nBased on the community user's  (Zvonimir Cikojevic) feedback, we want to create a read-only feature for snowflake user who only can do READ to the registry on snowflake. \r\n\r\nHi guys! I hope I’m in the right channel.\r\nI have Feast deployed on Snowflake and I’d like to limit the write access to the feature store.\r\nThe idea was to have a Snowflake role that only has Read privileges to the feature store schema (where the feast registry and our batch sources are deployed).\r\nHowever, when assuming this role and running\r\nstore = feast.FeatureStore()\r\nI get unauthorized error since the first SQL query Feast runs is CREATE TABLE IF NOT EXISTS DB.SCHEMA.DATA_SOURCES…\r\nDoes this mean that anyone who wishes to query the feature store has to have RW access?\r\nCan you help me understand the reasoning behind this or did I miss something?\r\nThanks!\r\n\r\nYes, Feast tries to create registry Snowflake tables if they don't exist. I've created the registry when I first ran feast apply. This block of code always executed https://github.com/feast-dev/feast/blob/9df2224283e04760116b61bed3c8bfa7f17cbf7e/sdk/python/feast/infra/registry/snowflake.py#L128\r\nwhen I run store = FeatureStore() .\r\nIn my case, this is unnecessary since I've (as a feature store admin) already created the registry.\r\nI'd like to enable users to just have the ability to query the feature store - and not give them the privileges to write to the feature store tables (if they're not developers/admins).\r\n\r\n**Describe the solution you'd like**\r\n(TBD)\r\n\r\n**Describe alternatives you've considered**\r\n(TBD)\r\n\r\n**Additional context**\r\n(TBD)\r\n","author":{"url":"https://github.com/shuchu","@type":"Person","name":"shuchu"},"datePublished":"2023-11-27T01:53:46.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":1},"url":"https://github.com/3844/feast/issues/3844"}