The following SQL functions provide the primary modality for interacting with the extension PG_AUTO_DW. Functions are broken into two categories: informative and interactive. Interactive functions can change the data warehouse (DW).
These functions do not affect the database.
| Availability | Function | Purpose |
|---|---|---|
 |
health() |
Understand DW health. |
|
source_tables() |
Understand the status of all tables included for DW automation. |
|
source_columns() |
Understand the status of all table columns included for DW automation. |
These functions can only effect the data warehouse portion of the database.
| Availability | Function | Purpose |
|---|---|---|
|
source_include(object_pattern) |
Add source objects for DW automation. |
|
source_exclude(object_pattern) |
Remove source objects for DW automation. |
|
update_context(object, context) |
Provide information to facilitate DW automation. |
|
go(flag, status) |
Initiates DW builds and dataflows. |