Untitled

USE ROLE CUSTOM_ROLE1;
USE DATABASE "${SNOWFLAKE_DATABASE}";
USE SCHEMA "${SNOWFLAKE_SCHEMA}";

-- Utworzenie tabeli źródłowej i wypełnienie danymi
CREATE TABLE SOURCE (
    ID NUMBER,
    VAL VARCHAR
);
INSERT INTO SOURCE VALUES (1, 'A1_row1'), (2, 'A1_row2'), (3, 'A1_row3');

-- Generowanie 50 tabel z kopiowaniem danych
DO $$ 
DECLARE
    db STRING := '${SNOWFLAKE_DATABASE}';
    sc STRING := '${SNOWFLAKE_SCHEMA}';
    prev_table STRING := 'SOURCE';
    curr_table STRING;
BEGIN
    FOR i IN 1 TO 50 LOOP
        curr_table := db || '.' || sc || '.SEGMENT3_A' || i;
        EXECUTE IMMEDIATE '
            CREATE TABLE ' || curr_table || ' (
                ID NUMBER,
                VAL VARCHAR
            )';
        EXECUTE IMMEDIATE '
            INSERT INTO ' || curr_table || '
            SELECT ID, VAL
            FROM ' || prev_table || ';';
        prev_table := curr_table;
    END LOOP;
END $$;