Pass CUBEJS_DB_QUERY_TIMEOUT to Firebolt driver

[alexanderchiu]

Check List

• Tests have been run in packages where changes made if available
• Linter has been run for changed code
• Tests for the changes have been added if not covered yet
• Docs have been added / updated if required

Pass CUBEJS_DB_QUERY_TIMEOUT variable through as https://docs.firebolt.io/reference/system-settings#statement-timeout to Firebolt so that query cancellation works correctly.

Example curl:

curl --location 'https://XXXXX.api.eu-west-1.app.firebolt.io/?database=XXXXX\&output_format=JSON_Compact&engine=test_engine&statement_timeout=1000' \
--header 'Authorization: Bearer XXXXXXX' \
--data 'SELECT checksum(*) FROM GENERATE_SERIES(1, 1000000000000);'
{
  "errors": [
    {
      "description": "Query was canceled with reason 'Query timeout expired (1000 ms)'"
    }
  ],
  "query": {
    "query_id": "def8ff9a-3f85-4c89-ac41-030cb56bfa19",
    "query_label": null,
    "request_id": "7159c249-edc3-42f0-a518-4b5d13bc05f3"
  },
  "statistics": {
    "elapsed": 0.0
  }
}

[KSDaemon]

Hi @alexanderchiu thank you for this contribution!

[alexanderchiu]

Hi @alexanderchiu thank you for this contribution!

And thanks for the quick review!