Trino Query Error Too many dots in table name

[Damian2023]

Hello

I am having issues running a query where I'm using a temp table, I cannot find a good source of the answer, if someone came across this scenario and was able to resolve please share.

[Peachyco]

This is kinda difficult to troubleshoot without getting a good sense of your query. Can you share your query? Maybe change the actual values if you're concerned about security.

We did encounter something like this, and it involved the double-quotes ("") in the name - not specifically in Alteryx but in the query itself:

• Our original query looked something like: SELECT * FROM ABC.XYZ."SOME.TABLE.NAME";
• It turned out that the double-quotes were being discarded by the system during interpretation, ending up with too many dots.
• The solution was to escape the double-quotes: SELECT * FROM ABC.XYZ.\"SOME.TABLE.NAME\";