Snowflake transformation while copying data from external stage to snowflake table

I'm trying to multiply accountid column with 10 while loading data from the external stage to the snowflake table.

Below is the query used in snowflake:

copy into account(accountid, accounttype)
from (select to_number(t.$1,10,1)*10, t.$4 from @azure_ext_stg/snowflake/account.csv t)
file_format = my_csv_format

Python 24-02-23, 1:02 p.m. samuel321
You make so many great points here that I read your article a couple of times. Your views are in accordance with my own for the most part. This is great content for your readers. internet security
27-02-23, 12:54 p.m. kacir28394

Log-in to answer to this question.