

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
FORCE = TRUE;
Python


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
Login to add comment