Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dec 4, 2024 8:31:52 AM
Nov 8, 2021 4:11:22 AM
This article overviews the available blocks in the Snowflake connector in Qlik Application Automation. It will also cover some basic examples of retrieving data from a Snowflake database and creating a record in a database.
The Snowflake connector has the following blocks:
To create a new connection to Snowflake, the following parameters are required:
Warning
Account names that include underscores can sometimes cause issues for certain features. For this reason, Snowflake also supports a version of the account name that substitutes the hyphen character (-
) in place of the underscore character. For example, both of the following URLs are supported:
URL with underscores:
https://acme-marketing_test_account.snowflakecomputing.com
URL with dashes:
https://acme-marketing-test-account.snowflakecomputing.com
More details about the account name can be found in the below Snowflake documentation
The Do Query block can be used to perform actions in Snowflake that aren't supported by the other blocks.
The information in this article is provided as-is and to be used at own discretion. Depending on tool(s) used, customization(s), and/or other factors ongoing support on the solution below may not be provided by Qlik Support.
Does the Snowflake connector in App Automation support other forms of authentication other than username and password? For example OAuth mechanism like we do for a data connection for Qlik app development? Thanks
Hello @estherl I believe only username and password are currently supported, but let me check in with our experts!
All the best,
Sonja
Hello @estherl
I can now confirm that only username and password are supported as of right now. However, expanding this is on our team's radar, though we do not currently have any guarantee on when that would be added.
All the best,
Sonja
Thanks @Sonja_Bauernfeind
Just in case this helps anyone else ... If your Snowflake URL happens to contain a location name along with your company name ... be sure to use that whole thing as your Account Name
{Your Name}.us-east-1
If your Snowflake URL is just {Your Name}.snowflakecomputing.com then you are good to go with just your Account name.