Cassandra

Type of Support	Read & Write
Validated On	Database Version: 3.00.01 ODBC Client Version: 2.06.05.1005
Connection Type	ODBC (64-bit)
Driver Details	Certified SIMBA driver from Alteryx Download Center.

Alteryx tools used to connect

In order to fully support the reading and writing of camel case keyspaces, tables, and columns, the user must have the Simba driver option “Enable Case Sensitive” selected and set the Alteryx “Table/Fieldname SQL style” to “quoted”.
Binary column length set to 300000 (default is 4000).
String column length set to 300000 (default is 4000).

The user must specify primary keys to create Cassandra tables.
Alteryx does not support creation of clustering keys - all keys selected will be treated as a partition key: PRIMARY KEY((key1,key2)).
The user must specify the keyspace along with the table name when using the output tool. (Ex: keyspace.tablename)

The Simba Cassandra driver converts all datetime/timestamp data into GMT, therefore any DateTime data written from Alteryx to Cassandra will be converted to GMT. Any data already in Cassandra will be read by Alteryx and translated to GMT and the user can then convert to known time zone.
Alteryx Date, DateTime gets imported to Cassandra as a Timestamp.
Alteryx Time gets imported to Cassandra as a varchar.
There is a driver enforced limit that restricts dates to valid dates in the Gregorian calendar, which means valid year range is 1601 to 9999.

Map, List, and Set data types are not supported.
The Primary Key is not indicated in Active Query Builder when importing tables from Cassandra