SQL Editor
Acho Team understands that sometimes the desired data transformation action to be performed is just too complex or inefficient to be done via a sequence of available actions. This is why Acho offers a SQL editor to allow our advanced users proficient in SQL to have the flexibility to perform more advanced actions. The SQL Editor on Acho supports standard SQL syntax and functions.
Troubleshooting
The SQL Editor does not support line-level execution. That is, everything in the editor will be executed all at once. Therefore, please make sure to include a semicolon
;
at the end of the query and not to have empty lines after the semicolon;
. Also, the SQL Editor cannot include more than two queries at a time, that is, more than two semicolons;
.All table names must have a prefix of
SQL_EDITOR_
and a suffix of_TABLE
.When using the
JOIN
orUNION
statements, you have to import all needed tables into the project first. The SQL Editor can only access tables within the current project.when using the
JOIN
statement, if there are two columns with the same name, the query will run into an error. join a table to itself. For example, if you join a table to itself (that isSELF JOIN
) and select all columns, then an error occurs due to duplicate column names.
You have can change your query like the following.
Learn more supported SQL queries:
pageSQL Editor QueriespageAll functions in Formula/SQLLast updated