Effective way to grant limited access to 3rd party service account in Snowflake?
1
vote
1
answer
45
views
I'm green as a dba somewhat. Not really a DBA actually.
So we have a bunch of databases/ datatables ... we need to grant a small subsection of access (say 3 tables, show half the fields for PPI reasons).
For some reason the project lead initially thought we should create an entirely different database (DB_service_account) and either replicate or ETL-filter-write the limited data necessary to this.
The thinking would be this simplifies management -- the service account has access to everything in that database.
Is this a common design pattern? I mean --- an alternative would be create a limited/ secure views on these tables ... maybe with a 'schema' name (more of a logical than physical separation) .. right? That would avoid write jobs, additional storage? Then grant access to this schema ... right?
Project lead also wants a separate warehouse (compute) for cost monitoring -- again probably not the most efficient but that can be done at the User level anyway --- is it possible or necessary to use "Shares" or "Replication" or are these completely different use cases and over-complicating matters? Just wondering thoughts -- thanks!
Asked by user45867
(1739 rep)
Feb 13, 2025, 03:40 PM
Last activity: Feb 14, 2025, 07:26 AM
Last activity: Feb 14, 2025, 07:26 AM