I have just installed your plugin and it works fine with the csv file but I need it to connect to the table I put in my WP database. I have run the query in myphpadmin with success a few times then copied it in to the plugin and get this error. 

wpDataTables backend error: 

No data fetched!
Rendered query: select * from TABLE 2 LIMIT 10

MySQL said: You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use
near 'TABLE 2 LIMIT 10' at line 1
This usually happens when the MySQL
query returns an empty result or is broken. Please check the results of
the query in some DB manager (e.g. PHPMyAdmin)

Here is the query I use, I didn't append the "Limit 10" 

SELECT * FROM `TABLE 2`

Changed table name to same prefix as WP database and it works fine now.