Dataset Query Engine
No credit card required
Dataset Query Engine
No credit card required
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.
Jiří SpilkaActor Metrics
4 monthly users
4.6 / 5 (5)
1 bookmark
58% runs succeeded
Created in Feb 2025
Modified 2 days 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"o1": string"o1-mini": string"o3-mini": stringDefault value of this property is "gpt-4o-mini"
LLM Provider API key (OpenAI is the only supported provider now)
llmProviderApiKeystringRequired
API key for accessing a Large Language Model.
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
