我想通过解析JSON_FILE列中的json字符串，从雪花中的json动态创建表

import json
import mysql.connector

# 解析JSON字符串
json_str = '{"table_name": "my_table", "columns": [{"name": "id", "type": "INT"}, {"name": "name", "type": "VARCHAR(255)"}]}'
data = json.loads(json_str)

# 连接到MySQL数据库
cnx = mysql.connector.connect(user='your_username', password='your_password', host='your_host', database='your_database')
cursor = cnx.cursor()

# 创建表
table_name = data['table_name']
create_table_query = f"CREATE TABLE {table_name} ("
for column in data['columns']:
    column_name = column['name']
    column_type = column['type']
    create_table_query += f"{column_name} {column_type}, "
create_table_query = create_table_query.rstrip(', ') + ")"
cursor.execute(create_table_query)

# 插入数据
insert_data_query = f"INSERT INTO {table_name} VALUES (1, 'John')"
cursor.execute(insert_data_query)

# 提交事务并关闭连接
cnx.commit()
cursor.close()
cnx.close()

{
  "table_name": "my_table",
  "columns": [
    {"name": "id", "type": "INT"},
    {"name": "name", "type": "VARCHAR(255)"}
  ]
}