Documentation
APIs
IAM
Tips & Tricks
Versions
Release Information
Production
Beta
Development
Allocation Assignments
Projects
Archive a Project
Managing Data Editors
Managing Hierarchies
Managing Projects
Managing Tables and Views
Viewing Projects
Viewing the Project Log
Allocation Assignments
Getting Started
Why are Allocations Useful
Allocations Quick Start
Results and Troubleshooting
Allocation Results
Troubleshooting Allocations
Configure Allocations
Configure an Allocation
Recursive Allocations
Workflows
Conditional Step Execution
Change the order of steps in a workflow
Continue on Error
Copy & Paste steps
View a dependency audit
Controlling Parallel Execution
Create Workflow
Duplicate a Workflow
Manage Workflow Variables
Managing Step Errors
Run a workflow
Running a range of steps in a workflow
Running one step in a workflow
Skip steps in a workflow
View Workflow Report
Viewing Workflow Log
Viewing Workflows
Workflow Steps
Allocation By Assignment Dimension
Allocation Split
Rule-Based Tagging
Agent Steps
Document - Remote Delete File
Document - Remote Export File
Document - Remote Import File
Document - Remote Rename File
Agent Remote Execution of SQL
Agent Remote Export of SQL Result
Agent Remote Import Table into SQL Database
Common Step Operations
Advanced Data Mapper Usage
Dimension Steps
Dimension Clear
Dimension Create
Dimension Delete
Dimension Load
Dimension Sort
Document Steps
Compress PDF
Concatenate Files
Convert Image to PDF
Convert PDF or Image to JPEG
Crop Image to Headshot
Fix File Extension
Merge Multiple PDFs
Rename Document Directory
Rename Document File
Create Document Directory
Convert Document Encoding to UTF-16
Convert Document Encoding to UTF-8
Delete Document Directory
Delete Document File
Convert Document Encoding
Convert Document Encoding to ASCII
Copy Document Directory
Copy Document File
Document Text Substitution
Export Steps
Export to External Project Table
Export to XML
Export to CSV
Export to Excel
Export to Google Spreadsheet
Export to HDF
Export to HTML
Export to JSON
Export to Quandl
Export to SQL
Export to Table Archive
General Steps
Pass
Run Remote Python
User Defined Transform
Wait
Import Steps
Import Archive
Import Project Table
Import External Database Tables
Import Google BigQuery
Import Google Spreadsheet
Import HDF
Import HTML
Import JSON
Import Quandl
Import SAS7BDAT
Import SPSS
Import SQL
Import Stata
Import XML
Import CSV
Import Excel
Import Fixed Width
Notification Steps
Notify Agent
Notify via Microsoft Teams
Notify Distribution Group
Notify Via Email
Notify Via Log
Notify Via SMS
Notify Via Twitter
Notify Via Web Hook
Notify via Slack
PDF Reporting Steps
Report Single
Reports Batch
SAP ECC and S/4HANA Steps
Call SAP Financial Document Attachment
Call SAP General Ledger Posting
Call SAP Master Data Table RFC
Call SAP RFC
SAP PCM Steps
Create SAP PCM Model
Delete SAP PCM Model
Calculate PCM Model
Copy SAP PCM Model
Copy SAP PCM Period
Copy SAP PCM Version
Rename SAP PCM Model
Run SAP PCM Console Job
Run SAP PCM Hyper Loader
Stop PCM Model Calculation
Table Steps
Table Cross Join
Table Drop
Table Upsert
Table Clear
Table Copy
Table In-Place Delete
Table In-Place Update
Table Anti Join
Table Extract
Table Faker
Table Inner Join
Table Lookup
Table Melt
Table Outer Join
Table Pivot
Table Union All
Table Union Distinct
Table Append
Workflow Control Steps
Run Workflow
Set Project Variable
Set Workflow Variable
Create Workflow
Delete Workflow
Clear Workflow Log
Copy Workflow
Raise Workflow Error
Rename Workflow
Stop Workflow
Worklow Loop
Dashboards
Learning About Dashboards
Using Dashboards
Example Calculated Columns
Example Metrics
Dashboard Example Expressions
Data Management
Table Explorer
Publishing Tables
Using Tables and Views
Using Dimensions (Hierarchies)
Document
Using Document
Account and Access Management
Control Document Account Access
Document Temporary Storage
Managing Document Account Backups
Managing Document Account Owners
Using Start Paths in Document Accounts
Adding New Document Accounts
Add AWS S3 Account
Add Google Cloud Storage Account
Add Wasabi Hot Storage Account
External Data Source and Service Connectors
Data Connections
Data Warehouse Service
Getting Started
Pricing
Greenplum Technical Resource Links
Jupyter and Command Line
Command Line
Jupyter Notebooks
OAuth Tokens
Standard Expressions
General Usage Conditionals
General Usage Data Type Expressions
General Usage Dates and Time Expressions
General Usage Filters
General Usage Mathematics Expressions
General Usage PostGIS
General Usage Text Expressions
Arrays
func.string_to_array
func.unnest
Column Conditions
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
Conditions
case
func.coalesce
not_
and_
or_
Conversions
cast
func.to_char
func.to_date
func.to_number
func.to_timestamp
Date and Time
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
Grouping and Summarization
func.first
func.last
func.max
func.median
func.stdev
func.stdev_pop
func.stdev_samp
func.var_pop
func.var_samp
func.variance
JSON
func.array_to_json
func.json_array_elements
func.json_each
func.json_each_text
func.json_extract_path
func.json_extract_path_text
func.json_object_keys
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
Text
func.trim
func.translate
func.substring
func.strpos
func.rtrim
func.rpad
func.replace
func.repeat
func.regexp_replace
func.quote_literal
func.octet_length
func.numericize
func.md5
func.ltrim
func.lpad
func.lower
func.length
func.integerize_truncate
func.integerize_round
func.initcap
func.concat
func.chr
func.char_length
func.btrim
func.upper
func.bit_length
func.ascii
func.metric_multiply
func.split_part
func.text_to_bigint
func.text_to_bool
func.text_to_integer
func.text_to_numeric
func.text_to_smallint
func.to_ascii
func.to_hex
Trigonometry
func.acos
func.asin
func.atan
func.atan2
func.cos
func.cot
func.sin
func.tan
Window Functions
func.avg
func.count
func.cume_dist
func.dense_rank
func.first_value
func.lag
func.last_value
func.lead
func.min
func.ntile
func.percent_rank
func.rank
func.row_number
func.sum
PostGIS Expressions (Geospatial)
Affine Transformations
func.ST_TransScale
func.ST_Translate
func.ST_Scale
func.ST_RotateZ
func.ST_RotateY
func.ST_RotateX
func.ST_Rotate
func.ST_Affine
Bounding Box Functions
func.ST_ZMin
func.ST_ZMax
func.ST_YMin
func.ST_YMax
func.ST_XMin
func.ST_XMax
func.ST_3DMakeBox
func.ST_MakeBox2D
func.ST_3DExtent
func.ST_Extent
func.ST_Expand
func.ST_EstimatedExtent
func.Box3D
func.Box2D
Clustering Functions
func.ST_ClusterWithin
func.ST_ClusterIntersecting
Geometry Accessors
func.ST_Zmflag
func.ST_Z
func.ST_Y
func.ST_X
func.ST_Summary
func.ST_StartPoint
func.ST_PointN
func.ST_PatchN
func.ST_NumPoints
func.ST_NumPatches
func.ST_NumInteriorRing
func.ST_NumInteriorRings
func.ST_NumGeometries
func.ST_NRings
func.ST_NPoints
func.ST_NDims
func.ST_MemSize
func.ST_M
func.ST_IsSimple
func.ST_IsRing
func.ST_IsCollection
func.ST_IsClosed
func.ST_InteriorRingN
func.ST_HasArc
func.ST_GeometryN
func.ST_ExteriorRing
func.ST_Envelope
func.ST_BoundingDiagonal
func.ST_EndPoint
func.ST_DumpRings
func.ST_DumpPoints
func.ST_Dump
func.ST_Dimension
func.ST_CoordDim
func.ST_Boundary
func.ST_GeometryType
func.ST_IsEmpty
Geometry Constructors
func.ST_Collect
func.ST_LineFromMultiPoint
func.ST_MakeEnvelope
func.ST_MakeLine
func.ST_MakePoint
func.ST_MakePointM
func.ST_MakePolygon
func.ST_Point
func.ST_Polygon
Geometry Editors
func.ST_SwapOrdinates
func.ST_Snap
func.ST_SnapToGrid
func.ST_ShiftLongitude
func.ST_SetPoint
func.ST_Segmentize
func.ST_Reverse
func.ST_RemoveRepeatedPoints
func.ST_RemovePoint
func.ST_Multi
func.ST_LineToCurve
func.ST_LineMerge
func.ST_ForceCurve
func.ST_ForceRHR
func.ST_ForceSFS
func.ST_ForceCollection
func.ST_Force4D
func.ST_Force3DM
func.ST_Force3DZ
func.ST_Force3D
func.ST_Force2D
func.ST_FlipCoordinates
func.ST_CurveToLine
func.ST_CollectionHomogenize
func.ST_CollectionExtract
func.ST_AddPoint
Geometry Input
func.ST_PointFromGeoHash
func.ST_LineFromEncodedPolyline
func.ST_GMLToSQL
func.ST_GeomFromKML
func.ST_GeomFromGeoJSON
func.ST_GeomFromGML
func.ST_GeomFromGeoHash
func.ST_Box2dFromGeoHash
func.ST_WKBToSQL
func.ST_PointFromWKB
func.ST_LinestringFromWKB
func.ST_LineFromWKB
func.ST_GeomFromWKB
func.ST_GeomFromEWKB
func.ST_GeogFromWKB
func.ST_WKTToSQL
func.ST_PolygonFromText
func.ST_PointFromText
func.ST_MPolyFromText
func.ST_MPointFromText
func.ST_MLineFromText
func.ST_LineFromText
func.ST_GeomFromText
func.ST_GeometryFromText
func.ST_GeomFromEWKT
func.ST_GeomCollFromText
func.ST_GeographyFromText
func.ST_GeogFromText
func.ST_BdMPolyFromText
func.ST_BdPolyFromText
func.GeometryType
Geometry Output
func.ST_GeoHash
func.ST_AsX3D
func.ST_AsSVG
func.ST_AsTWKB
func.ST_AsLatLonText
func.ST_AsKML
func.ST_AsGML
func.ST_AsGeoJSON
func.ST_AsEncodedPolyline
func.ST_AsHEXEWKB
func.ST_AsEWKB
func.ST_AsBinary
func.ST_AsText
func.ST_AsEWKT
Geometry Processing
func.ST_SetEffectiveArea
func.ST_SimplifyVW
func.ST_SimplifyPreserveTopology
func.ST_Simplify
func.ST_SharedPaths
func.ST_Polygonize
func.ST_PointOnSurface
func.ST_OffsetCurve
func.ST_MinimumBoundingCircle
func.ST_DelaunayTriangles
func.ST_ConvexHull
func.ST_ConcaveHull
func.ST_Centroid
func.ST_BuildArea
func.ST_Buffer
func.St_Accum
Geometry Validation
func.ST_MakeValid
func.ST_IsValidReason
func.ST_IsValidDetail
func.ST_IsValid
Linear Referencing
func.ST_AddMeasure
func.ST_InterpolatePoint
func.ST_LocateBetweenElevations
func.ST_LocateBetween
func.ST_LocateAlong
func.ST_LineSubstring
func.ST_LineLocatePoint
func.ST_LineInterpolatePoint
Measurement Functions
func.ST_ShortestLine
func.ST_Project
func.ST_Perimeter2D
func.ST_Perimeter
func.ST_MaxDistance
func.ST_LongestLine
func.ST_3DShortestLine
func.ST_3DPerimeter
func.ST_3DMaxDistance
func.ST_LengthSpheroid
func.ST_3DLongestLine
func.ST_3DLength
func.ST_Length2D
func.ST_Length
func.ST_HausdorffDistance
func.ST_DistanceSpheroid
func.ST_Distance
func.ST_3DClosestPoint
func.ST_ClosestPoint
func.ST_Azimuth
func.ST_Area
func.ST_Length2D_Spheroid
Overlay Functions
func.ST_UnaryUnion
func.ST_Union
func.ST_SymDifference
func.ST_Subdivide
func.ST_Split
func.ST_Node
func.ST_MemUnion
func.ST_Intersection
func.ST_Difference
func.ST_ClipByBox2D
Spatial Reference System Functions
func.ST_Transform
func.ST_SRID
func.ST_SetSRID
func.Find_SRID
Spatial Relationships
func.ST_PointInsideCircle
func.ST_DWithin
func.ST_DFullyWithin
func.ST_Within
func.ST_Touches
func.ST_RelateMatch
func.ST_Relate
func.ST_OrderingEquals
func.ST_Overlaps
func.ST_Intersects
func.ST_Equals
func.ST_Disjoint
func.ST_LineCrossingDirection
func.ST_3DDWithin
func.ST_Crosses
func.ST_3DDFullyWithin
func.ST_CoveredBy
func.ST_ContainsProperly
func.ST_Covers
func.ST_Contains
func.ST_3DIntersects
Trajectory Functions
func.ST_DistanceCPA
func.ST_CPAWithin
func.ST_ClosestPointOfApproach
func.ST_IsValidTrajectory
MADLib Expressions (ML)
Machine Learning
Data Type Transformations
Array Operations
Encoding Categorical Variables
Low-Rank Matrix Factorization
Matrix Operations
Norms and Distance Functions
Path
Pivot
Sessionize
Single Value Decomposition
Sparse Vectors
Stemming
Deep Learning
PlaidXL
Installation
Connecting
Working with Data
PlaidLink
Upgrade
Configure
Installation
PlaidLink Agents
Scheduled Workflows
Event Scheduler
PlaidCloud Documentation
Allocation Assignments
Allocation Assignments
Getting Started
Results and Troubleshooting
Configure Allocations
Last modified August 15, 2022 at 2:48 PM EST:
Updates Allocation Split (39cff5f)
RSS Feed
Overflow
Print entire section