All integrationsAnalytics

Redash

Run Redash queries and SQL and use the rows in a workflow: send a report or a CSV, copy results to a sheet, find queries and dashboards.

actions
10
triggers
3

Triggers

Start a workflow when something happens in Redash.

  • Alert triggeredRuns when a Redash alert is triggered, with what it checks and the value it saw, and again each time Redash notifies again while it stays triggered. Redash checks an alert when its query runs.
  • Alert back to normalRuns when a triggered Redash alert goes back to OK, such as to post an all-clear or close a ticket. Redash checks an alert when its query runs.
  • New row in a queryRuns for each new row in a saved query's results, such as a new order or sign-up. Rows there when the workflow is turned on don't run it.

Actions

Steps a workflow can run in Redash.

  • Run queryRun a saved query with its parameters and get the rows, to send as a report or copy to a sheet.
  • Get latest resultsGet the results Redash last saved for a query, as its page shows them, without running it again.
  • Download results as CSVRun a query and save its results as a CSV file in Lodol, as Redash's Download as CSV File makes it, to attach to an email or upload.
  • Run SQL queryRun SQL on a data source without saving it as a query, and get the rows. It runs with the data source's own access, so it can change data if that allows.
  • Find queriesFind saved queries by words in their names, descriptions or SQL, or by tag, with their links.
  • Get queryGet a saved query's details: its SQL, its parameters with their saved values, its refresh schedule and visualizations.
  • Find dashboardsFind dashboards by words in their names, with their links.
  • Get dashboardGet a dashboard's details and the queries on it, to run each of them, with its public link if it's shared.
  • List alertsList Redash's alerts with their state, triggered ones first: what each checks and when it last changed.
  • List data sourcesList the data sources Lodol's Redash user can query, and which only run saved queries.

Automate Redash with Lodol.

Connect Redash, then hand Lodol the job in Slack, Claude or ChatGPT.

Free plan, no credit card