snowflake-ingest-node
simple API wrapper for Snowpipe for https://www.snowflake.com/ . At time of writing only Python and Java were available SDKs
snowpipe intro: https://docs.snowflake.com/en/user-guide/data-load-snowpipe-intro.html
Note that there is also an auto-ingest feature built into snowflake.
; ;; describe' > Snowflake API harness',;
secrets and environment
You'll want to ensure your private key is secure in a vault or secret management (I am storing the lookup key as an environment variable). The rest could come from environment or hard coding. Here is a sample .env
as above for running locally and against your setup in the cloud likely serverless:
snowflake_private_key=<your key>snowflake_account=<snowflake account>snowflake_username=<user you created with permission to pipe>snowflake_region_id=<region is optional see docs ie: us-central1>snowflake_cloud_provider=<optional as well. see docs: could be gcp
adding to your project
You can just copy the one file or add via npm:
yarn add snowflake-ingest-node
yarn add jwt-simple
There is a peer dependency on jwt-simple
, so make sure it is added as well. There are no other dependencies except for built-in node (https and crypto) modules.