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
Hi Daniel,
Did some tests with this component and I had to change it a bit. Changes I did in attachment.
Used this inputs
Marcelo
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
Marcelo Ferreira wrote:
Hi Marcelo,
What ever I pass as parameters I get this an exception returning the text "value".
valueat 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?
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.
Daniël Kuhlmann wrote:
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.
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.
Suman