Cassandra

Provides access to Apache Cassandra database using SQL queries via JDBC driver.

Connection parameters

{
  "server": "",
  "port": "",
  "db": "",
  "connString": ""
}

Supported Parameters (1)

Type	Value	Description or Example
num, int, double	=	=100
	>	>1.02
	>=	>=4.1
	<=	<=100
	!=	!=5
	in	in (1, 3, 10.2)
	min-max	1.5-10.0
string	contains	contains ea
	starts with	starts with R
	ends with	ends with w
	in	in (ab, "c d", "e\"f\"")
datetime	before	before 1/1/2022
	after	after 1/1/2022
	today
	this week
	this month
	this year
	last year
	min-max
	April 2021

• (1) If you want to use parameterized queries, you need to add ALLOW FILTERING which can lead to sirius performance penalties. Moreover, to be able to use string patterns you need to create secondary indexes for columns in where clause. See documentation.

Supported output types

Type	Supported
text	✅
tinyint, smallint, int, bigint, varint	✅
decimal, float, double	✅
boolean	✅
date, timestamp, time	✅
uuid	✅
duration	✅ (1)
map, list, set, udt	✅ (1)
blob	limited support (2)

• (1) supported as a string
• (2) you get unreadable representation, but in query you can cast such a types to varchar, hex

Supported features

• Schema browsing
• Connection test

See also:

• Data connection
• Apache Cassandra