From what I can see, you have a couple of syntax errors in your create statement. First off, the quotes around the parts of the table declaration are unnecessary. Denodo VQL shell also apparently doesn’t like fully qualified tables, at least in create statements. So, make sure you’re connected to the db that you want this table in when you run it, and remove “TESTING”, that will eliminate the syntax error near “.”. But you also can’t have spaces in column names, so you ought to replace those with underscores. After that, you should be good to go. I would test it with [CREATE TEMPORARY TABLE](https://community.denodo.com/docs/html/browse/7.0/vdp/vql/temporary_tables/creating_temporary_tables/creating_temporary_tables) if you have cache configured, just to let you tweak it and play around with it without creating anything permanent.
Hope this helps!