data-warehouse

Description

👋 Whilst attempting to scrape metrics from a large Gitlab project (hundreds of thousands of pipelines, tens of thousands of merge requests) the triggered pipeline that scrapes the metrics via the gitlab api was causing increased load to the point users were noticing decreased performance via the UI.

The logs were showing ~19-20 of these calls per second:
`GET https://<gitl

especially for less obvious but lengthy code snippets!

Sending a rest call to delete a job specification throws 404 where as grpc call works fine. Steps to reproduce

curl -X DELETE "http://localhost:9100/v1/project/my-project/namespace/kush/helloworld" -H  "accept: application/json"

https://docs.gethue.com/developer/api/cli/

TODO:

• Auth:
  • On auth, auto select SQL and storage connectors if only one, or select from the list
  • Remember last value used: e.g. dialect/connector, propose last api URL/login as default when relogin..
• Query: select dialect, execute a custom statement reusing Notebook Python lib
• Storage: download, upload

Support copy into queries

What is the feature request? What problem does it solve?
We need to integrate some static code analysis in order to be able to better ensure code quality and security.

Suggested solution
In the current Github Org SonarCloud and/or Codecov are approved so we should use one (or both) of them.

Additional context
This also was found as a gap in the evaluation https://bestpracti

When trying to modify a scenarios with a solution, it throws an error saying:

at.ac.iiasa.ixmp.exceptions.IxExceptionPyRaisable: at.ac.iiasa.ixmp.exceptions.IxException: This Scenario has elements in a variable or equation! Use 'removeSolution()' or clone(False)'before editing!

removeSolution() is deprecated. Actual name is remove_sol().