Skip to content

feat(grants): support Openflow account privileges (CREATE OPENFLOW ... INTEGRATION) #31

Description

@GClunies

What & Why

Snowflake Openflow (managed data ingestion, GA 2025) introduces account-level privileges that snowcap's GlobalPrivs enum doesn't know about, so granting a team the ability to run Openflow must be done with manual SQL:

GRANT CREATE OPENFLOW DATA PLANE INTEGRATION ON ACCOUNT TO ROLE data_engineer;
GRANT CREATE OPENFLOW RUNTIME INTEGRATION   ON ACCOUNT TO ROLE data_engineer;

grep -ri openflow snowcap/ returns nothing today.

Acceptance Criteria

  • CREATE OPENFLOW DATA PLANE INTEGRATION and CREATE OPENFLOW RUNTIME INTEGRATION added to account-level privileges in snowcap/privs.py
  • Grantable via YAML (priv: ... on_account: true) and applied correctly
  • Fetch/plan round-trips these grants without spurious drift
  • Docs (snowflake-permissions page) mention the new privileges

Resources

  • Snowflake docs: Openflow
  • Snowcap: snowcap/privs.py (no OPENFLOW entries)

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Fields

    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions