![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).
The code examples below show how to run the Actor and get its results. To run the code, you need to have an Apify account. Replace <YOUR_API_TOKEN> in the code with your API token, which you can find under Settings > Integrations in Apify Console. Learn more
1from apify_client import ApifyClient
2
3# Initialize the ApifyClient with your Apify API token
4client = ApifyClient("<YOUR_API_TOKEN>")
5
6# Prepare the Actor input
7run_input = { "query": "SELECT 'test data' as `test column`" }
8
9# Run the Actor and wait for it to finish
10run = client.actor("useful-tools/sql-query").call(run_input=run_input)
11
12# Fetch and print Actor results from the run's dataset (if there are any)
13print("💾 Check your data here: https://console.apify.com/storage/datasets/" + run["defaultDatasetId"])
14for item in client.dataset(run["defaultDatasetId"]).iterate_items():
15 print(item)
16
17# 📚 Want to learn more 📖? Go to → https://docs.apify.com/api/client/python/docs/quick-start
Developer
Maintained by Community
Actor metrics
- 1 monthly user
- 3 stars
- 100.0% runs succeeded
- Created in Nov 2023
- Modified 10 months ago
Categories