Log in to AnswerLog in to Follow
2020-04-15 12-37-36
Daniel Kuhlmann
 
MVP
152Views
6Comments
Solved
[Snowflake Connector] Documentation
Question
Integration
Extension
Forge
snowflake-connector
Service icon
Snowflake Connector
Forge component by Rita Tomé

Hello Rita,

I try to use this extension you created. But due to the lack of any documenation I have hard time figuring out what I need to provide in the input parameters of the RunQuery action.

- Account

- Host

- Port

- ExtraParametersForConnectionString

Could you provide some additional information?

Regards,

Daniel

0
0
28 Sep 2020
2019-05-22 11-30-09
Marcelo Ferreira
 
MVP
Solution

Hi Daniel,

Did some tests with this component and I had to change it a bit. Changes I did in attachment.

Used this inputs

Regards,

Marcelo

See solution in context
SnowflakeConnector.oap
0
0
28 Sep 2020

Hi Daniel,

The inputs u refer beside host and account you should be able to leave all other empty Host you need to give the link that you use to access the snowflake database without the https://. Account use the beginning of the host till the first dot. something like this <account_name>.snowflakecomputing.com

Regards,

Marcelo

0
0
28 Sep 2020

Marcelo Ferreira wrote:

Hi Daniel,

The inputs u refer beside host and account you should be able to leave all other empty Host you need to give the link that you use to access the snowflake database without the https://. Account use the beginning of the host till the first dot. something like this <account_name>.snowflakecomputing.com

Regards,

Marcelo

 Hi Marcelo,

What ever I pass as parameters I get this an exception returning the text "value".

value
at Snowflake.Data.Client.SnowflakeDbConnection.Open()
   at OutSystems.NssSnowflakeConnector.CssSnowflakeConnector.MssRunQuery(String ssUsername, String ssPassword, String ssScheme, String ssAccount, String ssHost, String ssPort, String ssRole, String ssWarehouse, String ssExtraParametersForConnectionString, String ssQuery, Boolean& ssIsSuccessful, String& ssResultInJSON)

I created a free account and use the sample data database to test:

Did you ever used this component succesfully?

Regards,

Daniel

 

0
0
28 Sep 2020
2019-05-22 11-30-09
Marcelo Ferreira
 
MVP
Solution

Hi Daniel,

Did some tests with this component and I had to change it a bit. Changes I did in attachment.

Used this inputs

Regards,

Marcelo

SnowflakeConnector.oap
0
0
28 Sep 2020

Hi Marcelo,

Thanks, I did most of those changes you did, myself already, with the exception that I added DATABASE= instead of DB= for the database connection string parameter.

With the DATABASE= connection string parameter, I got the error message "Schema <schema name> not exists or not authorized"

Now that I use DB= i get only the error message "The connection has timed out", after a few seconds, although time out settings in snowflake are much higher.


Regards,

Daniel

0
0
29 Sep 2020

Daniël Kuhlmann wrote:

Hi Marcelo,

Thanks, I did most of those changes you did, myself already, with the exception that I added DATABASE= instead of DB= for the database connection string parameter.

With the DATABASE= connection string parameter, I got the error message "Schema <schema name> not exists or not authorized"

Now that I use DB= i get only the error message "The connection has timed out", after a few seconds, although time out settings in snowflake are much higher.


Regards,

Daniel

 UPDATE, it works now, had to increase timeout in app to be a bit bigger than 10 seconds, plus it turned out I have 4 big queries running in snowflake. When I cancelled those, my queries worked fast.

Regards,

Daniel

 

0
0
29 Sep 2020

Replying to Daniël Kuhlmann's comment on 29 Sep 2020 06:57:57

Hi Daniel,

I have similar timeout issue with Snowflake extension query run. Can you please guide me where did you increase the timeout in the app. I am unable to locate such settings in my App.

Regards,

Suman

0
0
19 Oct 2021
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.