Question: I need to order column like:

```
1 
2 
10 
100 
Ape
Cat
Elephant
Whatever

```

Can someone help me with this please?

Answer: 
Snowflake Kafka connector writes data as json by design. The default columns `RECORD_METADATA` and `RECORD_CONTENT` are variant. If you like to query them you can create a view on top the table to achieve your goal and you don't need a scheduled job

So, your table created by connector would be something like

```
RECORD_METADATA, RECORD_CONTENT

{metadata fields in json}, {"CUSTOMER_ID" : "test_id", "PURCHASE_ID" : "purchase_id_test"}

```

You can create a view to display your data

```
create view v1 as 
select RECORD_CONTENT:CUSTOMER_ID::text CUSTOMER_ID,
RECORD_CONTENT:PURCHASE_ID::text PURCHASE_ID

```

Your query will be

`select CUSTOMER_ID , PURCHASE_ID from v1`

PS. If you like to create your own tables you need to use `variant` as your data type instead of varchar
Also looks like it's not supported at this time in reference to [this github issue](https://github.com/snowflakedb/snowflake-kafka-connector/issues/179)