With CSV Upload, a CSV may be uploaded into a View and then selected out of that View in any chart.
Note: CSV Upload functionality is only available with the cache add-on, and allows for up to 50MB of data to be uploaded. For the best experience, we recommend using CSV's 10MB or less.
To get started, open the CSVs menu in the sidebar and click on the green plus-sign.
Once the upload menu is open, drag the CSV file into the corresponding area or click "Browse" to choose the file from a dialog.
CSVs must have a header row. The names in the CSV's header row will become the column names in the view. Because the CSVs will be stored on Periscope's Redshift cache, they must adhere to Redshift's naming convention:
Additional information can be found here.
Once the View has been successfully uploaded, the user can name the CSV by editing the header that is titled 'Untitled CSV View' by default.
Note: Once a View is saved, it cannot be renamed, and the user will be required to delete the view and rename a new upload of the CSV.
Once the View has been saved and cached, selecting from the new View can be accomplished in the same way as selecting from SQL-based views, like so:
Using the new "original_pokemon" view to compute base experience and speed:
Joining to a CSV Upload is similar to a cross-database join and requires all tables in the query to be cached.