Forum Discussion

kdoherty's avatar
kdoherty
Advocate I
3 years ago

SQL endpoint query editor intellisense/autocomplete support

Is Intellisense/autocomplete for lakehouse SQL endpoint supposed to be supported?  

When I alias a table, I expect to see a column list when using the alias in a select statement, but it doesn't seem to work.

Thinking maybe I am doing it wrong.  Does this work for anyone else?  

 
Thanks.
Kevin Doherty
 
data engineering

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Kevin. Yes should be supported. For some reason it seems to work everywhere (WHERE clause, JOIN conditions) except the list of selected columns. I think you can report it as a bug by opening a support ticket: https://support.fabric.microsoft.com/ (I think Synapse Data Warehouse would be the right experience to choose - the same applies to SQL editor for queries in warehouses).