Error creating connection between MySQL source and PostgreSQL destination

Slack Knowledge Base Q&A Connector Questions
, , , ,
1

Summary

Error message ‘Internal message: java.sql.SQLException: View ‘Database_name.emp_vw’ references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them’. Failure type: system_error.


Question

Hi,
I am having a successful source and destination setup and where i am facing the below error while connection creation.

source : - MYSQL
destination : - postgreSQL

Error: Internal message: java.sql.SQLException: View ‘Database_name.emp_vw’ references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them
Failure type: system_error


This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. Click here if you want to access the original thread.

Join the conversation on Slack

["mysql", "postgresql", "connection-error", "system-error"]
2

Looks like your ETL user doesnt have permissions to some objects that view is using?