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.