Enabling ignition to see the columns in my database tables

I have created a successful database connection for my Ignition project and I can successfully query data by writing SQL queries manually. I am wondering if someone can tell me why I cannot see my DB tables when I try to use DB Browse. Any help would be much appreciated.

Check the gateway logs (Gateway Webpage -> Status -> Diagnostics -> Logs) first - see if there’s some error code being reported.

The most likely cause is lack of permissions, followed by some quirk of your DB/connection settings.

You were right about it being some quirk of my DB/connection settings. I needed to check the “Include Schema in Table Name” checkbox in the advanced settings area in order to get them to show. Thank you for pointing me in the right direction.

1 Like