Leaving this here as reference. I found using the combination of inline, arrays_zip and array allows you to insert into a temporary view.

create or replace temporary view TEMP_ITEM as select inline( arrays_zip( array(1,2,3), array('one','two','three') ) ) as (UPC_ID, UPC_VALUE);

That creates this table:

select * from TEMP_ITEM;

UPC_ID UPC_VALUE 1 one 2 two 3 three