File Uploads

You can create data layers by uploading files directly into Kogenta Connect. This is useful for bringing in data that is not available through a database connection, such as spreadsheets, exported reports, or geographic boundary files.

Supported file formats

Supported delimiters are automatically detected: comma, semicolon, tab, and pipe.

Uploading a file

1. Navigate to the Data Layers section
2. Select the option to upload a file
3. Choose your file from your computer
4. The platform processes the file and infers the schema (column names and types)
5. The uploaded file appears as a new data layer

Schema inference

When you upload a file, Kogenta Connect automatically detects the column names and data types. For example:

• Text columns are detected as strings
• Numeric columns are detected as integers or floats
• Date-formatted columns are detected as dates
• WKT geometry fields are detected as spatial types

Using uploaded data layers

Once uploaded, file-based data layers work just like connection-based ones. You can:

• Reference them in workflow SQL queries
• View their schema to understand available columns
• Organize them in folders alongside your connected data layers

Sync status

Uploaded data layers show a sync status indicating whether the file data has been fully processed and is ready for querying. Once the upload completes and processing finishes, the data layer is available for use in workflows.