Query Tableau Extract via Postgres FDW #tableau #postgres

README.md

Good Reference Article

• https://medium.com/starschema-blog/scaling-out-tableau-extracts-building-a-distributed-tableau-hyper-cluster-534bc6e6ba62 (Note: Hyper API has changed)

Setup Hyper API Server

1. conda create --name tableau python=3.7
2. conda activate tableau
3. pip install tableauhyperapi
4. /opt/anaconda3/envs/tableau/lib/python3.7/site-packages/tableauhyperapi/bin/hyper/hyperd run --init-user=tableau_internal_user --log-dir /Users/wilhelm/Downloads/ -d /Users/wilhelm/Downloads/many_cols.hyper --skip-license --no-password --listen-connection tab.tcp://0.0.0.0:7483 (NOTE: adjust PATHS for log dir and hyper extract)

Setup FDW in Postgres

CREATE SERVER hyper2 FOREIGN DATA WRAPPER postgres_fdw
    OPTIONS (host 'localhost', port '7483', dbname '/Users/wilhelm/Downloads/many_cols.hyper');
   
CREATE USER MAPPING FOR postgres SERVER hyper2 OPTIONS (user 'tableau_internal_user');

GRANT USAGE on FOREIGN DATA WRAPPER postgres_fdw to postgres;
GRANT USAGE ON FOREIGN SERVER hyper2 TO postgres;

IMPORT FOREIGN SCHEMA "Extract" FROM SERVER hyper2 INTO public;

SELECT id FROM "Extract" WHERE id=1000;