Featureform supports Snowflake as an Offline Store.
Account Locator
rather than an account
and organization
to connect. Featureform provides a separate registration function to support these credentials.
terraforming-snowflake-external-volumes
for an example of creating an external volume backed by an AWS S3 bucket using Terraform.
Additionally, users may have to manually enable change tracking on source tables for incremental refreshes to work.
The name of the external volume, as well as a folder name in the bucket (i.e. base_location
), is required to instantiate ff.SnowflakeCatalog
. Currently, the only option for catalog is to use Snowflake as the Iceberg catalog.
Additionally, users can set “provider-level” values for target lag and refresh mode that will be used by all resources (i.e. SQL transformations, features, labels and training sets) unless otherwise specified at the resource level.
query_tag
at configuration ensures all queries issues by Featureform will have the value of query_tag
applied to them, which will be visible in the Snowflake UI.
snowflake_config.py
) again with different values. The following list of configurations fields are mutable:
description
username
password
role
warehouse
database
schema
session_params
ASOF JOIN
to combine feature values with their labels.