topic SQL endpoint query editor intellisense/autocomplete support in Data Engineering

SQL endpoint query editor intellisense/autocomplete support

kdoherty — Mon, 17 Jul 2023 21:02:18 GMT

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

Re: SQL endpoint query editor intellisense/autocomplete support

Anonymous — Fri, 28 Jul 2023 14:35:53 GMT

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).