It is recommended during the learning of Invantive UniversalSQL to make small changes iteratively.
In this case, the failing statement are resolving the ambiguity of the Exact Online schema is:
create or replace table eol_ExactOnlineREST.CRM.AccountClassifications@mss
as
select *
from
ExactOnlineREST.CRM.AccountClassifications@eol
This statement reads all columns and rows from the fully qualified table ExactOnlineREST.CRM.AccountClassifications@eol in Exact Online. And then creates and loads a table on SQL Server (@mss) named: eol_ExactOnlineREST.CRM.AccountClassifications@mss.
As with Exact Online, the catalog is eol_ExactOnlineREST, schema is CRM and table is AccountClassifications. But probably you don’t want to use a new catalog or schema.
The easiest way to test such is to run and test the individual statements in the UniversalSQL-editor, such as:
begin
create or replace table eol_AccountClassifications@mss
as
select *
from
ExactOnlineREST.CRM.AccountClassifications@eol
end;
The full grammar is available on:
https://cloud.invantive.com/sql-grammar/invantive-sql-grammar-current.html