Executing a Copy command on snowflake from Qlik Automation

[NithinPannala]

Hi ,  

       I am trying to execute the following copy command from the Qlik automation and was able to execute it on snowflake successfully. it loads the json data from S3 on to snowflake. 

copy into Clinical_trail.CTD_STAGE.CTD_Complete(SRC) from
@CLINICAL_TRAIL.CTD_STAGE.MY_S3_STAGE
PATTERN = '.*json' ;

[Daniele_Purrone]

Hi @NithinPannala ,

I'm missing something here. Is it not working when run as an automation?

Thanks!

Daniele

[NithinPannala]

Hi @Daniele_Purrone ,

                                             I am just trying to find the block that can be used to execute the copy command. I have checked some of the blocks under snowflake connector but i couldn't find any.

[NithinPannala · Accepted solution]

Hi @Daniele_Purrone , 

                                             "Do Query " block worked for the copy command .When I tried before it didn't show any output and later figured out the blank message might be due to timeout on the webpage as it worked after refreshing the page.