CassandraFDW: Apache Cassandra® Foreign Data Wrapper

Install and Enable CassandraFDW

CassandraFDW is currently available for version 9.5 of Postgres. You can install the CassandraFDW extension via pgc command line or BigSQL Manager and then enable the extension in the database you want to access Cassandra from. To install CassandraFDW with PostgreSQL v9.5, run the following:


$ ./pgc install cassandra_fdw3-pg95
  ['cassandra_fdw3-pg95']
Get:1 http://s3.amazonaws.com/pgcentral cassandra_fdw3-pg95-3.0.0-osx64
  Unpacking cassandra_fdw3-pg95-3.0.0-osx64.tar.bz2
Simply configure PostgreSQL one-time with the following commands:

CREATE EXTENSION cassandra_fdw;

CREATE SERVER cass_serv FOREIGN DATA WRAPPER cassandra_fdw
  OPTIONS (host '127.0.0.1,127.0.0.2', port '9042');

CREATE USER MAPPING FOR public SERVER cass_serv
  OPTIONS (username 'test', password 'test');
Now we reference the remote Cassandra table OORDER such that it can be used in PostgreSQL as the TEST foreign table.

CREATE FOREIGN TABLE test (id int) SERVER cass_serv
  OPTIONS (schema_name 'example', table_name 'oorder');
To learn more, take a look at our documentation.