Input
Azure SQL Input
Reads a whole table or view from an Azure SQL database (yourserver.database.windows.net) and turns it into rows.
When to use it
Use it for data held in Azure SQL Database or Azure SQL Managed Instance — the same SQL Server engine, hosted by Microsoft.
In a pipeline
Azure SQL InputSummarize (Multi-Aggregate)Export Excel
Settings
| Setting | Type | Required | Default or hint |
|---|---|---|---|
| Connection | select | Yes | Add a connection below |
| Table | select | Yes | Select a table |
Example
Read the customer table
- Connection=sqladmin@contoso.database.windows.net/Sales
- Table=dbo.Customers
| CustomerId | Name | Region |
|---|---|---|
| 17 | Harbour Foods | North |
| 18 | Cole & Sons | South |
Worth knowing
- The connection is always encrypted and Azure's certificate is checked; Azure SQL connections are listed separately from SQL Server ones.
- Allow FlowDoo's server address through the Azure SQL firewall (Networking ▸ Firewall rules), or the connection times out.
- Tables and views are listed as schema.name; click Refresh after picking the connection.