Connector Postgres
hello in version 6.1 connector Postgres was announced, i downloaded the distribution but it is not there, is there a plan to return this connector, or even better, build in a tool to connect to any database
-
Hi @Ivan1981,
you can connect to Postgres using HeavyConnect, but I guess the feature is for EE Only (I'm not sure of that)
You can find references to that feature here
https://docs.heavy.ai/heavyconnect/heavyconnect-release-overview
Postgres is the first database added, but we are adding some more (e.g. SnowFlake, Hive, etc.)
The feature should be in Beta.
Best Regards, Candido
-
Hi,
You can use the heavy connector thru Heavy Immerse, but you have to install a driver for the database you are interested in (e.g., Postgres, but also Snowflake and RedShift have been testing).
Please refer to the heavy connect docs and pay special attention to setting up a heavy connector for immerse's section.
After that, everything is correctly configured, you should see something like that in the Data Manager section of Immerse (I added just PostgreSQL)
Then you can select PostgreSQL as datasource to Connect (create a foreign table thru the UI) or Import (copy the data to a local table)
Pressing connect, you should get a preview , and you can choose the name of the foreign table you are going to create
More or less, the same happens when you choose the Import option.
After creating the table, you can query or inspect it in the SQL Editor. LetLet me know if we replied to your question or if you need other info.
-
odbcinst.ini
andodbc.ini
in the/etc/
directory. it"s OKdocker file it"s true? I don"t see postgresql
# Copy and extract HEAVY.AI tarball. In own stage so that the temporary tarball# isn't included in a layer.FROM ubuntu:18.04 AS extract
WORKDIR /opt/heavyai/COPY heavyai-latest-Linux-x86_64-cpu.tar.gz /opt/heavyai/RUN tar xvf heavyai-latest-Linux-x86_64-cpu.tar.gz --strip-components=1 && \rm -rf heavyai-latest-Linux-x86_64-cpu.tar.gz
# Build final stageFROM ubuntu:18.04LABEL maintainer "HEAVY.AI Support <support@heavy.ai>"
RUN apt-get update && apt-get install -y --no-install-recommends \libldap-2.4-2 \bsdmainutils \wget \curl \libgeos-dev \default-jre-headless && \apt-get remove --purge -y && \rm -rf /var/lib/apt/lists/*
COPY --from=extract /opt/heavyai /opt/heavyai
WORKDIR /opt/heavyai
EXPOSE 6274 6273
CMD /opt/heavyai/startheavy --non-interactive --data /var/lib/heavyai/storage --config /var/lib/heavyai/heavy.conf
FROM heavyai/heavyai-ee-cuda
# Install PostGreSQL ODBC driver.# The Snowflake ODBC driver depends on unixodbc.RUN apt-get update && apt-get install -y odbc-postgresql unixodbc
# Install Redshift ODBC driver.RUN dpkg -i ./AmazonRedshiftODBC-64-bit-1.4.52.1000-1.x86_64.debRUN rm ./AmazonRedshiftODBC-64-bit-1.4.52.1000-1.x86_64.deb
# Install Snowflake ODBC driver.RUN dpkg -i ./snowflake-odbc-2.25.2.x86_64.debRUN rm ./snowflake-odbc-2.25.2.x86_64.deb
Please sign in to leave a comment.
Comments
5 comments