Database resources
database
DatabaseProvider
Database-scoped provider — deploys schemas, database roles, and grants within one database.
Parameters:
| Name | Type | Description | Default |
|---|---|---|---|
session
|
Any
|
Active Snowpark |
required |
Source code in src/pinky_provider/resources/database/__init__.py
6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 | |
apply(source, target, vars=None)
Apply the manifest to the target database.
Parameters:
| Name | Type | Description | Default |
|---|---|---|---|
source
|
str
|
|
required |
target
|
str
|
Target database as |
required |
vars
|
dict[str, str] | None
|
Jinja2 variables. |
None
|
Source code in src/pinky_provider/resources/database/__init__.py
29 30 31 32 33 34 35 36 37 | |
plan(source, target, vars=None)
Compute changes without applying them.
Parameters:
| Name | Type | Description | Default |
|---|---|---|---|
source
|
str
|
|
required |
target
|
str
|
Target database as |
required |
vars
|
dict[str, str] | None
|
Jinja2 variables. |
None
|
Returns:
| Type | Description |
|---|---|
list[Any]
|
Ordered list of :class: |
Source code in src/pinky_provider/resources/database/__init__.py
16 17 18 19 20 21 22 23 24 25 26 27 | |