![SQL Query avatar](https://images.apifyusercontent.com/e6X5QHjJoGUDXDCfA470FI9qr7D2GCzpoBRMBzycduA/rs:fill:250:250/aHR0cHM6Ly9hcGlmeS1pbWFnZS11cGxvYWRzLXByb2QuczMudXMtZWFzdC0xLmFtYXpvbmF3cy5jb20vRWZHdmhrSXRySkxZRmNqY2gvNFFpNmNHUHRQRmdYaUM5OWgtcG5nd2luZy5jb20ucG5n.webp)
SQL Query
Try for free
No credit card required
View all Actors![SQL Query](https://images.apifyusercontent.com/e6X5QHjJoGUDXDCfA470FI9qr7D2GCzpoBRMBzycduA/rs:fill:250:250/aHR0cHM6Ly9hcGlmeS1pbWFnZS11cGxvYWRzLXByb2QuczMudXMtZWFzdC0xLmFtYXpvbmF3cy5jb20vRWZHdmhrSXRySkxZRmNqY2gvNFFpNmNHUHRQRmdYaUM5OWgtcG5nd2luZy5jb20ucG5n.webp)
![SQL Query](https://images.apifyusercontent.com/e6X5QHjJoGUDXDCfA470FI9qr7D2GCzpoBRMBzycduA/rs:fill:250:250/aHR0cHM6Ly9hcGlmeS1pbWFnZS11cGxvYWRzLXByb2QuczMudXMtZWFzdC0xLmFtYXpvbmF3cy5jb20vRWZHdmhrSXRySkxZRmNqY2gvNFFpNmNHUHRQRmdYaUM5OWgtcG5nd2luZy5jb20ucG5n.webp)
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
Maintained by Community
Actor metrics
- 1 monthly user
- 3 stars
- 100.0% runs succeeded
- Created in Nov 2023
- Modified 10 months ago
Categories