Input tab

Bulk load into Azure SQL DB Input tab

Use the options in this tab to define your input source for the Azure SQL database:

Option	Description
Source	Specify the VFS URL of the data to import. The URL can point to a file or a folder in Azure Data Lake Storage. The URL must begin with pvfs:// and must specify the bucket and object you want to load. See Pentaho address to a VFS connection .
What file type is your source?	Select the file type of the input source. Must be a CSV file.
Delimited text settings	Specify the following settings for a delimited text file: Delimiter Specify the character used to separate a data field. The default is semicolon (;). First line is column names Select Yes if the first line in the file contains the column names.