Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Scheduled queries should support default parameters #43

Closed
rafrombrc opened this issue Feb 24, 2017 · 2 comments · May be fixed by MaxMood96/redash#8, MaxMood96/redash#22, MaxMood96/redash#23 or MaxMood96/redash#30
Assignees
Milestone

Comments

@rafrombrc
Copy link
Member

If you save a queries that contains parameterized values, whatever values are set for those parameters will be used by default when that query is executed in the future. Unfortunately, this only works when the queries are run by hand, and not when the queries are automatically run via the scheduler. We'd like to extend this default parameter support to automatically scheduled queries.

@davismtl
Copy link

When will this be made available and how can I find out how to use this feature?

@rafrombrc
Copy link
Member Author

This should be working on production now. I believe you can use it by a) creating a query, b) specifying some parameterized variables in the query, c) using the query source page to set the query parameters to the desired default values, d) saving the query, and e) specifying an execution schedule for the query. Please let me know if you have any issues with this.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment