DataLoader:dataset-zname-:sql-query

View in ref guide.

Edit this option          Publish this option          Clear draft content

Published Option

sql-query

Default Value: No default value
Valid Values: A string starting with "file:" and followed by a valid path to a file in the Data Loader Docker container containing an SQL query
Changes Take Effect: After 15 min timeout
Modified: 9.0.017.01

You need to configure this option only when you are using a customized query to extract data from the Genesys Info Mart database for the Agent Profile and interactions datasets. You do not need to configure the sql-query option to create datasets from .csv files, such as for Customer Profile data, outcomes data, and agent data from sources other than Genesys Info Mart.

Two example SQL queries are provided in the Data Loader Docker container for your reference:

• /dl/interaction_data_aht.sql - the query used to collect average handling time (AHT) data for Data Loader to upload to the interactions dataset.
• /dl/agents_data_gim.sql - the query used to collect data to populate the default Agent Profile dataset.

For instructions to create your own SQL query, see Create your own SQL query in the Deployment and Operations Guide.

The following is an example of a valid value for this option: file:/datasets/outcomes/my_interactions_data_gim.sql

If you do not configure this option in the [dataset-agents-gim] or [dataset-interactions-gim] sections, Data Loader uses the appropriate default query.

Draft Option

No draft option