Python - Snowflake transformation while copying data from external stage to snowflake table

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 24-02-23, 1:02 p.m. samuel321

This question shows research effort; it is useful and clear

This question does not show any research effort; it is not useful and unclear

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.