I joined a new team and need a suggestion on exposing data to downstream customers.
I have 5 SQL Instance on different Clusters which has 13 databases that are exposed to users. All databases are CDC Enabled and users have CDC_Admin access and they pull through CT Tables. My question here is
1) Will user's select statements have any negative effects while our CT Tables are getting populated with 2 records for every record in base table?
2) How else can I expose these data to users. I do not want them directly attaching my warehouse SQL Instances. Like if I can get few options I can think about the feasible ones for me.