Step-by-step guide to connecting CrateDB to Tableau using the PostgreSQL JDBC driver. Covers installing CrateDB locally, creating a table and importing the Iris dataset via CSV, configuring the PostgreSQL JDBC jar as a Tableau driver on macOS, establishing the JDBC connection in Tableau, and building a basic scatter plot visualization from the imported data.
Table of contents
Requirements:Downloading the Iris dataConnecting to CrateDB and creating a table for the Iris dataSetting up PostgreSQL-JDBC as a Tableau driverConnecting to CrateDB from TableauVisualizing the Iris data346 Impressions