Accessing DataArtsFabric SQL Using Tableau

Obtaining Tableau

You can obtain the latest Tableau version from the Tableau official website.

Interconnecting DataArtsFabric SQL with JDBC

1. Obtain JDBC. For details, see Obtaining JDBC.
2. Install JDBC as instructed. After the installation is complete, find the Drivers folder in the Tableau installation directory and copy the JDBC JAR file to the folder.

   The following is an example of the directory on Windows. For details, see Tableau and JDBC.

   C:\Program Files\Tableau\Drivers

3. Open Tableau. Click Other Databases (JDBC).

   If this option is not displayed, click More and then click Other Databases (JDBC).

4. Enter the JDBC URL in URL and select PostgreSQL for Dialect.

   JDBC URL template:

   jdbc:fabricsql://<host>[:<port>]/<database>

   Example:

   jdbc:fabricsql://example.com:1234/database

   Parameter	Description
   host	DataArtsFabric SQL address
   port	(Optional) Port number
   database	(Required) Database name, which can be customized.

   Additionally, you need to configure Properties file for authentication. Click Browse and select the compiled property file. The extension name of the property file is .properties. In this example, the property file is named serverless.properties. Then, click Sign in.

   The following shows an example of the property file:

   AccessKeyID=YOUR_AK
   SecretAccessKey=YOUR_AK
   securityToken=YOUR_STOKEN
   workspaceId=YOUR_WORKSPACE
   endpointId=YOUR_ENDPIONT_ID
   lakeformation_instance_id=YOUR_LF_ID
   PGDBNAME=YOUR_CATALOG

   

   You do not need to set the username and password.

   Property Name	Description	Mandatory or Optional	How to Obtain
   AccessKeyID	Authentication ID	Mandatory	Creating a Permanent Access Key or Obtaining Temporary Access Keys and Security Tokens of an IAM User
   SecretAccessKey	Authentication key	Mandatory
   securityToken	STSToken	Optional (required when a temporary AK/SK pair is used.)
   workspaceId	Workspace ID	Mandatory	Click View Details in Workspace Management Console.
   endpointId	Endpoint ID	Mandatory	Querying Details About a SQL Endpoint
   lakeformation_instance_id	LakeFormation instance ID	Mandatory	LakeFormation information created in Planning and Creating a LakeFormation Instance, Catalog, Database, and Table.
   PGDBNAME	Lakeformation catalog name	Mandatory