SQL Query
Try for free
No credit card required
View all Actors
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-startDeveloper
Useful toolsMaintained by Community
Actor metrics
- 1 monthly user
- 3 stars
- 100.0% runs succeeded
- Created in Nov 2023
- Modified 9 months ago
Categories
