Best answer

MySQL Tables not showing up

  • 19 March 2020
  • 2 replies
  • 743 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

View original

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

2 replies

Userlevel 7
Badge +12

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!