Pricing

from $0.30 / 1,000 output rows

Try for free

Go to Apify Store

SQL for Datasets: Join, Merge & Dedupe Files

Try for free

Run SQL on Apify datasets and CSV, JSON or Parquet files with DuckDB. Join, merge, dedupe, filter, group and transform data in one query. Presets for dedupe, VLOOKUP join and merge. Only-new-rows mode. Save rows to a dataset or a CSV, JSON or Parquet file.

Pricing

from $0.30 / 1,000 output rows

Rating

0.0

(0)

Developer

Malik Said

Actor stats

Bookmarked

Total users

Monthly active users

2 days ago

Last modified

Categories

Developer tools

Automation

Security

You can access the SQL for Datasets: Join, Merge & Dedupe Files programmatically from your own applications by using the Apify API. You can also choose the language preference from below. To use the Apify API, you’ll need an Apify account and your API token, found in API & Integrations in Apify Console.

Python

JavaScript

CLI

OpenAPI

HTTP

MCP

1from apify_client import ApifyClient
2
3# Initialize the ApifyClient with your Apify API token
4# Replace '<YOUR_API_TOKEN>' with your token.
5client = ApifyClient("<YOUR_API_TOKEN>")
6
7# Prepare the Actor input
8run_input = {
9    "query": """SELECT g.\"Country Name\" AS country,
10       g.\"Country Code\" AS country_code,
11       g.Year AS year,
12       round(g.Value / p.Value) AS gdp_per_person_usd
13FROM gdp g
14JOIN population p USING (\"Country Code\", Year)
15WHERE g.Year = (SELECT max(Year) FROM gdp)
16ORDER BY gdp_per_person_usd DESC""",
17    "fileUrls": [
18        "gdp = https://datahub.io/core/gdp/r/gdp.csv",
19        "population = https://datahub.io/core/population/r/population.csv",
20    ],
21    "maxRows": 100,
22}
23
24# Run the Actor and wait for it to finish
25run = client.actor("maliksaid/sql-over-datasets").call(run_input=run_input)
26
27# Fetch and print Actor results from the run's dataset (if there are any)
28print(f"💾 Check your data here: https://console.apify.com/storage/datasets/{run.default_dataset_id}")
29for item in client.dataset(run.default_dataset_id).iterate_items():
30    print(item)
31
32# 📚 Want to learn more 📖? Go to → https://docs.apify.com/api/client/python/docs/quick-start

SQL Query Tool for Apify Datasets and CSV Files API in Python

The Apify API client for Python is the official library that allows you to use SQL for Datasets: Join, Merge & Dedupe Files API in Python, providing convenience functions and automatic retries on errors.

Install the apify-client

$pip install apify-client

Other API clients include:

SQL for Datasets: Join, Merge & Dedupe Files API in JavaScript

SQL for Datasets: Join, Merge & Dedupe Files API through CLI

SQL for Datasets: Join, Merge & Dedupe Files OpenAPI definition

SQL for Datasets: Join, Merge & Dedupe Files API

Dataset Merge & Dedup Datasets — Filter, Join CSV & Excel

saliga/dataset-merge-dedupe

Merge Apify datasets, CSV, JSON and Excel files or Google Sheets into one table. Clean fields, normalise URLs, extract domains, filter, remove duplicates and join (VLOOKUP) in one run. Works with limited permissions. CSV and Excel exports free. $0.50 per 1,000 output rows.

Salih Küçükkayış

Merge, Dedup & Transform Datasets - Limited permissions

lukaskrivka/dedup-datasets-limited-permissions

Limited permission version of the popular Actor. The ultimate dataset processor. Extremely fast merging, deduplications & transformations all in a single run.

Lukáš Křivka

601

Dataset Aggregate, Group By & Pivot

nerolabs/dataset-aggregate-pivot

Returns GROUP BY and pivot tables for any Apify dataset, file or Google Sheet by URL, or JSON array: count, sum, average, min, max, median per group, date buckets, pivot columns. Exports CSV/Excel, appends to a named dataset, posts to a webhook. Agent-ready: pay per event (x402, MCP), per input row.

Adam Pearce

Merge Datasets & Remove Duplicates — Deduplicate, Filter, Excel

tidydata/merge-dedupe-datasets

Merge datasets and remove duplicates in one call: combine Apify datasets, CSV, Excel, JSON or Google Sheets, dedupe by any field (smart URL/email/phone matching), filter, sort, keep only new rows, export CSV/Excel/JSON. Works from AI agents via Apify MCP (Claude, ChatGPT), n8n and the API.

tidydata

Dataset MCP Uploader

lukaskrivka/dataset-mcp-uploader

Dataset MCP Uploader allows you to process datasets on the Apify platform and then publish the results on other platforms that support the MCP protocol

Lukáš Křivka

XMLs To Dataset

mtrunkat/xmls-to-dataset

Go to actor anytime you need to download XML files and store them in the dataset.

Marek Trunkát

112

Append to dataset

valek.josef/append-to-dataset

Utility actor that allows you to build a single large dataset from individual default datasets of other actor runs.

Josef Válek

Dataset Toolbox

cyberfly/dataset-toolbox

Perform common actions on datasets - merge, unify, validate, transform, order fields etc.

Vasek Codey Vlcek

Dataset Deduplicator

automation-lab/dataset-dedup

Merge and deduplicate Apify datasets by any field combination. Remove duplicates, keep first or last occurrence. Case-insensitive matching, whitespace trimming. Pay per 1K items processed.