René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Use Snowflake connections.toml file","articleBody":"**Problem**\r\nWe would like to directly use the `connections.toml` file for the Snowflake connector for the Feast Snowflake integration. Setting a `connection_name` in the feature store configuration file would allow us to use the same connection configuration for the feature store that is also used in other python scripts that access Snowflake.\r\n\r\nCurrently, the feature store configuration gives the option to add a `config_path`. To my understanding, this file is a SnowSQL config file which is not directly compatible with the Python Snowflake connector that is used under the hood in Feast.\r\n\r\n**Proposed Solution**\r\nMy understanding is, that if the `connection_name` is passed to the `snowflake.connector` it will look for the default location of the file and load the configuration parameters for the defined connection. https://docs.snowflake.com/en/developer-guide/python-connector/python-connector-connect#connecting-using-the-connections-toml-file\r\n\r\nThus, adding a field with name `connection_name` in https://github.com/feast-dev/feast/blob/master/sdk/python/feast/infra/offline_stores/snowflake.py#L79 would work for the offline store. The other Snowflake resources need to be adjusted similarly.\r\n\r\nI would be open for a contribution.\r\n\r\n**Alternatives**\r\nA workaround where the connection is configured in an ini file that matches the config in the `connections.toml` file.","author":{"url":"https://github.com/nanohanno","@type":"Person","name":"nanohanno"},"datePublished":"2024-10-01T14:36:30.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":0},"url":"https://github.com/4592/feast/issues/4592"}