Hi all!
I have some questions about Flink enrichment patterns. We have real-time data that we need to join with 10+ tables, including historical data, but we don't have direct access to the SQL tables.
A few questions:
1. What are the best practices for this kind of multi-table enrichment at scale?
2. Can we use our data warehouse as a source? We have CDC set up and are wondering if we can tap the JDBC connector for warehouses like BigQuery and Snowflake β has anyone tried this?
3. Are there other options we should consider?
Any input appreciated!