尝试使用Snowflake sql将一列拆分为多列

-- 创建示例表
CREATE TABLE my_table (column1 VARCHAR);

-- 插入示例数据
INSERT INTO my_table VALUES ('1-2-3-4-5');

-- 使用SUBSTRING函数拆分列
SELECT SUBSTRING(column1, 1, 1) AS col1,
       SUBSTRING(column1, 3, 1) AS col2,
       SUBSTRING(column1, 5, 1) AS col3,
       SUBSTRING(column1, 7, 1) AS col4,
       SUBSTRING(column1, 9, 1) AS col5
FROM my_table;

-- 使用REGEXP_SUBSTR函数拆分列
SELECT REGEXP_SUBSTR(column1, '[^-]+', 1) AS col1,
       REGEXP_SUBSTR(column1, '[^-]+', 2) AS col2,
       REGEXP_SUBSTR(column1, '[^-]+', 3) AS col3,
       REGEXP_SUBSTR(column1, '[^-]+', 4) AS col4,
       REGEXP_SUBSTR(column1, '[^-]+', 5) AS col5
FROM my_table;