Skip to content
Product
Pricing
Solutions
Transfer Pricing for Goods & Services
Customer & Product Profitability
Bill of Materials Costing and Forecasting
Cost to Serve
Robotic Process Automation
Marketing & Sales
Resources
Documentation
API
Help
Manage Account
Company Blog
Engineering Blog
Global Datacenters
Terms of Service
Privacy Policy
Security
Sign-In
Search for:
Product
Pricing
Solutions
Transfer Pricing for Goods & Services
Customer & Product Profitability
Bill of Materials Costing and Forecasting
Cost to Serve
Robotic Process Automation
Marketing & Sales
Resources
Documentation
API
Help
Manage Account
Company Blog
Engineering Blog
Global Datacenters
Terms of Service
Privacy Policy
Security
Sign-In
Search for:
Product
Pricing
Solutions
Transfer Pricing for Goods & Services
Customer & Product Profitability
Bill of Materials Costing and Forecasting
Cost to Serve
Robotic Process Automation
Marketing & Sales
Resources
Documentation
API
Help
Manage Account
Company Blog
Engineering Blog
Global Datacenters
Terms of Service
Privacy Policy
Security
Sign-In
PlaidCloud
Home
/
PlaidCloud
Home
Documentation
PlaidCloud
PlaidCloud
Getting Started
Dashboards
Dashboards
Learning Dashboard
Documents
Document
File and Folder Management
Managing Accounts
Temporary Storage
Identity
Identity
Managing Security
Member Authentication
Member Management
Organization & Workspaces
Organizations
Organizations and Workspaces
Workspaces
Projects
Archives
Managing Data Editors
Managing Hierarchies
Managing Projects
Managing Tables
Project Log
Projects
Tools
Data Connections
Event Scheduler
Message Queues
PlaidLink Agents
Tools
Workflows
Agent Remote Execution of SQL
Agent Remote Export of SQL Result
Agent Remote Import Table into SQL Database
Aggregation
Allocation Split
Allocation Split Filter
Calculate PCM Model
Call SAP Financial Document Attachment
Call SAP General Ledger Posting
Call SAP Master Data Table RFC
Call SAP RFC
Clear Workflow Log
Common Transform Elements
Convert Document Encoding
Convert Document Encoding to ASCII
Convert Document Encoding to UTF-16
Convert Document Encoding to UTF-8
Copy Document Directory
Copy Document File
Copy SAP PCM Model
Copy SAP PCM Period
Copy SAP PCM Version
Copy Workflow
Create Document Directory
Create SAP PCM Model
Create Workflow
Data Filters
Delete Document Directory
Delete Document File
Delete SAP PCM Model
Delete Workflow
Document – Remote Delete File
Document – Remote Export File
Document – Remote Import File
Document – Remote Rename File
Document Text Substitution
Duplicates
Export HTML
Export Quandl
Export SPSS
Export SQL
Export Stata
Export Table Archive
Export to CSV
Export to Excel
Export to Google BigQuery
Export to Google Spreadsheet
Export to HDF
Export to Json
Export XML
Final Data Table Slicing (Limit)
Import CSV
Import Excel
Import Fixed Width
Import Google BigQuery
Import Google Spreadsheet
Import HDF
Import HTML
Import JSON
Import Quandl
Import SAS7BDAT
Import SPSS
Import SQL
Import Stata
Import Table Archive
Import XML
Machine Learning
Notify Agent
Notify Distribution Group
Notify Via Email
Notify Via Log
Notify Via SMS
Notify Via Twitter
Notify Via Web Hook
Output File Type
Pass
Rename Document Directory
Rename Document File
Rename SAP PCM Model
Rename Workflow
Report Batch
Report Single
Run App Operation
Run Remote Python
Run SAP PCM Console Job
Run SAP PCM Hyper Loader
Run Workflow
Run Workflow Conditionally
Select Subset of Final Data
Select Subset of Source Data
Set Project Variable
Set Workflow Variable
Source and Target
Source Table Slicing (Limit)
Stop Loop
Stop PCM Model Calculation
Stop Workflow
Table Anti Join
Table Clear
Table Copy
Table Data Selection
Table Extract
Table Faker
Table In-Place Delete
Table In-Place Update
Table Inner Join
Table Loader
Table Lookup
Table Melt
Table Outer Join
Table Pivot
Table Split
Table Union All
Table Union Distinct
Transforms – Allocation
Transforms – Document Management
Transforms – Export
Transforms – Import
Transforms – Notification
Transforms – Other
Transforms – Remote Operations
Transforms – Report
Transforms – SAP Integration
Transforms – SAP PCM Integration
Transforms – Table
Transforms – User Defined
Transforms – Workflow Control
User Defined Transform – Workflow Step Definition
Wait
Workflows
Jupyter
Jupyter
Jupyter Console
Jupyter Notebook
JupyterLab
Expression & Filter Functions | General Usage
Conditionals
Data Type Expressions
Dates and Time Expressions
Expressions
Filters
Mathematics Expressions
PostGIS
Text Expressions
Expressions & Filter Functions | Arrays
func.string_to_array
func.unnest
Expressions & Filter Functions | Conditions
and_
case
func.coalesce
not_
or_
Expressions & Filter Functions | Conditions on Columns
column.any_
column.between
column.contains
column.endswith
column.ilike
column.in_
column.is_
column.isnot
column.like
column.notilike
column.notin_
column.notlike
column.startswith
Expressions & Filter Functions | Conversions
cast
func.to_char
func.to_date
func.to_number
func.to_timestamp
Expressions & Filter Functions | Dates
func.age
func.clock_timestamp
func.current_date
func.current_time
func.current_timestamp
func.date_part
func.date_trunc
func.extract
func.isfinite
func.justify_days
func.justify_hours
func.justify_interval
func.now
func.statement_timestamp
func.timeofday
func.transaction_timestamp
Expressions & Filter Functions | JSON
array_to_json
json_array_elements
json_each
json_each_text
json_extract_path
json_extract_path_text
json_object_keys
Expressions & Filter Functions | Math
func.abs
func.cbrt
func.ceil
func.ceiling
func.degrees
func.exp
func.floor
func.greatest
func.least
func.ln
func.log
func.mod
func.pi
func.power
func.radians
func.random
func.round
func.safe_divide
func.setseed
func.sign
func.sqrt
func.trunc
func.width_bucket
Expressions & Filter Functions | PostGIS
func.Box2D
func.Box3D
func.Find_SRID
func.GeometryType
func.ST_3DClosestPoint
func.ST_3DDFullyWithin
func.ST_3DDWithin
func.ST_3DExtent
func.ST_3DIntersects
func.ST_3DLength
func.ST_3DLongestLine
func.ST_3DMakeBox
func.ST_3DMaxDistance
func.ST_3DPerimeter
func.ST_3DShortestLine
func.ST_Accum
func.ST_AddMeasure
func.ST_AddPoint
func.ST_Affine
func.ST_Area
func.ST_AsBinary
func.ST_AsEncodedPolyline
func.ST_AsEWKB
func.ST_AsEWKT
func.ST_AsGeoJSON
func.ST_AsGML
func.ST_AsHEXEWKB
func.ST_AsKML
func.ST_AsLatLonText
func.ST_AsSVG
func.ST_AsText
func.ST_AsTWKB
func.ST_AsX3D
func.ST_Azimuth
func.ST_BdMPolyFromText
func.ST_BdPolyFromText
func.ST_Boundary
func.ST_BoundingDiagonal
func.ST_Box2dFromGeoHash
func.ST_Buffer
func.ST_BuildArea
func.ST_Centroid
func.ST_ClipByBox2D
func.ST_ClosestPoint
func.ST_ClosestPointOfApproach
func.ST_ClusterIntersecting
func.ST_ClusterWithin
func.ST_Collect
func.ST_CollectionExtract
func.ST_CollectionHomogenize
func.ST_ConcaveHull
func.ST_Contains
func.ST_ContainsProperly
func.ST_ConvexHull
func.ST_CoordDim
func.ST_CoveredBy
func.ST_Covers
func.ST_CPAWithin
func.ST_Crosses
func.ST_CurveToLine
func.ST_DelaunayTriangles
func.ST_DFullyWithin
func.ST_Difference
func.ST_Dimension
func.ST_Disjoint
func.ST_Distance
func.ST_DistanceCPA
func.ST_DistanceSpheroid
func.ST_Dump
func.ST_DumpPoints
func.ST_DumpRings
func.ST_DWithin
func.ST_EndPoint
func.ST_Envelope
func.ST_Equals
func.ST_EstimatedExtent
func.ST_Expand
func.ST_Extent
func.ST_ExteriorRing
func.ST_FlipCoordinates
func.ST_Force2D
func.ST_Force3D
func.ST_Force3DM
func.ST_Force3DZ
func.ST_Force4D
func.ST_ForceCollection
func.ST_ForceCurve
func.ST_ForceRHR
func.ST_ForceSFS
func.ST_GeogFromText
func.ST_GeogFromWKB
func.ST_GeographyFromText
func.ST_GeoHash
func.ST_GeomCollFromText
func.ST_GeometryFromText
func.ST_GeometryN
func.ST_GeometryType
func.ST_GeomFromEWKB
func.ST_GeomFromEWKT
func.ST_GeomFromGeoHash
func.ST_GeomFromGeoJSON
func.ST_GeomFromGML
func.ST_GeomFromKML
func.ST_GeomFromText
func.ST_GeomFromWKB
func.ST_GMLToSQL
func.ST_HasArc
func.ST_HausdorffDistance
func.ST_InteriorRingN
func.ST_InterpolatePoint
func.ST_Intersection
func.ST_Intersects
func.ST_IsClosed
func.ST_IsCollection
func.ST_IsEmpty
func.ST_IsRing
func.ST_IsSimple
func.ST_IsValid
func.ST_IsValidDetail