Integrate Tableau with Astra DB Serverless

You can use Tableau to explore, analyze, and visualize data stored in your Astra DB Serverless databases.

Prerequisites

This integration requires the following:

A compatible Apache Cassandra® JDBC driver, such as the open-source ing-bank/cassandra-jdbc-wrapper or the DataStax JDBC driver.

You can access the ODBC and JDBC drivers through the DataStax Support portal or by contacting DataStax Support.
A Tableau license.

This guide explains how to use Tableau Desktop to connect and query data in a Astra DB Serverless database. You may need to modify some steps if you use Tableau Server or Tableau Cloud.

An Astra DB Serverless database with table data that you want to visualize.

This integration supports table data. It may not work as expected with vector-enabled collections.

Optional: Create demo tables

You can create sample tables to test this integration:

Create a keyspace in your database.
Use the CQL shell to select your keyspace:
```
USE KEYSPACE;
```

Create the demo tables:

CREATE TABLE customer (
    id UUID,
    name TEXT,
    email TEXT,
    PRIMARY KEY (id)
);

CREATE TABLE accounts_by_customer (
  customer_id UUID,
  account_number TEXT,
  account_type TEXT,
  account_balance DECIMAL,
  customer_name TEXT STATIC,
  PRIMARY KEY ((customer_id), account_number)
);

Insert sample data:

INSERT INTO customer (id,name,email) VALUES (8d6c1271-16b6-479d-8ea9-546c37381ab3,'Alice','alice@example.org');
INSERT INTO customer (id,name,email) VALUES (0e5d9e8c-2e3b-4576-8515-58b491cb859e,'Bob','bob@example.org');


INSERT INTO accounts_by_customer (customer_id,account_number,account_type,account_balance,customer_name)
VALUES (8d6c1271-16b6-479d-8ea9-546c37381ab3,'A-101','Checking',100.01,'Alice');
INSERT INTO accounts_by_customer (customer_id,account_number,account_type,account_balance,customer_name)
VALUES (8d6c1271-16b6-479d-8ea9-546c37381ab3,'A-102','Savings',200.02,'Alice');
INSERT INTO accounts_by_customer (customer_id,account_number,account_type,account_balance,customer_name)
VALUES (0e5d9e8c-2e3b-4576-8515-58b491cb859e,'B-101','Checking',300.03,'Bob');
INSERT INTO accounts_by_customer (customer_id,account_number,account_type,account_balance,customer_name)
VALUES (0e5d9e8c-2e3b-4576-8515-58b491cb859e,'B-102','Savings',400.04,'Bob');

Get Astra DB credentials

In the Astra Portal, download your database’s Secure Connect Bundle (SCB), and then securely store it where your Tableau installation can access it.
Create an application token that can read from your database.

Connect Tableau to Astra DB Serverless

Move your JDBC driver JAR to the Tableau drivers directory:
- Windows: C:\Program Files\Tableau\Drivers
- Mac: ~/Library/Tableau/Drivers
- Linux: /opt/tableau/tableau_driver/jdbc
Start or restart Tableau Desktop.
Configure the JDBC driver connection in Tableau:
1. In Tableau, under Connect, select Other Database (JDBC).
2. For URL, enter the connection parameters required by your driver.
  
  For example, use the following URL to connect the OSS JDBC driver to Astra DB:
  jdbc:cassandra:dbaas:///KEYSPACE?consistency=LOCAL_QUORUM&user=token&password=APPLICATION_TOKEN&secureconnectbundle=/PATH_TO_SCB.zip
3. For Dialect, select SQL92.
4. For Username, enter the literal string token.
5. For Password, provide an application token that can read from your database.
6. Click Sign In.
Set up data sources in Tableau:
1. Under Database, select your database.
2. Under Schema, select your keyspace.
3. Drag and drop your tables into the visualization pane, and then establish relationships between the tables.
Build views for your data in Tableau. There are many ways to do this, depending on the data you want to visualize. If you created the demo tables, you could create a view that shows customer names on the X axis and account balances on the Y axis.

Integrate Tableau with Astra DB Serverless

Prerequisites

Get Astra DB credentials

Connect Tableau to Astra DB Serverless

See also

Was this helpful?

Give Feedback