Hi @Ranga_naik1180,

There is no need to create an intermediate view in SQL. You can directly read the change data feed from silver into the gold table. You can use the code something like below:

CREATE STREAMING LIVE TABLE gold_table
AS SELECT * 
FROM table_changes('live.silver_table', 0); -- Reads change feed starting from version 0

Please let me know if this works for you.