SQL table alias autocomplete

jt
New Contributor III

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'