René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Snowflake Registry does not work","articleBody":"## Expected Behavior \nwhen setting registry_type: snowflake.registry, i would expect it creates corresponding tables in specified snowflake database, and add defined entities / views etc. to the tables.\nhttps://docs.feast.dev/reference/registries/snowflake\nregistry:\n  registry_type: snowflake.registry\n  account: snowflake_deployment.us-east-1\n  user: user_login\n  password: user_password\n  role: SYSADMIN\n  warehouse: COMPUTE_WH\n  database: FEAST\n  schema: PUBLIC\n  cache_ttl_seconds: 60\n\n## Current Behavior\nwhen run feast apply, i get error as below when creating snowflake registry tables (all tables are created already though, seems like there is an extra ':' at the end of the provided .sql receipt for snowflake registry ):\n\u003e (test_feast) macuser@Mac test_feast % feast apply\n```\n/Users/macuser/miniconda3/envs/test_feast/lib/python3.10/site-packages/pydantic/_internal/_fields.py:198: UserWarning: Field name \"vector_enabled\" in \"SqliteOnlineStoreConfig\" shadows an attribute in parent \"VectorStoreConfig\"\n  warnings.warn(\n/Users/macuser/miniconda3/envs/test_feast/lib/python3.10/site-packages/pydantic/_internal/_fields.py:198: UserWarning: Field name \"vector_len\" in \"SqliteOnlineStoreConfig\" shadows an attribute in parent \"VectorStoreConfig\"\n  warnings.warn(\n/Users/macuser/Desktop/Pilot/test_feast/example_repo.py:27: DeprecationWarning: Entity value_type will be mandatory in the next release. Please specify a value_type for entity 'driver'.\n  driver = Entity(name=\"driver\", join_keys=[\"driver_id\"])\n**Traceback** (most recent call last):\n  File \"/Users/macuser/miniconda3/envs/test_feast/bin/feast\", line 8, in \u003cmodule\u003e\n    sys.exit(cli())\n  File \"/Users/macuser/miniconda3/envs/test_feast/lib/python3.10/site-packages/click/core.py\", line 1161, in __call__\n    return self.main(*args, **kwargs)\n  File \"/Users/macuser/miniconda3/envs/test_feast/lib/python3.10/site-packages/click/core.py\", line 1082, in main\n    rv = self.invoke(ctx)\n  File \"/Users/macuser/miniconda3/envs/test_feast/lib/python3.10/site-packages/click/core.py\", line 1697, in invoke\n    return _process_result(sub_ctx.command.invoke(sub_ctx))\n  File \"/Users/macuser/miniconda3/envs/test_feast/lib/python3.10/site-packages/click/core.py\", line 1443, in invoke\n    return ctx.invoke(self.callback, **ctx.params)\n  File \"/Users/macuser/miniconda3/envs/test_feast/lib/python3.10/site-packages/click/core.py\", line 788, in invoke\n    return __callback(*args, **kwargs)\n  File \"/Users/macuser/miniconda3/envs/test_feast/lib/python3.10/site-packages/click/decorators.py\", line 33, in new_func\n    return f(get_current_context(), *args, **kwargs)\n  File \"/Users/macuser/miniconda3/envs/test_feast/lib/python3.10/site-packages/feast/cli.py\", line 778, in apply_total_command\n    apply_total(repo_config, repo, skip_source_validation)\n  File \"/Users/macuser/miniconda3/envs/test_feast/lib/python3.10/site-packages/feast/repo_operations.py\", line 396, in apply_total\n    store, registry = _get_store_and_registry(repo_config)\n  File \"/Users/macuser/miniconda3/envs/test_feast/lib/python3.10/site-packages/feast/repo_operations.py\", line 274, in _get_store_and_registry\n    store = FeatureStore(config=repo_config)\n  File \"/Users/macuser/miniconda3/envs/test_feast/lib/python3.10/site-packages/feast/feature_store.py\", line 160, in __init__\n    self._registry = SnowflakeRegistry(\n  File \"/Users/macuser/miniconda3/envs/test_feast/lib/python3.10/site-packages/feast/infra/registry/snowflake.py\", line 146, in __init__\n    execute_snowflake_statement(conn, query)\n  File \"/Users/macuser/miniconda3/envs/test_feast/lib/python3.10/site-packages/feast/infra/utils/snowflake/snowflake_utils.py\", line 128, in execute_snowflake_statement\n    raise SnowflakeQueryUnknownError(query)\nfeast.errors.SnowflakeQueryUnknownError: Snowflake query failed: \n```\n\n## Steps to reproduce\n```\nconda create --name testenv\nconda install python==3.10\npip install 'feast[snowflake]'\nfeast init\ncd 'project_name'\nfeast apply\n```\n\n### Specifications\n- Version:\n```\nPython 3.10.16\nfeast                      0.47.0\n```\n- Platform:\ngot same issue on MacBook and windows.\n- Subsystem:\n\n## Possible Solution\nif i manually remove the ':' in feast lib in my local environment for file `feast/infra/utils/snowflake/registry/snowflake_table_creation.sql`, there will be a different error for `feast apply`:\n```\n  File \"/Users/macuser/miniconda3/envs/test_feast/lib/python3.10/site-packages/feast/infra/registry/snowflake.py\", line 176, in _sync_feast_metadata_to_projects_table\n    feast_metadata_projects.add(row[1][\"PROJECT_ID\"])\nAttributeError: 'list' object has no attribute 'add'\n```\nif i change line 166 and 167 in `infra.registry.snowflake.py`\ninto \n```\n    def _sync_feast_metadata_to_projects_table(self):\n        feast_metadata_projects: set = set()\n        projects_set: set = set()\n```\nit will give me a new error:\n```\nKeyError: 'project_proto'\n```\nif i change line 1360 in `infra.registry.snowflake.py` to `ProjectProto.FromString(row[1][\"PROJECT_PROTO\"])` instead of `ProjectProto.FromString(row[1][\"project_proto\"])` will get a different error\n`AttributeError: 'SnowflakeRegistry' object has no attribute '_refresh_lock'`\n\nThen i stop trying. \n\nAm i using the snowflake registry in the right way? and guidance is appreciated.","author":{"url":"https://github.com/qianyao11","@type":"Person","name":"qianyao11"},"datePublished":"2025-04-01T15:04:20.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":3},"url":"https://github.com/5204/feast/issues/5204"}