Improve documentation regarding Scheduling and Emailing Reports

[VMois]

Is your feature request related to a problem? Please describe.

• no example/steps (or link to another doc page) regarding setting up a Celery worker for email scheduling
• missing information about naming in EMAIL_REPORTS_WEBDRIVER. Docs suggest geckodriver and chromedriver, but in reality, it is firefox and chrome

Describe the solution you'd like

• add example regarding EMAIL_REPORTS_WEBDRIVER
• step-by-step instruction including setting up a Celery worker (or linking existing documentation of exists)

Describe alternatives you've considered
No alternatives

Additional context
Link to existing docs - https://superset.apache.org/docs/installation/email-reports

[issue-label-bot]

Issue-Label Bot is automatically applying the label #enhancement to this issue, with a confidence of 0.97. Please mark this comment with 👍 or 👎 to give our bot feedback!

Links: app homepage, dashboard and code for this bot.

[DRavikanth]

I agree with this. Documentation is very poor and no clear instructions on how to set things up for production environments. I am trying to make Superset work with email scheduling including Celery and it's been 3 days and my struggle continues. I am making progress but I have to debug each and every minute detail. I am very disappointed with not even finding an official architectural image in the documentation. :(

[VMois]

From my side, I managed it with some struggle. Use Redis, do not try filesystem as a backend. This is the article I was using - https://medium.com/@nileshxbhosale/apache-superset-a-cost-effective-alternative-to-quick-sight-for-data-lake-668868fe51c7 (+ docs).

[DRavikanth]

#11507

@VMois, running into this problem. Any pointers?

[VMois]

@DRavikanth if you are using Docker Compose add the following to your superset image:

superset:
    shm_size: '2gb'  # fix for gecko driver failure
    # ...

You can find the same in the article I shared with you.

[DRavikanth]

@VMois, Thanks for the pointer. I missed that totally, let me try that and keep posted here.

[VMois]

@DRavikanth, pls, create a separate issue for your problem. Describe your setup, etc. This is an issue related to improving docs.

Regarding your problem, it is a different error compared to what you had. Good sign. Check if you have the latest stable version of the geckodriver, I have 0.27.0. Other than that, I did everything exactly like in the article, so I cannot help you a lot as I don't know the full setup.

[DRavikanth]

@VMois, makes sense.

[octaviancorlade]

The documentation for these was introduced in #13104