How do I migrate my query schedule?

Issue Summary

How do I trigger a schedule?

I’m trying to migrate from Redash v4 to v8.
I have just migrated a Redash v4 database to v8 with different table structure.
I have migrated users/queries/dashboards/widgets/visualizations.
I was able to migrate, but the schedule execution of the query is not working.
There are more than 10,000 queries and it is hard to run them all again.
Is there any way to batch or automatically schedule them?

Technical details:

  • Redash Version: 8.0.0+b32245
  • Browser/OS: docker host on Amazon Linux
  • How did you install Redash: docker

This should happen automatically as you upgrade. What exact steps did you follow?

Since the current Redash environment is not a docker version, I built a new Redash v8 using docker.

Since there is a difference in the database between v4 and v8, I created a test table on postgres, added and changed the necessary columns, and then inserted the sql into postgres.

sudo docker-compose run --rm server manage db upgrade
This command needs to be v4→v5→v6→v8 when going from v4 to v8, right?

(I plan to use this command to upgrade to v10 or higher to manage it with docker in the future!

Translated with DeepL Translate: The world's most accurate translator (free version)

Yes exactly. You’ll upgrade version-by-version.