Insert into snowflake table from snowflake stream

Question

I have a table in snowflake Table1 and I created a stream on Table2. Now I want to check that if there is data in stream based on changes in Table2, then I want to insert the data from the stream into Table1.

How can I insert data into table1 from the stream? Is there a way to check the data in the stream apart from desc stream? I want to see the raw data in stream

Answer 1

You can directly refer the stream as regular table using query like:

Select * from <stream name>;

To insert data from stream into Table1

Insert into table1 select * from <Stream name>;