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

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

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