Setup
App installation
- Get below details from your snowflake setup
- Account - Account identifier . Note: The region should be added as suffix here. (Ex - “abc26863.us-east-1”)
- Username - Username of the snowflake profile
- Password - Password of the snowflake profile
- Database - Database name to query or insert data.
- Schema - Snowflake schema name to query the data
- Warehouse - Warehouse name to execute queries
- Role - Role to be used while executing queries
- Go to Snowflake app in Togai’s no-code center and provide these details to create a connection.
Flow installation
- Go to the Flow List page in Togai’s no-code center and enable the pre-defined flows related to snowflake sync to export or import data.
Sync usages from Snowflake to Togai
This predefined flow gets the usage data from Snowflake periodically and ingest them to Togai. To enable this flow, two inputs are requested from user- SQL query to query the data from Snowflake and push to Togai. As part of query response, this flow expects these attributes in the query response -
a “accountId” - This represents the account to attribute the usage.
b “usage” - The value of the usage
c “timestamp” - The timestamp to when the usage should be ingested. To be in ISO format.
d “id” - Unique id of the usage
- Togai usage meter id to ingest this usage.