Note
Triangle of Talent
Connecting Redshift
- Hi Simon and Anurag,
- Now we have the Redshift (serverless) access, we need to connect it to Holistics.
- There are two ways for Holistics to connect:
- Direct connection (public endpoint + IP allowlist)
- Reverse SSH Tunnel (no public exposure)
- The best practice here is using the reverse SSH tunnel. We have set up Redshift for some customers using this way. Some benefit:
- No Exposing of Private Network.
- Data Encryption in Transit.
- Document: https://docs.holistics.io/docs/connect/connect-tunnel
- Meanwhile, we’re analyzing the shared dump file as well as the product pricing info.
- Happy to jump on a quick call to finish the setup.
Done
- DONE Communicate the problem space of adding the Redshift Serverless data source to Holistics
DONE Try to synthesize the conceptual business model of Add2Cart (data modeling)
DONE Answer ticket for 42chat
DONE Follow-up a message for connecting to Holistics: options direct connect or reverse tunnel
DONE Predicate pushdown filter airbyte.com/data-engineering-resources/predicate-pushdown