A new lightweight T-SQL editor within the Azure portal is available for all Azure SQL data warehouses. You can now get an interactive query experience directly in the context of your data warehouse. There is no need to install client tools or open ports on client machines to run queries. You can use the editor 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.