Can a database, schema, or SQL query can be edited for a scheduled Superset report

Yes, the Database, schema, and dataset of the scheduled reports can be edited if the user is the dataset owner.

  • Go to Data, select ‘datasets’ from the dropdown
  • Click on the edit icon from the Action header of the dataset you want to edit
  • Click on the ‘source’ option
  • Click the lock to make changes.
  • Now you can make changes to the database, schema, dataset name, and SQL query
  • Then click on the lock to prevent further changes and click on save.