Elementary cloud doesn't require read permissions to your tables and schemas, but only the following:
Read-only access to the elementary schema.
Access to read metadata in information schema and query history, related to the tables in your dbt project.
It is recommended to create a user using the instructions specified above to avoid granting excess privileges.
For more details, refer to security and privacy.