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)"]