For Materialized tables: in Peliqan go to Connections, find the tile named “Sync Data warehouse” and copy & paste all the details from the Target:
For SaaS sources: in Peliqan go to Connections, find the tile of the SaaS connection and copy & paste all the details from the Target:
Use these settings in Amazon QuickSight to connect:
- Connection type: Postgres (default data warehouse type in Peliqan)
- Host: db.eu.peliqan.io (for EU instance)
- Port: 5432 (for Postgres)
- User name & password: copy / paste from the Target of the Connection tile (see above)
- Database name: same as the user name
- SSL: enabled
In QuickSight, go to “Add dataset”, select Postgres and enter the above details.
Example in AWS QuickSight:
Once the dataset is added, you can build charts: