Skip to content

Latest commit

 

History

History
19 lines (14 loc) · 1.38 KB

tableau-desktop-driver-setup.md

File metadata and controls

19 lines (14 loc) · 1.38 KB
Raw

Tableau Desktop

Link to product webpage.

Using Tableau with Generic JDBC driver (without using Connector).

  1. Download the Timestream JDBC driver fully shaded JAR file (e.g., amazon-timestream-jdbc-<version>-shaded.jar) and copy it to one of these directories according to your operating system:

    • Windows: C:\Program Files\Tableau\Drivers Example
    • macOS: ~/Library/Tableau/Drivers

  2. Launch the Tableau Desktop application.

  3. Open Connect > Other Databases (JDBC)

  4. Enter URL: jdbc:timestream://PropertyName1=value1;PropertyName2=value2.... For a list of connection properties (e.g., Access Key, Secret Key, Region, etc.), see README. Then select Dialect as PostgreSQL and click Sign In. Tableau Sign In page

Known Limitations

  1. When loading large tables or tables containing colons(":") in the column name, Tableau may generate queries with colons(":") in the AS SQL query statement and send them to the driver, which will cause the data loading to fail. This is because colons(":") are not currently supported in the AS statements on the Timestream server-side.