topic Re: Executing a Copy command on snowflake from Qlik Automation in Qlik Automate

Executing a Copy command on snowflake from Qlik Automation

NithinPannala — Mon, 10 Jul 2023 10:36:28 GMT

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' ;

Re: Executing a Copy command on snowflake from Qlik Automation

Daniele_Purrone — Mon, 10 Jul 2023 12:00:57 GMT

Hi @NithinPannala ,

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

Thanks!

Daniele

Re: Executing a Copy command on snowflake from Qlik Automation

NithinPannala — Mon, 10 Jul 2023 13:53:26 GMT

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.

Re: Executing a Copy command on snowflake from Qlik Automation

NithinPannala — Wed, 12 Jul 2023 06:57:08 GMT

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.