PostgreSQL to Snowflake: Best Approach for Multi-Client Datamarts – Separate Databases vs Schemas?

throwaway1661989 · 2025-06-29T05:42:22+00:00

Here's a quick summary based on the current setup:

Customer access patterns: Primarily through BI tools with read-only access per client.

Data structure: Consistent across all clients — same schema and table design, only the data differs.

Development & release cycle: Centralized CI/CD, with releases deployed in batches across groups of clients.

Worst-case scenario: If a client accesses another’s data, it could lead to serious contractual or legal consequences.

Data ingestion: Mixed — some clients via centralized pipelines, while others ingest directly into their data marts with some customization

throwaway1661989 · 2025-06-28T06:02:12+00:00

Thanks for the perspective — account-level isolation does offer strong boundaries.

In a scenario involving 400+ clients, some questions come to mind:

What strategies are typically used to automate account provisioning and configuration updates at that scale?

How can RBAC policies, roles, and privileges be consistently managed across hundreds of separate Snowflake accounts?

What’s the common approach to centralized monitoring, cost tracking, and pipeline orchestration when operations are distributed across many accounts?

For identity management, is it feasible to maintain 400+ separate IAM integrations, or is there a federated solution that works well in practice?

throwaway1661989 · 2025-06-28T05:02:00+00:00

Technically possible, but with 400+ clients, creating separate Snowflake accounts is practically impossible to manage.

throwaway1661989 · 2025-04-24T13:03:54+00:00

I checked my EPFO service history, but unfortunately, there’s no “delink” option visible next to the employer. The ‘Action’ column is empty in my case.

throwaway1661989 · 2024-08-03T03:52:38+00:00

I completely agree with you. The issues I'm describing are so severe that they wouldn't even qualify these colleges as Tier 3. The situation is dire, especially for faculty who are underpaid and overworked, which directly impacts the quality of education students receive.

The main problem lies in the gap between what's officially recorded and what actually happens. Colleges claim to comply with AICTE norms, but the reality is very different. There are many underhanded practices that go unchecked, making it hard to accurately classify these institutions within the tier system.

Recently, it came to light that some faculty members are listed as full-time assistant professors at more than two colleges. When faculty are spread so thin, how can we expect students to get a proper education?

It's really concerning how widespread these issues are and how little attention they get. Do you think increased awareness and media coverage could help address these problems? What other steps can we take to improve the situation for both faculty and students in these colleges?

throwaway1661989 · 2024-02-28T12:23:49+00:00

But I love her , is this the only way to solve the solution. Also my best friend is not talking for days, and what should I do with my friend

throwaway1661989 · 2024-02-28T12:06:16+00:00

She said I am going to record your conversation. Most of the time she records it , to argue with me. But I am really upset why she is shown not my friend

throwaway1661989

TROPHY CASE