{"repo":"ankane/blazer","free":true,"listed":false,"github":"https://github.com/ankane/blazer","clone":"git clone https://github.com/ankane/blazer.git","description":"Business intelligence made simple","language":"Ruby","stars":4797,"topics":["business-intelligence","charts","sql"],"license":"MIT","category":"databases-storage","readme_excerpt":"Blazer Explore your data with SQL. Easily create charts and dashboards, and share them with your team. Try it out Blazer is also available as a Docker image. :tangerine: Battle-tested at Instacart Features - Multiple data sources - PostgreSQL, MySQL, Redshift, and many more - Variables - run the same queries with different values - Checks & alerts - get emailed when bad data appears - Audits - all queries are tracked - Security - works with your authentication system Docs - Installation - Queries - Charts - Dashboards - Checks - Cohorts - Anomaly Detection - Forecasting - Uploads - Data Sources - Query Permissions Installation Add this line to your application’s Gemfile: Run: And mount the dashboard in your config/routes.rb : For production, specify your database: When possible, Blazer tries to protect against queries which modify data by running each query in a transaction and rolling it back, but a safer approach is to use a read-only user. See how to create one. Checks (optional) Be sure to set a host in config/environments/production.rb for emails to work. Schedule checks to run (with cron, Solid Queue, Heroku Scheduler, etc). The default options are every 5 minutes, 1 hour, or 1 day, which you can customize. For each of these options, set up a task to run. You can also set up failing checks to be sent once a day (or whatever you prefer). Here’s what it looks like with cron. For Solid Queue, update config/recurring.yml . For Slack notifications, create an incoming webhook","default_branch":null,"files":null,"tree":[],"storefront":"/r/ankane","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/ankane/blazer/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}