Related Posts
Is TW calling employees back to office?
Additional Posts in Data & Analytics Consultants
Do y’all use CRISP-DM?
New to Fishbowl?
Download the Fishbowl app to
unlock all discussions on Fishbowl.
unlock all discussions on Fishbowl.
Is TW calling employees back to office?
Do y’all use CRISP-DM?
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
Download the Fishbowl app to unlock all discussions on Fishbowl.
Copy and paste embed code on your site
Scan your QR code to download
Fishbowl app on your mobile
It depends. There's a lot of ways to architect something that can scale horizontally (and in real-time)
If you're using a managed service like Redshift, you don't have to manage this yourself.
But if you're building it on your own and you're wondering about scaling up, then you'd want to look into load balancing and the likes.
You'll also want to think about views and temp tables, so every user is querying different "instances" of the database.
Are you on a cloud service with enterprise account? Call your solutions architect and ask them.
Thanks! This isn’t for a project, just trying to educate myself On how BI architecture best practices are set up
I’ve been doing a lot of Googling, but am interested to hear if you have a more focused suggestion
Not really. I'm just a hobbyist as well. I'd suggest starting with aws or gcp websites. They need to create educational materials so they have more business. They are motivated to educate you. Lol.
You can also look into various architecture patterns - caches, message queuing, circuit breaker, load management/shedding
Make your warehouse redundant and implement a load balancer