data-warehouse

especially for less obvious but lengthy code snippets!

Bigquery external table API supports auto schema detection for external table source by a boolean property - ref.

If the target field names are the same as the source fields in the Google Spreadsheet, it should be better not to supply any schema rather than sp

Allows for local file upload to accept .xlsx file, uses https://github.infra.cloudera.com/michaelbrine/xlsxreader
to parse .xlsx into a .csv file
xlsxreader has test cases and current test case verifies when local_file_upload() is given a .xlsx file, the return path has the correct parsed data in it

Why

There're scenarios that our MVP users may not import both Jira and Gitlab data.
As a result, a lot of charts will be look like this:

Solution

The reason is that our charts are grouped by cognitive domain(efficiency/quality/cost) an

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().