arrow-left

All pages
gitbookPowered by GitBook
1 of 1

Loading...

Snowflake

hashtag
Description

Snowflake data sources are Snowflake tables or views. These can be specified either by a table reference or a SQL query.

hashtag
Examples

Using a table reference:

Using a query:

circle-exclamation

Be careful about how Snowflake handles table and column name conventions. In particular, you can read more about quote identifiers .

The full set of configuration options is available .

hashtag
Supported Types

Snowflake data sources support all eight primitive types, but currently do not support array types. For a comparison against other batch data sources, please see .

herearrow-up-right
herearrow-up-right
here
from feast import SnowflakeSource

my_snowflake_source = SnowflakeSource(
    database="FEAST",
    schema="PUBLIC",
    table="FEATURE_TABLE",
)
from feast import SnowflakeSource

my_snowflake_source = SnowflakeSource(
    query="""
    SELECT
        timestamp_column AS "ts",
        "created",
        "f1",
        "f2"
    FROM
        `FEAST.PUBLIC.FEATURE_TABLE`
      """,
)