Does snowflake perform predicate pushdown when the clause is on a column from another table?

Viewed 33

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?

0 Answers
Related