Skip to content

Instantly share code, notes, and snippets.

@MarkPryceMaherMSFT
Created June 18, 2025 23:44
Show Gist options
  • Save MarkPryceMaherMSFT/873926ec9bfec2d9830ef7133d357f6f to your computer and use it in GitHub Desktop.
Save MarkPryceMaherMSFT/873926ec9bfec2d9830ef7133d357f6f to your computer and use it in GitHub Desktop.
Example metadata file for a DelimitedText text file
{
"KeyColumns": [ "_id_" ],
"SchemaDefinition": {
"Columns": [
{
"Name": "id",
"DataType": "Int32"
},
{
"Name": "Timestamp",
"DataType": "DateTime",
"IsNullable": true
},
{
"Name": "ToBank",
"DataType": "String",
"IsNullable": true
},
{
"Name": "Account",
"DataType": "String",
"IsNullable": true
},
{
"Name": "AmountReceived",
"DataType": "Double",
"IsNullable": true
}
]
},
"FileFormat": "DelimitedText",
"FileExtension": "csv",
"FileFormatTypeProperties": {
"FirstRowAsHeader": true,
"RowSeparator": "\r\n",
"ColumnSeparator": ",",
"QuoteCharacter": "'",
"Encoding": "UTF-8"
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment