Snowflake object_construct unloading Key Order should be preserved as same. how to maintain the order not by alphabetical?

Question

I use copy command of snowflake which is below returns a file with content json

copy into @elasticsearch/product/sf_index from (select object_construct('id',id, alpha,'alpha')from table limit 1) file_format = (type = json, COMPRESSION=NONE), overwrite=TRUE, single = TRUE, max_file_size=5368709120;

the output in json file is

{ 
    "alpha":"alpha", 
    "id" :"1"
}

I want the order to be preserved here, not order by alphabetical ? like this

{
"id" :"1",
"alpha":"alpha",
}

any solutions?? Thanks in Advance

What is the need to have the attributes in any particular order? Similar to your earlier post, these seem like odd requirements for a JSON document. — Mike Walton, Aug 10 '20 at 21:42

score 0 · Answer 1 · answered Aug 10 '20 at 17:33

0

It can be preserved the order if you force the data to be sorted to achieve this create primary key constrain (link) on id column and define as INT.

While loading data cast the id column as int (links )

answered Aug 10 '20 at 17:33

sandeep rawat

4,797
1
18
36

This would force the order of the records, but not the order of the attributes, which was the OP's question. – Mike Walton Aug 10 '20 at 21:40

Snowflake object_construct unloading Key Order should be preserved as same. how to maintain the order not by alphabetical?

1 Answers1