Interactive query experience for Azure SQL databases and data warehouses
A new lightweight T-SQL editor within the Azure portal will soon be available for all Azure SQL data warehouses. You'll get an interactive query experience directly in the context of your data warehouse. There won't be any need to install client tools or open ports on client machines to run queries. You'll be able to conveniently query dynamic management views for real-time workload insights, issue ad hoc queries, manage your user authentication, and more.
To use the editor: go to a SQL data warehouse and select the Query editor button in the Common Tasks panel.
Read more about the new T-SQL editor.