Skip to main content
Best answer

MySQL Tables not showing up


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?

Best answer by DanversBest answer by Danvers

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
Did this topic help you find an answer to your question?
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

Danvers
Forum|alt.badge.img+12
  • Zapier Staff
  • 3731 replies
  • Answer
  • March 23, 2020

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. 


  • Author
  • Beginner
  • 1 reply
  • March 25, 2020

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