Uploading a Flat File into Zoomdata

Zoomdata 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 Zoomdata to your flat file storage, a connector server needs to be installed and configured. See Managing Connectors for general instructions and Connecting 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 Managing Data Source Configurations for more information. After data sources are configured, they can be used to create dashboards and charts from your data. See Creating Dashboards and Creating Charts.

Zoomdata Feature Support

The flat file connector supports all Zoomdata features, except for the following features:

  • Custom SQL queries
  • Kerberos authentication
  • Live mode/playback
  • Partitions
  • User delegation

Connecting to the Flat File

For details about what is provided on each page of the connection process, review the topic Managing 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.