The easiest way to ingest data to Peak is by performing a direct file transfer. This is typically done at the start of a project or on an ad hoc basis and can be done via a simple drag and drop, FTP / SFTP or signed URL.


This article describes how to perform an ad hoc upload to Peak. 


Contents


Before you start

To successfully upload a file and then start using the data you will need to:

  • Make sure the file is an agreed type and formatted correctly.
  • Give your file a suitable name and give it a timestamp, if necessary.
  • Upload the file using the Peak interface.
  • Set up a File Feed so that the data can be ingested into the tenant's data lake.


File types and formats

What types of file can I upload?

The recommended file format is CSV (.csv). 

If agreed in advance, other file types can be uploaded. 

These include: Excel (.xlsx), text (.txt) and PDF (.pdf)


How large can my file be?

There is no limit to the file size.


How should I format the CSV file?

CSV files must be formatted in the following way:

  • Standard data table of columns and rows.
    If you are doing a ‘Save as’ from Excel, only save one sheet per workbook.
  • The first row must be the column headers.
  • Any values with commas must be enclosed in double quotes.
    If the values are numbers, remove the formatting.


File naming and timestamps

Use a short but descriptive file name.

If data from the file is to be updated and fetched regularly as part of a feed, make sure your files are named with a timestamp.


For details about creating a feed and using timestamps, see How to create a feed for a file.



Uploading a file

Files can be directly uploaded to Peak from these screens:

  • Home > Data Sources Widget > Ad hoc upload icon
  • Dock > Data Sources > ADD > File Storage: Ad hoc Upload
  • Data > Data Sources > ADD > File Storage: File Upload (for when you are creating a feed for a file)


Importing your file

Drag and drop your file or or upload your file from your personal computer.

Once your file has be successfully uploaded, you will need to create a file feed to ingest the data into the tenant’s data lake.

For details of how to set up a feed, see How to create a feed for a file.


  • Click UPLOAD FILE or drag and drop your file.
    Wait for the upload to complete before leaving the page.
    You will be notified if the upload is successful.
    The latest uploads to the tenant are listed in the Existing Files area.