Snowflake

Description

The Snowflake offline store provides support for reading SnowflakeSources.

• Snowflake tables and views are allowed as sources.
• All joins happen within Snowflake.
• Entity dataframes can be provided as a SQL query or can be provided as a Pandas dataframe. Pandas dataframes will be uploaded to Snowflake in order to complete join operations.
• A SnowflakeRetrievalJob is returned when calling get_historical_features().

  • This allows you to call

    • to_snowflake to save the dataset into Snowflake
    • to_sql to get the SQL query that would execute on to_df
    • to_arrow_chunks to get the result in batches (Snowflake python connector docs)

Example

feature_store.yaml

project: my_feature_repo
registry: data/registry.db
provider: local
offline_store:
  type: snowflake.offline
  account: snowflake_deployment.us-east-1
  user: user_login
  password: user_password
  role: sysadmin
  warehouse: demo_wh
  database: FEAST

Configuration options are available in SnowflakeOfflineStoreConfig.