Aggregate
Group data and apply aggregation methods or pivot operations
Group data and apply aggregation methods or pivot operations
Avro
CSV
DB2
Remove rows with duplicate values of specified columns
Delta
Delta
Filter your data based on a custom filter condition
Fixed Format
Read from or write to Tables managed by a Hive metastore
JDBC
Join one or more DataFrames on conditions
JSON
Reading and writing data from Apache Kafka in batch mode
Limit the number of rows
Lookup
Oracle
ORC
Sort your data based on one or more Columns
Parquet
Redshift
Select one or more columns or values using expressions and functions.
Repartition
Create multiple DataFrames based on filter conditions
Add, Edit, Rename or Drop Columns
Union, Intersect and Difference
Snowflake
Create DataFrames based on custom SQL queries
Teradata
Text
Aggregate and transform Windowed data
Explore the basics of working with XLSX (Excel) files with Prophecy
XLSX (Excel)