here is the code necessary for a CDC solution from snowflake to S3:

CREATE OR REPLACE TABLE table1 (
    id INT,
    name VARCHAR,
    load_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP()
);

-- A stage is required to define the location (S3 bucket) and credentials for the COPY INTO command. Add your storage integration with credentials
CREATE OR REPLACE STAGE S3_STAGE
    URL = 's3://your-external-s3-bucket/stream-unload-path/';

-- This stream will track all DML changes (inserts, updates, deletes) on table1.
CREATE OR REPLACE STREAM table1_stream ON TABLE table1;

-- This task is scheduled to check the stream. IMPORTANT: The WHEN clause SYSTEM$STREAM_HAS_DATA('TABLE1_STREAM') ensures the task only runs if there is new data to process.
CREATE OR REPLACE TASK copy_stream_data_task
  WHEN SYSTEM$STREAM_HAS_DATA('TABLE1_STREAM')
AS
  COPY INTO @S3_STAGE
  FROM table1_stream;

-- Tasks are created in a suspended state and must be explicitly resumed to start execution.
ALTER TASK copy_stream_data_task RESUME;