Automic and Snowflake Integration?

[Tony Ferraro]

Has anyone used Automic automation agents with a Snowflake DB?

We already use an Automic Oracle and SQL agent, i assume those wont work to run Snowsql against Snowflake.

Key Concepts & Architecture - Snowflake Documentation

I'll log a support ticket also, but let me know if you have experience.

Thanks Tony.

[Alexander Trenker]

Hi @Tony Ferraro, you can always use the generic connection string. You just need the Snowflake jdbc driver and create the connection string as documented:

https://docs.snowflake.com/en/user-guide/jdbc-configure.html​

Syntax

jdbc:snowflake://<account_name>.snowflakecomputing.com/?<connection_params>

Cheers,
Alexander

[Tony Ferraro]

Alexander thanks for the reply.

For more context, we want to have an Automic job connect to a snowflake DB and run some snowsql as we would using an oracle agent or mssql agent. But there is no specific Automic Snowflake agent.

I guess we might be able to install the snowCLI on a server with a uc4 agent to run snowSQL like via a unix job, unless there is another way.

Thanks.

[Alexander Trenker]

Hi Tony,

You can try the SQL connection object:


This might work with Snowflake.

[Alexander Trenker]

Also in the SQL agent ini you can specify GENERICJDBC

; type: Database type.
; MSSQL - Microsoft SQL Server
; ORACLE - Oracle
; DB2 - IBM DB2
; MYSQL - My SQL
; HANA - SAP HANA
; POSTGRESQL - PostgreSQL
; EXASOL - EXASOL
; GENERICJDBC - Generic JDBC Driver for any DB
;
type=GENERICJDBC

I tried this once with MariaDB which is also not listed and it worked.

[Tony Ferraro]

Great info Alexander thanks!
I'm testing it, i still need to get the Snowflakes JDBC driver installed though.

[Bruno Aeschbacher]

Hi Tony

We would also like to use an Automic automation agent with a Snowflake DB. Tony what can you tell us, were you successful with Alexander Trenker's proposal ?

[Tony Ferraro]

Hi,
We didn't complete this, sidetracked on other items alas.
If anyone got it to work would be good to know, including Broadcom!

[david She]

Tony: has any update with your exploration? 

We plan to move to snowflake and try to find out how to configure UC4 agent.

thanks
David