SQL Query avatar
SQL Query
Try for free

No credit card required

View all Actors
SQL Query

SQL Query

useful-tools/sql-query
Try for free

No credit card required

Run SQL queries over Apify Platform (currently supports only Datasets).

SQL Query Actor (PoC)

Actor for performing SQL queries over Apify platform.

Example for selecting aggregated information from dataset:

1SELECT
2   country, city, COUNT(*) as amount
3FROM
4   `jepxmCkXTBG5buxxx` -- id of Dataset
5GROUP BY
6   country, city
7SORT BY
8   country ASC, city ASC

Results are stored in to default Dataset of the run.

TODO:

  • load table optimizations - only used fields + parallel the loading.
  • Better Data-type determination (date, numbers, integers, etc...).
  • implement system tables - to be able to select Runs based on actors etc.
  • migrate to PostgreSQL - to be able to run PL/pgSQL scripts.
Developer
Community logoMaintained by Community
Actor metrics
  • 2 monthly users
  • 100.0% runs succeeded
  • Modified 4 months ago
Categories

You might also like these Actors