cancel
Showing results for 
Search instead for 
Did you mean: 
Data Engineering
cancel
Showing results for 
Search instead for 
Did you mean: 

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'

3 REPLIES 3

Aviral-Bhardwaj
Esteemed Contributor III

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

jt
New Contributor III

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

Kaniz
Community Manager
Community Manager

Hi @james t​, Try this:-

autocomplete="on"

Welcome to Databricks Community: Lets learn, network and celebrate together

Join our fast-growing data practitioner and expert community of 80K+ members, ready to discover, help and collaborate together while making meaningful connections. 

Click here to register and join today! 

Engage in exciting technical discussions, join a group with your peers and meet our Featured Members.