Patched code sample

import snowflake.connector
import pandas as pd
from snowflake.connector.pandas_tools import write_pandas
import re

def sanitize_table_name(name):
    if not re.fullmatch(r"[A-Za-z_][A-Za-z0-9_]*", name):
        raise ValueError("Invalid table name")
    return name.upper()

def write_to_snowflake(conn, table_name, df):
    sanitazed_table_name = sanitize_table_name(table_name)
    success, nchunks, nrows, _ = write_pandas(
        conn,
        df,
        sanitazed_table_name,
        auto_create_table=True,
        table_type=None,
        overwrite=False
    )

if __name__ == '__main__':
    conn = snowflake.connector.connect(
        user='your_user',
        password='your_password',
        account='your_account',
        warehouse='your_warehouse',
        database='your_database',
        schema='your_schema'
    )

    data = {'col1': [1, 2, 3], 'col2': ['a', 'b', 'c']}
    df = pd.DataFrame(data)

    table_name = "my_table; DROP TABLE my_table;"

    try:
        write_to_snowflake(conn, table_name, df)
    except Exception as e:
        print(f"Error writing to Snowflake: {e}")
    
    conn.close()