// flatten関数を使用し、JSON文字列のkeyをカラムとして構造化 var sql_command4 = `create or replace table BIRD_DEMO.TO_TABLE.GET_OBJECT_REFERENCES_2 as select value:database_name::varchar AS DATABASE_NAME , value:schema_name::varchar AS SCHEMA_NAME , value:object_name::varchar AS OBJECT_NAME , value:referenced_database_name::varchar AS REFERENCED_DATABASE_NAME , value:referenced_schema_name::varchar AS REFERENCED_SCHEMA_NAME , value:referenced_object_name::varchar AS REFERENCED_OBJECT_NAME , value:referenced_object_type::varchar AS REFERENCED_OBJECT_TYPE from BIRD_DEMO.TO_TABLE.GET_OBJECT_REFERENCES_TEMP , lateral flatten ( input => REFERENCE)`; var stmt4 = snowflake.createStatement({sqlText : sql_command4}); var rs4 = stmt4.execute();