Hi all, sorry for the brain dump here, trying to g...
# getting-started
a
Hi all, sorry for the brain dump here, trying to get a local visualisation tool up and running with meltano and duckdb on Windows and had no end of issues. Sure lots of these are not meltano's fault, but it's not a very smooth process and any tips welcome. Here is the timeline so far:
- Try Superset - Openssl install required, installed - with log-level debug: `Superset metadata database could not be initialized:
superset db upgrade
failed` -
[error    ] Fatal Python error: _Py_HashRandomization_Init: failed to get random numbers to initialize Python
- Try Metabase - Need to run via docker, install and run. - Discover no native duckdb driver for MB. - Download and install custom driver. - Add custom plugins dir to metabase ENV variables. - Now can select duckdb driver in MB, but when I do so, receive error message. - Known issue with alpine MB base image - Need to build custom docker image, not sure how to do this on Windows, move on. - Try sqlite as source instead of duckdb - target-sqlite fails.
AttributeError: module 'time' has no attribute 'clock'
- time.clock removed in py3.8 - sqlalchemy upgrade attempted but conflict with typing requirement - Try superset_ext -
meltano install
results in 0 plugins installed. - With debug:
Found plugin parent            parent=metabase plugin=metabase source=lockfile
- Remove metabase to see what happens! - Still nothing installed Give up!?
j
I'd take a look at superset and why it is failing to init the db. Would strongly encourage to deploy it via docker. The error you've mentioned seems to be related to Windows environment 🤷
a
@janis_puris any pointers on docker for superset greatly appreciated, it's a complete new thing to me. The metabase hub docs give an explanation for using docker, but nothing equivalent for superset
j
Hi @Andy Carter! Would suggest taking a look at examples at https://hub.docker.com/r/apache/superset Their official docs on installing superset via docker https://superset.apache.org/docs/installation/installing-superset-using-docker-compose/ Superset is awesome for what it costs to maintain it IMHO. Not a huge fan of metabase