如何根据从API推断出的字段类型自动创建SnowFlake表？(Python)

import snowflake.connector

# 获取API返回的字段元数据信息
api_response = {
    "fields": [
        {"name": "id", "type": "int"},
        {"name": "name", "type": "string"},
        {"name": "age", "type": "int"},
        {"name": "email", "type": "string"}
    ]
}

# SnowFlake数据库连接配置
conn_config = {
    "user": "your_username",
    "password": "your_password",
    "account": "your_account",
    "warehouse": "your_warehouse",
    "database": "your_database",
    "schema": "your_schema"
}

# 创建SnowFlake表
def create_snowflake_table(api_response):
    # 连接到SnowFlake数据库
    conn = snowflake.connector.connect(**conn_config)
    cursor = conn.cursor()

    # 创建表的SQL语句
    create_table_sql = "CREATE TABLE your_table ("

    # 遍历字段元数据信息，构建创建表的SQL语句
    for field in api_response["fields"]:
        field_name = field["name"]
        field_type = field["type"]

        # 根据字段类型确定SnowFlake表中对应字段的数据类型
        if field_type == "int":
            create_table_sql += f"{field_name} INTEGER,"
        elif field_type == "string":
            create_table_sql += f"{field_name} VARCHAR(255),"

    # 去除最后一个逗号
    create_table_sql = create_table_sql.rstrip(",") + ")"

    # 执行创建表的SQL语句
    cursor.execute(create_table_sql)

    # 关闭连接
    cursor.close()
    conn.close()

# 调用函数创建SnowFlake表
create_snowflake_table(api_response)