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'