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
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
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
Join two or more datasets
Parse JSON inside a table
Limit the number of columns processed
Find more information about the success of failure of different operations
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
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.
Leverage a Python script in your pipeline
Use a custom SQL statement
Send data to automatically update your Tableau dashboards
Convert text into a column in your table
Transform data sources using Prophecy's AI agent
Convert your table from wide to long format
Create moving aggregations and transformation
Parse XML inside a table