Search…
Snowflake

Description

Snowflake data sources allow for the retrieval of historical feature values from Snowflake for building training datasets as well as materializing features into an online store.
  • Either a table reference or a SQL query can be provided.

Examples

Using a table reference
1
from feast import SnowflakeSource
2
3
my_snowflake_source = SnowflakeSource(
4
database="FEAST",
5
schema="PUBLIC",
6
table="FEATURE_TABLE",
7
)
Copied!
Using a query
1
from feast import SnowflakeSource
2
3
my_snowflake_source = SnowflakeSource(
4
query="""
5
SELECT
6
timestamp_column AS "ts",
7
"created",
8
"f1",
9
"f2"
10
FROM
11
`FEAST.PUBLIC.FEATURE_TABLE`
12
""",
13
)
Copied!
One thing to remember is how Snowflake handles table and column name conventions. You can read more about quote identifiers here
Configuration options are available here.
Last modified 7d ago
Export as PDF
Copy link
Edit on GitHub