Skip to main content

CSV

Prophecy Automate

Read or write a CSV file from an external connection.

info

You can also use the upload file feature to use CSV files. These will be stored in the SQL warehouse configured in your fabric.

Supported connections

Parameters

ParameterTabDescription
Connection typeTypeLocation you want to connect from.
Format typeSource locationFormat of the gem. In this case, csv.
Select or create connectionSource locationWhether to select an existing connection, or to create a new one.
FilepathSource locationFile path where you want to read and write files according to the connection type.
PropertiesPropertiesOptional table properties to apply. Source and target properties are outlined below.
SchemaPropertiesSchema definition of the table (custom or inferred).

Source properties

PropertyDescriptionDefault
DescriptionDescription of the table.None
SeparatorCharacter used to separate values in the CSV file.,
HeaderWhether the first row is the column header.True
Null ValueString that represents a null or missing value in the CSV.None
Comment CharacterCharacter used to denote lines in the file that should be treated as comments.None
Inference Data Sampling LimitMaximum number of rows to sample for inferring the schema.0

Target properties

PropertyDescriptionDefault
DescriptionDescription of the table.None
SeparatorCharacter used to separate values in the CSV file.,
HeaderWhether to make the first row the column header.True
Null ValueString that represents a null or missing value in the CSV.None
Use CRLF as line separatorIf enabled, lines in the CSV will end with \r\n (Windows-style newlines).None