Skip to main content

52 docs tagged with "analyst"

View all tags

Agent chat

Chat with our AI agent to generate pipelines

Agents and AI

How Prophecy uses AI to help with pipeline development

Buffer

Expand or contracts the boundaries of a polygon or line

CreatePoint

Create geographic points with longitude and latitude coordinates

Distance

Calculate the distance between two points

DynamicSelect

Dynamically filter columns of your dataset based on a set of conditions

Email

Send your pipeline output tables to others via email

FindNearest

Identify the shortest distance between spatial objects

Functions

Build functions with SQL macros to be used in gem expressions

FuzzyMatch

Match records that are not exactly identical

Gems

Power your pipelines with gems

HeatMap

Generate spatial heatmaps from geo point data using hexagons

Join

Join two or more datasets

Limit

Limit the number of columns processed

Macro

Use dbt macros in your pipelines

Pivot

Convert your table from long to wide format

PolyBuild

Create a polygon or polyline from a set of coordinates

Reformat

Use expressions to reformat column names and values

RestAPI

Call APIs from your pipeline

Runtime logs

View detailed information about each operation performed during a pipeline run

Script

Leverage a Python script in your pipeline

Simplify

Decrease the number of nodes that make up a polygon or polyline

TableauWrite

Send data to automatically update your Tableau dashboards

ToDo

Create a placeholder gem in your pipeline

Transpose

Convert your table from wide to long format

Unpivot

Convert your table from wide to long format