QuestionQ60

Executing queries using Databricks SQL and Databricks SQL Warehouses

A data analyst has been asked to set up an alert for a query that returns income from the accounts_receivable table over a date range. The date range is configurable through a Date query parameter.

The alert does not work.

Which of the following explains why the alert does not work?

  • A Alerts don't work with queries that access tables.
  • B Queries that return results based on dates cannot be used with Alerts.
  • C The wrong query parameter is being used. Alerts only work with Date and Time query parameters.
  • D Queries that use query parameters cannot be used with Alerts.
  • E The wrong query parameter is being used. Alerts only work with dropdown list query parameters, not dates.
Explanation

Redash alerts do not work with queries that use query parameters. The limitation applies to all parameter types, including a Date parameter used to configure a date range.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!