Agent chat
Chat with our AI agent to generate pipelines
Chat with our AI agent to generate pipelines
How Prophecy uses AI to help with pipeline development
Group and pivot your data
Expand or contracts the boundaries of a polygon or line
Create geographic points with longitude and latitude coordinates
Standardize data formats
Remove duplicates from your data
Calculate the distance between two points
Dynamically filter columns of your dataset based on a set of conditions
Send your pipeline output tables to others via email
Fix gems errors with one click
Find data sources using Prophecy's AI agent
Filter the data
Identify the shortest distance between spatial objects
Flatten nested columns
Build functions with SQL macros to be used in gem expressions
Match records that are not exactly identical
Generate documentation throughout your pipeline to improve transparency
Power your pipelines with gems
Automatically generate expressions with natural language
Generate spatial heatmaps from geo point data using hexagons
Join two or more datasets
Parse JSON inside a table
Limit the number of columns processed
Use dbt macros in your pipelines
Change the data type of multiple columns at once
Rename multiple columns in your dataset in a systematic way
Sort the data
Introduction to pipeline development for analysts
Add variables to your pipelines
Use pipelines in SQL projects
Convert your table from long to wide format
Create a polygon or polyline from a set of coordinates
Send your pipeline output directly to PowerBI
Explore the SQL Project Editor interface
Use Prophecy and SQL to run pipelines
Use expressions to reformat column names and values
Call APIs from your pipeline
View detailed information about each operation performed during a pipeline run
Leverage a Python script in your pipeline
Decrease the number of nodes that make up a polygon or polyline
Find relationships between geographic features
Use a custom SQL statement
Create and call stored procedures to use in pipelines
Send data to automatically update your Tableau dashboards
Convert text into a column in your table
Create a placeholder gem in your pipeline
Transform data sources using Prophecy's AI agent
Convert your table from wide to long format
Convert your table from wide to long format
Create moving aggregations and transformation
Parse XML inside a table