Managing the Amazon Redshift Connector

The Zoomdata Amazon Redshift connector lets you access the data available in the Amazon Redshift storage for visualization and exploration using the Zoomdata client. The Zoomdata Amazon Redshift connector supports Amazon Redshift version 1.0.1.

Before you can establish a connection from Zoomdata to Amazon Redshift storage, a connector server needs to be installed and configured. See Managing Connectors and Connector Servers for general instructions and Connecting to Amazon Redshift for details specific to the Amazon Redshift connector.

After the connector has been set up, you can create data source configurations that specify the necessary connection information and identify the data you want to use. See Manage Data Source Configurations for more information. After data sources are configured, they can be used to create dashboards and charts from your data. See Creating Dashboards and Creating Charts.

Zoomdata Feature Support

The Amazon Redshift connector supports all Zoomdata features, except for the following features:

Amazon Redshift returns whole numbers for aggregates on columns of type DECIMAL and NUMERIC types which have a 0 scale (in other words, 0 decimal places).

Connecting to Amazon Redshift

Verify the MTU Size of Zoomdata

Before you can establish a connection between Amazon Redshift and Zoomdata, you must verify that the size of the maximum transmission unit (MTU) on your Zoomdata server is set to 1500.

The MTU size determines the maximum size, in bytes, of a packet that can be transferred in one Ethernet frame over your network connection. If your MTU size is too large for the connection, you might experience incomplete query results, your query might hang, or the connection might be dropped altogether. For more information, see this AWS documentation link:

To review the MTU value, use the ip command:

$ ip addr show eth0

If you need to edit the MTU value and set the size to 1500, use the following ip command:

$ ip link set dev eth0 mtu 1500

Configure and Reference the JDBC Driver

The Amazon Redshift connector requires a JDBC driver to be configured before you connect. You can download the driver from the vendor's site. If you are upgrading, keep in mind you need to configure the JDBC driver- see Upgrade Zoomdata. For more information, see Adding a JDBC Driver. The JDBC Driver for Redshift has more than one jar file that needs to be downloaded: be sure to place the files in the same location to avoid any issues.

When setting up your Amazon Redshift connection, you need to specify the JDBC URL. You can find the URL on the Configuration tab of a cluster under Cluster Database Properties. The format varies slightly based on the type of database being connected. For Amazon Redshift, use the following format: jdbc:redshift://HOSTNAME:PORT/DATABASE_NAME . If authentication has been set up, provide the user name and password