I have a problem I would like to create on redash a dataSource to a database on oracle but there is a problem that pure redash does not offer this, so I try using the configuration from this git https://gist.github.com/linhmtran168/ec0757a487a83a1fc5c5d3188af81874. Unfortunately every time I fire up the image build something crashes eg.
#0 54.40 Collecting pymapd>=0.2.1
#0 54.43 Downloading pymapd-0.7.1.tar.gz (93 kB)
#0 55.03 ERROR: Command errored out with exit status 1:
#0 55.03 command: /usr/bin/python -c 'import sys, setuptools, tokenize; sys.argv[0] = '"'"'/tmp/pip-install-WesdAZ/pymapd/setup.py'"'"'; __file__='"'"'/tmp/pip-install-WesdAZ/pymapd/se tup.py'"'"';f=getattr(tokenize, '"'"'open'"'"', open)(__file__);code=f.read().replace('"'"'\r\n'"'"', '"'"'\n'"'"');f.close();exec(compile(code, __file__, '"'"'exec'"'"'))' egg_info --egg-b ase /tmp/pip-pip-egg-info-rp8AZf
#0 55.03 cwd: /tmp/pip-install-WesdAZ/pymapd/
#0 55.03 Complete output (23 lines):
#0 55.03 Couldn't find index page for 'setuptools_scm' (maybe misspelled?)
#0 55.03 No local packages or download links found for setuptools_scm
#0 55.03 Traceback (most recent call last):
#0 55.03 File "<string>", line 1, in <module>
#0 55.03 File "/tmp/pip-install-WesdAZ/pymapd/setup.py", line 65, in <module>
#0 55.03 extras_require=extra_requires
#0 55.03 File "/usr/lib/python2.7/distutils/core.py", line 111, in setup
#0 55.03 _setup_distribution = dist = klass(attrs)
#0 55.03 File "/usr/local/lib/python2.7/dist-packages/setuptools/dist.py", line 269, in __init__
#0 55.03 self.fetch_build_eggs(attrs['setup_requires'])
#0 55.03 File "/usr/local/lib/python2.7/dist-packages/setuptools/dist.py", line 313, in fetch_build_eggs
#0 55.03 replace_conflicting=True,
#0 55.03 File "/usr/local/lib/python2.7/dist-packages/pkg_resources/__init__.py", line 826, in resolve
#0 55.03 dist = best[req.key] = env.best_match(req, ws, installer)
#0 55.03 File "/usr/local/lib/python2.7/dist-packages/pkg_resources/__init__.py", line 1092, in best_match
#0 55.03 return self.obtain(req, installer)
#0 55.03 File "/usr/local/lib/python2.7/dist-packages/pkg_resources/__init__.py", line 1104, in obtain
#0 55.03 return installer(requirement)
#0 55.03 File "/usr/local/lib/python2.7/dist-packages/setuptools/dist.py", line 380, in fetch_build_egg
#0 55.03 return cmd.easy_install(req)
#0 55.03 File "/usr/local/lib/python2.7/dist-packages/setuptools/command/easy_install.py", line 658, in easy_install
#0 55.03 raise DistutilsError(msg)
#0 55.03 distutils.errors.DistutilsError: Could not find suitable distribution for Requirement.parse('setuptools_scm')
#0 55.03 ----------------------------------------
#0 55.03 ERROR: Command errored out with exit status 1: python setup.py egg_info Check the logs for full command output.
------
Dockerfile:34
--------------------
32 | # change.
33 | COPY requirements.txt requirements_dev.txt requirements_all_ds.txt requirements_oracle_ds.txt ./
34 | >>> RUN pip install -r requirements.txt -r requirements_dev.txt -r requirements_all_ds.txt -r requirements_oracle_ds.txt
35 |
36 | COPY . ./
--------------------
I changed the version of requrments, even added a line of which pip to download to handle it in Dockerfile.
RUN pip install pip==20.2.4;
I don't know what to do anymore as the application itself without trying to attach odbc drivers from oracle is working fine but I need to access that database on oracle asap
Does anyone have a way to connect redash to oracle database, unfortunately I have not found much on the Internet, and unfortunately when there are some solutions they crash on requirments precisely
