CREATE FOREIGN TABLE "products.dbo.ProductData" (......) is a valid DDL statement and ends up setting the name for the table to products.dbo.ProductData
The current logic in TeiidDdlImporter.init() method will change the table name if it includes the "." delimiter.
For: products.dbo.ProductData, the name will be truncated to ProductData
This is in error because Designer and Teiid support the . as a valid character in a table name.