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.

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.