Jimmy P.

Commented on Best Practices and Documentation for Role Manageme...·Posted inHelp

so I come from a more Snowflake/BigQuery background, and my understanding of Role Management of the objects (e.g. tables) are still limited) from what I understood so far, it seems that Motherduck is literally the host of the DuckDBs. and all DuckDBs have to be owned by an account (either human account or a Service Account). so I assume the pattern here should be: Production Service Account owns:

Production DB; THEN,
Share of the Production DB and let the whole Org discover it

Staging Service Account owns

Staging DB; THEN,
Share of the Staing DB and let the data team discover it

this is the encouraged pattern I see so far, I am just wondering if there are further instruction of best pratices and the pattern of separating Production/Staging env here

Posted in Help·

Jimmy P.

Best Practices and Documentation for Role Management in Motherduck

hey folks curious q: I am just getting started with Motherduck and got a bit confused with the best pratices with role mangement - wonder what would be the best pratices there? and if there is any existing documentation?

3Comments

About

Start Date
Title