Get DataReader
Provides a DataReader for reading a forward-only stream of rows from a SQL Server database.
Example 
This flow example shows a process that reads data from a database, splits records into multiple chunks, converts each chunk into CSV format, and appends it to a blob storage.
Actions used in the flow are: SQL Server Get DataReader, DataReader chunker, Create CSV file as byte array and Append to Blob.
Properties
| Name | Type | Description |
|---|---|---|
| Title | Optional | The title or name of the command. |
| Connection | Required | The SQL Server Connection. |
| Dynamic connection | Optional | Use this option of you needs to use a connection from the Create Connection action. |
| SQL expression and parameters | Required | The command to execute along with any parameters. |
| Reader variable name | Optional | Name of the return variable. |
| Command timeout (sec) | Optional | The time limit for command execution before it times out. Default is 120 seconds. |
| Description | Optional | Additional notes or comments about the action or configuration. |
Returns
Videos / Getting started
This section contains videos to help you get started quickly working with Azure SQL / SQL Server using Flow.
Dump CSV file from Azure Blob container to Azure SQL table
This video demonstrates how to import all records from a CSV file into an Azure SQL table.
In the demo, no data import options (such as data type conversion, number or date formatting) are specified, meaning the data is imported as raw text.