Cascade Library
  • Introduction
    • Welcome to Cascade
    • Workspaces
  • Getting Started
    • Build Your First Workflow
    • Build Your First Data App
  • Workflows
    • Overview
      • Navigating the Canvas
      • Setting Up
      • Drag and Drop
      • Tools
    • Dynamic Workflows
    • Global Variables
    • Data Locker
    • Scheduling
    • Webhooks
    • Run Logs
    • Workflow Deployment
  • Integrations
    • Connecting Cascade to your database
    • Amazon S3
    • Azure Blob Storage
    • BigQuery
    • Google Sheets
    • MySQL
    • Postgres
    • Redshift
    • SQL Server
    • Snowflake
    • Tableau Server
  • Tools
    • Import
      • Import File
      • Import from Data Locker
      • Import from API
      • Import Sample Data
      • New Table
    • Clean
      • Validate Schema
      • Find/Replace
      • Text to Columns
      • Flatten Json
      • Sample
      • Standardize
      • Validate
    • Transform
      • Edit Columns
      • Select Columns
      • Filter
      • Sort
      • Pivot
      • Unpivot
      • Deduplicate
    • Merge
      • Append
      • Join
      • Multi Join
      • Fuzzy Join
    • Predictive Modeling
      • Build Model
      • Apply Model
      • Correlate
      • ARIMA Forecast
    • Flow
      • Conditional
    • Code
      • Python
      • SQL
    • Visualize
      • Chart
        • Bar
        • Line
        • Combo
        • Scatter
        • Histogram
        • Box
        • Pie
        • Area
        • Funnel
    • Publish
      • Publish to Data Locker
      • Publish via Email
      • Publish to URL
      • Embed
  • Functions & Expressions
    • Functions
      • Aggregate Functions
        • AVERAGE
        • CORR
        • COUNT
        • COUNTD
        • COUNTBY
        • COUNTIF
        • COUNTIFS
        • COVAR
        • COVARP
        • COVARS
        • MAX
        • MEDIAN
        • MIN
        • MAXBY
        • MINBY
        • PERCENTILE
        • STDEV
        • STDEVP
        • STDEVS
        • SUM
        • SUMBY
        • SUMIF
        • VAR
        • VARP
        • VARS
        • RUNNINGTOTALBY
          • SIGN
          • SIN
          • SQRT
          • SQUARE
          • TAN
          • ZN
      • Conversion Functions
        • TIMESTAMPTODATE
        • TODATE
        • TODECIMAL
        • TOINT
      • Date/Time Functions
        • DATEADD
        • DATEDIF
        • DATENAME
        • DATENORMALIZE
        • DATEPART
        • DATETRUNC
        • DAY
        • DAYS
        • HOUR
        • ISDATE
        • ISOWEEKDAY
        • ISOWEEK
        • ISOQUARTER
        • ISOYEAR
        • MAKEDATE
        • MAKEDATETIME
        • MINUTE
        • MONTH
        • NOW
        • QUARTER
        • SECOND
        • TODAY
        • WEEK
        • WEEKDAY
        • YEAR
      • Logical Functions
        • AND
        • BETWEEN
        • CASE
        • CHOOSE
        • CONTAINSWITHIN
        • IF
        • IFS
        • IIF
        • IN
        • IFNULL
        • ISBOOLEAN
        • ISDECIMAL
        • ISDURATION
        • ISINTEGER
        • ISNULL
        • ISNUMBER
        • ISSTRING
        • ISUNIQUE
        • NOT
        • NULL
        • OR
        • SWITCH
        • ALL
          • TOSTRING
        • ANY
      • Math Functions
        • ABS
        • ACOS
        • ASIN
        • ATAN
        • ATAN2
        • CEILING
        • COS
        • COT
        • COSEC
        • DEGREES
        • DIV
        • EVEN
        • EXPONENTIAL
        • FILLINFINITY
        • FLOOR
        • HAVERSINE
        • LOG
        • LN
        • ODD
        • MODULO
        • PERCENTILEOFVALUE
        • PERCENTILEVALUE
        • PI
        • POWER
        • RADIANS
        • RANDOM
        • ROUND
        • SEC
      • Table Functions
        • ENCODE
        • INDEX
        • INDEXBY
        • FILLNULL
        • FIRSTBY
        • GENERATEUNIQUEID
        • LASTBY
        • LOOKUP
        • MATCH
        • NTH
        • OFFSET
        • OFFSETBY
        • PREVIOUSVALUE
        • RANK
        • RANKBY
        • RECORDID
        • ROLLINGAVERAGE
        • ROW
        • RUNNINGAVERAGE
        • RUNNINGMAX
        • RUNNINGMIN
        • RUNNINGSTDEV
        • RUNNINGTOTAL
        • WINDOWAVERAGE
        • WINDOWMAX
        • WINDOWMIN
        • WINDOWCOUNT
        • WINDOWSUM
        • SEQUENCE
        • WINDOWMEDIAN
        • WINDOWSTDEV
        • WINDOWSTDEVP
        • WINDOWSTDEVS
        • WINDOWVAR
        • WINDOWVARP
        • WINDOWVARS
        • WINDOWCORR
        • WINDOWCOVAR
        • WINDOWCOVARP
        • WINDOWCOVARS
        • SMOOTHEDAVERAGE
      • Text Functions
        • ASCII
        • CHAR
        • CONCAT
        • CONTAINS
        • ENDSWITH
        • FIND
        • FINDNTH
        • ISEMPTY
        • JSONPARSE
        • LEFT
        • LENGTH
        • LOWER
        • LTRIM
        • MID
        • PROPER
        • RIGHT
        • RTRIM
        • SPACE
        • SPLIT
        • STARTSWITH
        • TRIM
        • SUBSTITUTE
        • UPPER
    • Building Expressions
      • Expression Operators
      • Guide to Window Functions
  • Cascade FAQs
    • Best Practices
      • 💬How to add a total row to a table
      • 💬How to leave comments on a workflow
      • 💬How to add new columns in the Edit Columns tool
      • 💬Setting up a New Table tool
      • 💬How to rename a tool
    • Knowledge Based
      • 💬How to change Data Types in Cascade
      • 💬How to remove columns from a table in Cascade
      • 💬How to rename columns in Cascade
      • 💬Understanding the Join options in the Cascade Join tool
      • 💬How to connect tools to each other
    • Import
      • 💬How to Import an Excel File into Cascade
      • 💬How to Import a CSV File into Cascade
      • 💬How to import a CSV file into the Data Locker
    • Functions and Expressions
      • 💬How to write an IN() statement with multiple variables
      • 💬How to Remove null Records with a Filter tool
      • 💬How to write an IF Statement in Cascade
      • 💬How to replace null values with 0
    • Troubleshooting
      • ⚠️What does it mean if my workflow won’t load?
      • ⚠️Why can’t I connect my tool to other tools?
      • ⚠️Why are there duplicate records after my Join tool?
  • Change Log
On this page
  • Publishing to Data Locker
  • Uploading to Data Locker
  • Importing from Data Locker
  • File/Folder Management

Was this helpful?

  1. Workflows

Data Locker

PreviousGlobal VariablesNextScheduling

Last updated 2 years ago

Was this helpful?

The Cascade Data Locker is an ideal place to store data coming in-to and out-of your workflows. From any workflow, add the tool to your canvas, and any connected datasets will be forwarded to the Data Locker. Inversely, the tool will pull a dataset from the Data Locker and make it available on any workflow canvas. In brief, Data Locker is a simple file storage system, accessible by any team member in the workspace.

Publishing to Data Locker

Uploading to Data Locker

  1. Navigate to the Data Locker section in your workspace. Or to a folder in Data Locker, where you intend to upload your file.

  2. Click on Add File.

  3. Confirm your file type, header rows, and delimiters. Please note, only CSV and Parquet files are currently supported.

  4. Simply drag & drop your file. Or click on the drop-zone to select a file from your operating system's menu.

  5. Click Upload.

The process of uploading may take some time depending on the size of the file. Please do not close the tab or navigate away from the page to other pages in the workspace while the upload is ongoing.

Once the file has uploaded successfully, it may take a few additional minutes to process in the background before it can be used in a workflow.

Importing from Data Locker

Simply select the dataset you would like to import from the configuration panel on the right hand side of the tool. Select multiple datasets to create a set of sheets. They will behave as any other Import tool.

File/Folder Management

Data Locker is a simple file/folder management system. New folders can be created from a workflow, but can also be added manually, from the menu icon in the header of Data Locker.

Files and folders can be renamed, moved, or deleted using the context menu associated with each file or folder in the Data Locker table.

To find the source workflow (or origin) of a file, click on the source link in the Data Locker table. The source workflow will open in a new browser tab.

Note: If you change file name or folder names from Data Locker, datasets being published there will not update. A new dataset will be created instead. We recommend using the Publish to Data Locker tool on you workflow canvas to make changes.

Use the tool to send any connected dataset(s) from the workflow to the Data Locker. Each time you run your workflow, it will publish again, updating the dataset(s). Most users will publish tabular data to the locker. However charts, models, validations, and JSON can all be sent to the Data Locker for storage.

Name: Required, this field will rename the dataset you are sending to the Data Locker. Any on your canvas can be templated into the name.

Description: Optional, this field will provide a description for the the dataset published to the Data Locker. Any on your canvas can be templated into the description.

Destination: If left blank, the tool will publish to the root directory of Data Locker. If a folder-name is provided, the published dataset(s) will be placed into a folder, in your Data Locker. Any on your canvas can be templated into name of the destination folder.

You may choose to upload files directly to the Data Locker, outside of the context of you workflow. This can be helpful in cases where data from a file will be used in multiple workflows, or when the size of the file is larger than the tool can support.

Use the tool to fetch a dataset (or datasets) from the Data Locker, making it available on your workflow canvas.

Publish to Data Locker
Global Variables
Global Variables
Global Variables
Import File
Import from Data Locker
Publish to Data Locker
Import from Data Locker
User publishing a dataset to the Data Locker, with datetime appended, assigned to a folder based on a Global Variable
User uploading a CSV file directly to Data Locker