Ordinal of a new column in snowflake table
<p>I am trying to add a new column to an existing Table in snowflake, how to specify where to add the column. I tried the below query,</p>

<pre><code>ALTER TABLE MY_DB.MY_SCHEMA.MY_TABLE 
ADD COLUMN MY_NEW_COLUMN NUMBER(38,0) AFTER MY_OLD_COLUMN1;
</code></pre>

<p><code>AFTER</code> keyword doesn't works with Snowflake. Any suggestions on this would be helpful.</p>