For the complete documentation index, see llms.txt. This page is also available as Markdown.
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.
