Query engine is a service that is responsible for executing the queries that are built from API requests. It is a REST API service that is built using FastAPI. It implements custom semantic layer for BigQuery data. It is written in Python and uses FastAPI as a web framework.
GameTuner Query Engine service is dependent on GameTuner Metadata service. MetaData service is used for fetching configurations of applications for query engine. If MetaData service is not available, application will not start.
In order to run this service you need to have the following installed:
- Python 3.10+
The service is configured using environment variables. The following environment variables are used:
GCP_PROJECT_ID- GCP project idJSON_LOGS- If set to 1, logging is enabledMETADATA_IP_ADDRESS- Metadata service IP addressMETADATA_PORT- Metadata service portUVICORN_PORT- Port on which the service will run
Examples of environment variables can be found in the .env file.
To run the service locally, you need to install the dependencies first. You can do that by running the following command:
pip install -r requirements.txtAfter that you can run the service by running the following command:
uvicorn queryengine.main:app --reloadFor deploying the application on GCP, you should first build the application by running google cloud build gcloud builds submit --config=cloudbuild.yaml .. Script submits docker image to GCP artifact registry. Once the image is submitted, you should deploy the application on GCP. You can do that by running terraform script in GameTuner terraform project.
Service provides REST API for managing organisations, apps, events and event schemas. You can find the full API documentation on http://localhost:8001/docs
The GameTuner Query Engine is copyright 2022-2024 AlgebraAI.
GameTuner Query Engine is released under the Apache 2.0 License.