We are facing issue while loading data from AWS EMR/Spark to memSQL. We tried with memSQL Pipeline with proper privileges to normal user like 1. create pipeline, drop pipeline, start pipeline and stop pipeline. Still we are unable to load data.
We also tried to use Spark Connector to memSQL to load data still we are facing issue. Actual error we got is -
Access Denied for user <user_id> to database <db_name>
If we try to run job using memSQL root credentials it works fine.
Can anyone suggest what privileges we are missing.
Thanks in advance.