Snowflake Streams


Snowflake currently does not support creation of STREAMs on VIEWs that include:

  1. GROUP BY clause
  2. PARTITION clause
  3. QUALIFY clause
  4. Queries with Window Functions
  5. Queries with LIMIT
  6. Queries with correlated subqueries
  7. Queries with subqueries in the WHERE clause

Change tracking is not supported on queries with QUALIFY
Change tracking is not supported on queries with window functions
Change tracking is not supported on queries with GROUP BY
Change tracking is not supported on queries with LIMIT
Change tracking is not supported on queries with subquery expressions