Upload a Flat File into Composer

Composer can visualize data from flat files including CSV, JSON, and TSV files. Note the following:

  • The maximum supported file size is 500 MB
  • Data from the flat file is stored in a PostgreSQL database

Before you can establish a connection from Composer to your flat file storage, a connector server needs to be installed and configured. See Manage Connectors and Connector Servers for general instructions and Connect to the Flat File for details specific to the flat file connector.

After the connector has been set up, you can create data source configurations that specify the necessary connection information and identify the data you want to use. See Manage Data Source Configurations for more information. After data sources are configured, they can be used to create dashboards and visuals from your data. See Create Dashboards.

Composer Feature Support

Flat file support for specific Composer features is shown in the following table.

Key: P - Supported; O - Not Supported; N/A - not applicable

Feature Supported?
Admin-Defined Functions P
Box Plots P
Custom SQL Queries P
Derived Fields (Row-Level Expressions) P
Distinct Counts P
Fast Distinct Values N/A
Group By Multiple Fields P
Group By Time P
Group By UNIX Time P
Histogram Floating Point Values P
Histograms P
Kerberos Authentication
Last Value P
Live Mode and Playback P
Multivalued Fields N/A
Nested Fields N/A
Partitions O
Pushdown Joins for Fusion Data Sources P
Schemas P
Text Search N/A
User Delegation O
Wild Card Filters P
Wild Card Filters, Case-Insensitive Mode P
Wild Card Filters, Case-Sensitive Mode P

Connect to the Flat File

For details about what is provided on each page of the connection process, review the topic Manage Data Source Configurations . When you connect to a flat file, the data source configuration wizard includes a Data tab instead of a Connection tab. On the Data tab, select a CSV, JSON, or TSV file to upload. Messages on the Data tab warn you if the file you select has problems or requirements that need to be corrected in the source file before proceeding.