Dataset Query Engine
Pricing
Pay per usage
Dataset Query Engine
Use natural language queries to retrieve results from an Apify dataset. This Actor provides a query engine that loads a dataset, executes SQL queries, and synthesizes results.
4.6 (5)
Pricing
Pay per usage
1
Monthly users
4
Runs succeeded
70%
Last modified
a month ago
Text or SQL query
querystringRequired
Provide a query to specify the data to be retrieved from a dataset. The query can be in natural language or SQL format. For SQL, use the table name 'dataset'.
Examples (when your dataset contains data scraped from Google Maps):
- Find restaurant names with reviews above 4 and with at least 100 reviews.
- SELECT title, totalScore, reviewsCount FROM dataset;
OpenAI model (OpenAI is the only supported provider now)
modelNameEnumOptional
Specify the LLM for SQL generation and query synthesis. Currently supports OpenAI models with varying capabilities and performance characteristics.
Value options:
"gpt-4o-mini": string"gpt-4o": string"o3-mini": stringDefault value of this property is "gpt-4o-mini"
Refresh dataset
refreshDatasetbooleanOptional
In standby mode, the dataset is loaded once and reused to optimize performance. This parameter allows reloading the dataset to ensure updated data is available.
Default value of this property is false
Limit number of dataset items used for query
limitintegerOptional
Maximum number of items to return. By default, there is no limit.
Number of items to skip from the start
offsetintegerOptional
Number of items that should be skipped at the start. The default value is 0.
Default value of this property is 0
Pricing
Pricing model
Pay per usageThis Actor is paid per platform usage. The Actor is free to use, and you only pay for the Apify platform usage.
