snowflake - trigger/stream on the users view

Viewed 19

I would like to create a stream on the user view to catch the changes but I am getting error: Change tracking is not supported on queries with joins of type '[LEFT_OUTER_JOIN]'.

I need to implement such case: When a new user is created I want to create a schema in the database for that user.

Maybe you can suggest me some solution?

0 Answers
Related