SQL table alias autocomplete
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-16-2022 09:01 AM
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'
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-17-2022 10:34 PM
autocomplete works when you have a running cluster, can you please check and update, because it is working fine for me
AviralBhardwaj
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-18-2022 09:36 AM
My cluster is running fine. Does autocomplete work for you with a table alias?