How to setup rouser for data ingestion

A step-by-step guide for creating read-only database access using Doppler for secret management.

Prerequisites

If running this locally you will need to make sure that your IP is whitelisted for the database host.

Create a new rouser user

python scripts/grant_rouser_credentials.py create-readonly\
--host $DB_HOST \
--admin-user admin_user \
--username rouser

After running the script, you will be prompted to enter the password for the new rouser user and the password for the admin user.