Tableau integrations

The latest service changes have not yet been reflected in this content. We will update the content as soon as possible. Please refer to the Korean version for information on the latest updates.

Available in VPC

Tableau is one of the most popular BI solutions in use today that allows you to visualize your data in a quick and easy way.
This guide shows how to integrate Tableau with NAVER Cloud Platform's Cloud Hadoop.

For more information on Tableau, visit the official Tableau website

Preparations

1. Create a Cloud Hadoop cluster.
   • For more information about creating a Cloud Hadoop cluster, see Get Started with Cloud Hadoop guide.
2. Create Object Storage.
   • For more information about creating Object Storage, see the Object Storage overview guide.
3. Create a Windows server.
   • For more information about creating a Windows server, see the Getting Started with server guide.

4. Set up an ACG.
   • Enter the Windows server IP in the Cloud Hadoop ACG access source and add port 8286 to the allowed ports.
     

Create a table in Hive

1. Upload a sample data file to Object Storage.

   • Download the sample data from here, unzip it, and upload the AllstarFull.csv file to Object Storage > Bucket Management.
     

2. Create a table in the Hive Editor.

DROP table allstarfull;

CREATE external TABLE if not EXISTS `allstarfull` (
        `playerID` VARCHAR(20),
        `yearID` INT,
        `gameNum` INT,
        `gameID` VARCHAR(30),
        `teamID` VARCHAR(4),
        `lgID` VARCHAR(4),
        `GP` INT,
        `startingPos` INT
)
ROW FORMAT DELIMITED
FIELDS TERMINATED BY ','
location 's3a://deepdrive-hue/input/lahman2012/allstarfull';

3. Use a simple query to verify that the table was created correctly.

SELECT * FROM allstarfull;

Add the Presto connector

1. Add the connector in Presto > [CONFIGS] > Advanced trino.connectors.properties.
   • We need to add the Hive connector, so in the connectors.to.add, enter the following:

{"hive":["connector.name=hive-hadoop2",
        "hive.metastore.uri=thrift://<METASTORE-HOST-IP>:9083",
        "hive.config.resources=/etc/hadoop/conf/core-site.xml,/etc/hadoop/conf/hdfs-site.xml",
        "hive.s3.use-instance-credentials=false",
        "hive.s3.aws-access-key=<API-ACCESS-KEY>",
        "hive.s3.aws-secret-key=<API-SECRET-KEY>",
        "hive.s3.endpoint=https://kr.object.private.ncloudstorage.com"]
        }

2. A reboot is required for the changed configuration to take effect. Click [ACTIONS] > Restart All in the upper right corner and click [CONFIRM RESTART ALL] in the popup window.

Install Tableau

The steps listed below are all performed on a Windows server.

1. Download Tableau Desktop from the Tableau website.
2. Download the Presto JDBC driver (presto-jdbc-0.268.jar) from the Presto website
3. Move the Presto JDBC driver to the Drivers directory in the path where Tableau is installed.
   

Install the nginx-ssl.crt certificate

1. Import the /etc/nginx/ssl/nginx-ssl.crt certificate from the Cloud Hadoop Edge node to your Windows server.

   • For instructions on how to access the edge node, see the guide titled Access a cluster node with SSH
     

2. Double-click the nginx-ssl.crt certificate and click [Install certificate].
   

3. Select Local Computer and click [Next].
   

4. Select Save all certificates to the following store and select a certificate store:

   • Set the certificate store to Trusted Root Certification Authorities.
     

5. Click [Finish] to complete the certificate installation.
   

Access Presto from Tableau Desktop

1. Launch Tableau Desktop and select Connect to server > More > Presto.
   
2. Enter your access information and click [Log in].

Access information 
 - Server: domain of the Presto cluster
 - Port: port of the Presto coordinator (8286)
 - Catalog: name of the catalog to use
 - Schema: name of the schema to use
 - Username: name of the user to use
 - SSL required: check

Check tables and records

1. Click Include and search to check the tables in the schema.
   

2. Click [Update now] to load the data into the tables.
   

3. You can create a new sheet and visualize it simply by dragging and dropping.