Concepts → Local Data File
About a local data file
Using the Data Manager, you can upload one or more data files and folders to Shared Storage for a given tenant in an Incorta cluster. An uploaded file is a local data file and an uploaded folder is a local data folder.
Incorta exposes the local data files and local data folders as the LocalFiles data source. With the File System connector, you can connect to the LocalFiles data source.
The File System connector supports selecting a local data file or a group of files from a local data folder.
Supported file formats
The Data Manager allows you to upload one or more local data files in the following file formats:
File Extension | File Type | Example | Notes |
---|---|---|---|
.csv | comma separated values | sales.csv | Can contain a header row |
.tsv | tab separated values | sales.tsv | Can contain a header row |
.tab | tab separated values | sales.tsv | Can contain a header row |
.txt | custom delimiter for separated values | sales.txt | Can contain a header row |
.xlsx | Microsoft Excel 2000 and above | sales.xlsx | Must be .xlsx .Supports Worksheet selection. |
.kml | tag-based structure with nested attributes based on the XML standard | sales.kml | All tags are case-sensitive. Support for the Keyhole Markup Language (KML) file format is available starting with the 2021.4.1 release. |
.kmz | zipped version of a KML file | sales.kmz | |
.gzip | compressed file format for Linux and Unix | sales.gzip | Archive must contain a supported file type |
.zip | compressed file format for Mac OS and Windows | sales.zip | Archive must contain a supported file type |
After a file upload, Incorta will unzip compressed folders and files. Compressed file formats must contain a support file format: .csv
, .tsv
, .tab
, .txt
, .kml
, or .xlsx
.
A local data file can contain a header row.