Retrieving Events

After publishing events to Fiddler, you may want to retrieve them for further analysis.

Querying production data

You can query production data from the Analyze tab by issuing the following SQL query to Fiddler.

SELECT
    *
FROM
    "production.YOUR_MODEL_NAME"

The above query will return the entire production table (all published events) for a model with the name YOUR_MODEL_NAME.

Querying a baseline dataset

You can query a baseline dataset that has been uploaded to Fiddler with the following SQL query.

SELECT
    *
FROM
    "YOUR_DATASET_NAME.YOUR_MODEL_NAME"

Here, this will return the entire baseline dataset that has been uploaded with the name of YOUR_DATASET_NAME to a model with the name YOUR_MODEL_NAME.