Overview
Uses a CData plugin
This algorithm allows you to connect to an existing snowflake service and get, update, insert and delete data using a simple SQL interface.
Configuration Settings
This algorithm requires configuration settings to work. You'll need:
- your username/password
- a snowflake warehouse name (eg; "COMPUTE_WH")
- your snowflake account url (eg; "https://BC49603.us-east-2.aws.snowflakecomputing.com")
- and a snowflake database name (eg; "DEMO_DB")
if you're using a non-standard snowflake account that doesn't contain your account information in the url, you'll also need your account name.
To Configure
to configure, gather the information necessary above, and make an API request like the following
{"user": ..., "password": ..., "warehouse": ..., "url": ..., "database": ..., "account": ...}
Where account
and database
are optional.
The response will return a data API similar to the following:
data://.algo/zeryx/cdata_snowflake/perm/config.json
once that's done the algorithm will automatically find your configuration settings and use it for future requests. If you'd like to make a change please delete the file at that location and run the configuration steps again.
Usage
Input
Your SQL command, for example:
"SELECT ID FROM TEST"
will yield:
["(1)", "(2)", "(3)"]