topic SQL table alias autocomplete in Data Engineering

SQL table alias autocomplete

jt — Fri, 16 Dec 2022 17:01:43 GMT

I have a table with 600 columns and the table name is long. I want to use a table alias with autocomplete but it's not working. Any ideas how I can get this to work?

works

%sql 
 
--autocomplete works 
SELECT 
verylongtablename.column200 
verylongtablename.column300
FROM
verylongtablename
WHERE
verylongtablename.column400 = 'yes'

does not work

%sql 
 
--autocomplete doest not work
SELECT 
a.column200 
a.column300
FROM
verylongtablename as a
WHERE
a.column400 = 'yes'

Re: SQL table alias autocomplete

Aviral-Bhardwaj — Sun, 18 Dec 2022 06:34:29 GMT

autocomplete works when you have a running cluster, can you please check and update, because it is working fine for me

Re: SQL table alias autocomplete

jt — Sun, 18 Dec 2022 17:36:59 GMT

My cluster is running fine. Does autocomplete work for you with a table alias?