Data Shepherd installs as a Snowflake Native App and runs inside your account. This page covers what it asks for and what it runs on. The usage guide has the SQL for each step.
What the app asks for
Three things, and nothing else:
EXECUTE TASK- so the app can run the single scheduling task it owns.EXECUTE MANAGED TASK- so that task is serverless and needs no warehouse you manage.- Read access to the tables you connect -
SELECTon each table you choose. This is the only access the app has to your data.
Snowsight asks you to approve the two task privileges at install. Your own roles need no task privilege. The app declares no external network access.
Alert delivery is optional and needs one more grant, made by an account admin: use of a notification integration. See Alerts and notifications.
Who can open the app
The role that installed the app can open it. Anyone else needs the app’s
APP_USER role granted to one of their roles first.
Connecting tables
Connect tables on the app’s Setup page - one table at a time, or every table in a schema. You can disconnect any table there too.
This version monitors tables and columns whose names are plain upper case - letters, digits and underscores. If a table was created with quoted mixed-case names, connect a view with plain upper-case names instead.
What it runs on
- The interface runs on whichever warehouse your session is using, and so do rules you run by hand and rule suggestions. Point a small, dedicated warehouse at it, with auto-suspend set to five minutes or more.
- Scheduled rules run on one serverless task, billed to your account rather than to a warehouse. Switched on with nothing due and alert delivery set up, it measured about 0.12 credits an hour, roughly 2.8 credits a day, on 11 November 2026. Switched off, which is how it ships, it costs nothing.
How long history is kept
Run history is kept for 180 days and alerts for 365 days by default. You can change these windows on the Settings page.
The record of configuration changes, the baselines that historical rules learn and your rule settings are kept until you uninstall the app. Old rows are cleared by the scheduling task, so nothing is cleared while scheduling is switched off.