Skip to content
PlaidCloud
Search
Ctrl
K
Cancel
GitHub
Select theme
Dark
Light
Auto
Get started
Overview
Quickstart
Platform Architecture
Concepts
Tutorials
FAQ
Guides
Overview
AI Assistant
Using the AI Assistant
Fixing Workflow Errors with AI
Generating SQL Extract Steps with AI
AI Assistant
Allocations
Overview
Getting started
Getting Started
Allocations Quick Start
Rule Based Tagging
Why are Allocations Useful
Setup
Configure an Allocation
Configure Allocations
Recursive and Reciprocal Allocations
Results & troubleshooting
Allocation Results
Troubleshooting Allocations
Results and Troubleshooting
Analyze With an AI Agent
Connections
Create and Manage a Connection
Clone a Connection
Singer Sources
PlaidCloud Git Connection
Connections
Dashboards
Learning About Dashboards
Using Dashboards
Formatting Numbers and Other Data Types
Example Calculated Columns
Example Metrics
Dashboard Caching
Dashboards
Data
Selecting the Latest Record in a Large Version History Table
Using Tables and Views
Table Explorer
Currency Data Type
Publishing Tables
Table Snapshots
Data Management - Tabular
Dimensions
Getting Started with Dimensions
Using Dimensions (Hierarchies)
Dimension Functions for Expressions and Aggregations
Loading and Unloading Dimensions
Data Management - Dimensions
Documents
Overview
Account management
Control Document Account Access
Account and Access Management
Document Temporary Storage
Managing Document Account Backups
Managing Document Account Owners
Using Start Paths in Document Accounts
Adding accounts
Adding New Document Accounts
Add AWS S3 Account
Add Google Cloud Storage Account
Add a PlaidCloud Managed Bucket Account
Add Wasabi Hot Storage Account
Add OneDrive / SharePoint Account
Add Azure Blob Storage Account
Add Azure Data Lake Gen2 Account
Add MinIO Account
Add Backblaze B2 Account
Add Cloudflare R2 Account
Add DigitalOcean Spaces Account
Add Linode Object Storage Account
Add Google Drive Account
Add SFTP Account
Add WebDAV Account
Add FTP Account
Searching documents
Using documents
Email
Using the Email Area
Email
Help & Support
Getting Help
The Support Console
Managing Support
Help & Support
Launcher
Panel apps
Deploy a Panel App From PlaidCloud Git
Creating a Panel App
Using a Panel App
Reading Data and the Signed-In User
Panel Apps
PlaidCloud Git
Overview
Repositories
Issues
Pull Requests
Project Boards
Releases and Tags
Wikis
Packages
Searching Code
Projects
Viewing Projects
Managing Projects
Managing Tables and Views
Managing Hierarchies
Managing Data Editors
Archive a Project
Viewing the Project Log
Compare and Merge Projects
Export to Portable Format
Labels
Projects
Sandbox
Getting Started with the Custom App Sandbox
Custom App Sandbox
Workflows
Where are the Workflows
Workflow Explorer
Create Workflow (Guide)
Duplicate or Clone a Workflow
Copy & Paste steps
Change the order of steps in a workflow
Run a workflow
Running one step in a workflow
Running a range of steps in a workflow
Managing Step Errors
Continue on Error
Skip steps in a workflow
Create a Macro
Prettify (Format) Code in Editors
Conditional Step Execution
Controlling Parallel Execution
Column Propagation
Manage Workflow Variables
Viewing Workflow Log
View Workflow Report
View a dependency audit
LLM Step
Advanced Workflows
Preview Step Data
REST Request Step
Multi-Table Join Step
Step Numbers
Migrate Alteryx Workflows
Validate Converted Alteryx Workflows
Alteryx Migration Readiness Checklist
Package Alteryx Dependencies
Convert .yxdb Files for Import
Use Converted Alteryx Apps
Tune Alteryx Imports
Geospatial Analytics
Validate Alteryx Reports And Artifacts
Migrate Spatial Alteryx Workflows
Orchestrate Alteryx Migrations With MCP
Workflows
Reference
Overview
Connectors
Workflow steps
Expressions
CLI
Glossary
Integrations
Overview
AI and LLM Architecture
Overview
LLM Providers
Copilot Architecture
Retrieval and RAG
Your Own LLM
Microsoft 365 Copilot
AI coding agents
Getting Started with AI Coding Agents
Claude Code
Claude Desktop and Claude.ai
Cursor
GitHub Copilot
Google Gemini CLI
ChatGPT
Tracing Allocations
Answers You Can Trust
Analysis Paths
Troubleshooting
AI Agents (MCP)
PySpark
Getting Started with PySpark
PySpark and Spark Compute Clusters
Administration
Overview
Access management
Overview
Organization & workspaces
Overview
Organizations and Workspaces Explained
Viewing and Managing Workspaces
Managing Workspace Members
Member authentication
Member Authentication
Member management
Member Management
Member identity
Member (User) Identity
Security groups
Managing Security Groups and Assignments
Advanced (SSO/SAML)
Advanced Operations
Setting Up Auth0 SAML for Single Sign-On
Setting Up AWS IAM Identity Center SAML for Single Sign-On
Setting Up Microsoft Entra ID SAML for Single Sign-On
Setting Up Google Workspace SAML for Single Sign-On
Manage Organization Administrators
Managing Single Sign-On for Organization
Setting Up Okta SAML for Single Sign-On
Setting Member Expiration Period
Control plane
Control Plane
Organizations
Workspace Configuration
Scheduled events
Scheduled Workflows
Event Scheduler
Upcoming Runs Calendar
What's new
GitHub
Select theme
Dark
Light
Auto
Reference
Expressions
Lakehouse v1 Expressions
Conditional Functions (Lakehouse v1)
This section provides reference information for the conditional functions in PlaidCloud Lakehouse.
Functions
Section titled “Functions”
AND
CASE
COALESCE
Comparison Methods
ERROR_OR
GREATEST
IF
IFNULL
IS [ NOT ] DISTINCT FROM
IS_ERROR
IS_NOT_ERROR
IS_NOT_NULL
IS_NULL
LEAST
NULLIF
NVL
NVL2
OR
[ NOT ] BETWEEN
[ NOT ] IN
