search

datalytyx / snowflake-webhooks

A work around implementation to allow webhooks to be called from inside Snowflake. This allows powerful bidirectional integration between Snowflake and other external systems.
Apache License 2.0
15 stars 0 forks source link

Installation process question #6

Open Befoh opened 3 years ago

Befoh commented 3 years ago

Hi guys,

First off amazing work and thank you for sharing.

I'm keen on getting this set up and wanted to double check I'm on the right path.

Do we run the below via AWS CodeCommit? In other words apart from the sql setup in Snow; how/where do we proceed to execute the other scripts?

image

Thanks in advance.

Regards,

dmarts commented 3 years ago

HI @Befoh - you can run these commands (the exports and the cats) from a linux box somewhere or using WSL if Windows is your thing. It's a one-time activity to take the template files and personalise them for your environment - then when you run serverless deploy they'll be used to set everything up for you.

So the process is:

  1. Get your 'temporary' linux environment, in my case WSL2
  2. Setup AWS CLI (including aws configure), setup Serverless, clone the repo to your box
  3. cd into the repo
  4. Run the export commands to set your variables
  5. Run the cat commands to update the template scripts with your variables
  6. Run serverless deploy

Then carry on with the rest of the Snowflake setup etc.

[CC @guy-adams ]

Befoh commented 3 years ago

Appreciate the quick reply, thank you very much.