Expected Behavior
If I pass schema="my_schema" and table="my_table" when creating a SnowflakeSource, I would expect that SnowflakeSource.get_table_query_string outputs '"my_schema"."my_table"'.
Current Behavior
Currently, SnowflakeSource.get_table_query_string outputs "my_table".
Steps to reproduce
- Create a
SnowflakeSource by specifying the schema and table
- Create a
FeatureView and FeatureService using above SnowflakeSource
- Use
get_historical_features and Snowflake will throw an error that it doesn't know the table if the schema in your offline store config is not the same as the schema of your table.
Specifications
- Version: 0.37.1
- Platform: MacOS
- Subsystem: Sonoma 14.4.1
Possible Solution
I filed a PR here: #4131
Expected Behavior
If I pass
schema="my_schema"andtable="my_table"when creating aSnowflakeSource, I would expect thatSnowflakeSource.get_table_query_stringoutputs'"my_schema"."my_table"'.Current Behavior
Currently,
SnowflakeSource.get_table_query_stringoutputs"my_table".Steps to reproduce
SnowflakeSourceby specifying theschemaandtableFeatureViewandFeatureServiceusing aboveSnowflakeSourceget_historical_featuresand Snowflake will throw an error that it doesn't know the table if theschemain your offline store config is not the same as the schema of your table.Specifications
Possible Solution
I filed a PR here: #4131