Best answer

MySQL Tables not showing up

  • 19 March 2020
  • 2 replies
  • 45 views

Userlevel 1

Only one of my tables in the MySQL database that I’ve connected to Zapier shows as an option for inserting new columns. Is there a reason the other tables don’t show up as an option in the Customize Row → Table drop-down?

icon

Best answer by Danvers 23 March 2020, 15:55

Hi @strelton! The most common reason for tables not appearing in the dropdown is if Zapier doesn’t have permission to see them. Are there any additional permission on the tables that you can’t see?

Also, can I double check whether you’re trying to see a table or a view? Sometimes views don’t show in the dropdown lists, if that’s the case here then you need to select the ‘Custom’ option and enter the exact (case-sensitive) name of the view in that field. 

View original

This topic has been closed for comments

2 replies

Userlevel 7
Badge +11

Hi @strelton! The most common reason for tables not appearing in the dropdown is if Zapier doesn’t have permission to see them. Are there any additional permission on the tables that you can’t see?

Also, can I double check whether you’re trying to see a table or a view? Sometimes views don’t show in the dropdown lists, if that’s the case here then you need to select the ‘Custom’ option and enter the exact (case-sensitive) name of the view in that field. 

Userlevel 1

Thanks! I had set my user privileges for one table only. Thanks for the help!