Hi, I got this error while ingesting from my datab...
# troubleshoot
h
Hi, I got this error while ingesting from my database.
Copy code
" 'warnings': {'cardcore_issuing_2.view_cardcore_card_master': ['Ingestion error: Table or view named '\n"
           "                                                               '`cardcore_issuing_2`.`view_cardcore_card_master` could not be reflected: "
           "'\n"
           '                                                               \'(pymysql.err.OperationalError) (1356, "View \'\n'
           '                                                               "\'cardcore_issuing_2.view_cardcore_card_master\' references invalid '
           'table(s) or "\n'
           "                                                               'column(s) or function(s) or definer/invoker of view lack rights to use "
           'them")\\n\'\n'
           "                                                               '[SQL: DESCRIBE `cardcore_issuing_2`.`view_cardcore_card_master`]\\n'\n"
           "                                                               '(Background on this error at: <http://sqlalche.me/e/13/e3q8)>'],\n"
May I know what is the cause of this error?
d
Can you normally query the
cardcore_issuing_2.view_cardcore_card_master
dataset? It actually tried to run a simple describe query which failed:
Copy code
DESCRIBE `cardcore_issuing_2`.`view_cardcore_card_master`
Can you run this query manually with the same user?