SnowflakeSource does not properly construct table query string
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
SnowflakeSourceby specifying theschemaandtable - Create a
FeatureViewandFeatureServiceusing aboveSnowflakeSource - Use
get_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
- Version: 0.37.1
- Platform: MacOS
- Subsystem: Sonoma 14.4.1
Possible Solution
I filed a PR here: #4131