New text editor "Monaco" does not find SQL-tables or aliases.

ValterF — Thu, 16 Mar 2023 10:29:03 GMT

I am having troubles with the new text editor "Monaco", it does not find my SQL-tables as soon as they are nested in SQL-commands and marks them with red underscoring which is really annoying. Even though the code works perfectly...

It also have troubles finding aliases sometimes in SQL-commands, for example the "TARGET" gets underlined with red text:

merge into GOLD.facttable as TARGET
using (select 
fv.Account as Account,
fv.FinancialYear as FinancialYear
from (
select 
account, 
year(calendardate) as FinancialYear 
from gold.dimensiontable
group by account, year(calendardate)) as fv
left join silver.dimensiontable2 as bm
on bm.account = fv.account) as source
on TARGET.account = source.account and source.financialyear = year(TARGET.calendardate)
WHEN MATCHED THEN UPDATE SET *

This is frustrating, until fixed I'll stick with the old editor.

Another feature I would like to see in this new editor is a space after each autocompleted "tab"-keypress.

Re: New text editor "Monaco" does not find SQL-tables or aliases.

lizou — Mon, 24 Apr 2023 12:55:31 GMT

Hi Databricks team,

I also found sql intellisense does not work when using

USE DB or USE Catalog.DB

It only works when using full table names such as catalog.db.table_name

but typically I don't use full table names. I set use DB at top of the notebook as the same notebook may be used for another database.

topic New text editor "Monaco" does not find SQL-tables or aliases. in Data Engineering

New text editor "Monaco" does not find SQL-tables or aliases.

Re: New text editor "Monaco" does not find SQL-tables or aliases.