I have a very large table in Snowflake (100b records) with columns
| eventDate | eventTypeId |
|---|---|
| 2021-01-05 | 3 |
| ... | ... |
I created a view by joining it with a small table (200 records) of the form
| eventTypeId | eventTypeName |
|---|---|
| 1 | 'pay' |
| 2 | 'cancel' |
| 3 | 'loggin' |
| ... | ... |
To create a table of the form:
| eventDate | eventTypeId | eventTypeName |
|---|---|---|
| 2021-01-05 | 3 | 'login' |
| ... | ... | ... |
And now I'm looking to query the view with
SELECT * FROM new_table WHERE eventTypeName = 'loggin'
However, I'm not seeing this predicate get pushed down to the original big table.
Does Snowflake support this?