search

ankane / blazer

Business intelligence made simple
MIT License
4.5k stars 471 forks source link

[Questions] Version control queries + Slack notification setup #456

Closed pil0u closed 9 months ago

pil0u commented 10 months ago

Hi @ankane,

Thanks a lot for your projects and making them open source. I am using strong_migrations and blazer in an open source Rails project, it's a blast 🙌

I have two (unrelated to each other) questions:

  1. Is there a typical process to version control queries, where I could write/design an SQL query in dev, commit it to the repo, and make it accessible in Blazer in prod seamlessly? Edit: Eventually, it does not really make sense

  2. I have tried to setup Slack notifications with an incoming webhook for checks, but I might be missing a piece of the puzzle. Here are the steps I followed:

    1. In blazer.yml, I uncommented slack_webhook_url: <%= ENV["BLAZER_SLACK_WEBHOOK_URL"] %>
    2. I added my webhook in my .env file locally BLAZER_SLACK_WEBHOOK_URL=https://hooks.slack.com/services...
    3. I created a (failing) check and configured it like this: Screenshot 2023-11-16 at 16 05 47

As you can see, I tried multiple identifiers for the Slack channel, but nothing pops in. The webhook is tied to this channel and it works, I tried with a basic curl command. But not through Blazer. What am I missing?

blazer (3.0.1)

Thank you!

ankane commented 9 months ago

Hi @pil0u, I'm not sure why it wouldn't be working for your application, but you could try using the OAuth approach: https://github.com/ankane/blazer/pull/368#issuecomment-990559373