...
| Table of Contents | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
|
Table management
| Note |
|---|
Both create and alter table procedures should only be called from SNP Glue™. Drop table procedure may be called on tables not created by SNP Glue™. |
...
| Code Block | ||
|---|---|---|
| ||
call core.copy_external_table(<Original_DB>, <Original_Schema>, <Table>, <App_DB>, <App_Source>); |
Merge
Resumes all merges inside a source.
...
| Code Block | ||
|---|---|---|
| ||
call core.deploy_merge(); -- All tables call core.deploy_merge(<Database>); -- All tables within one database call core.deploy_merge(<Database>, <Source>); -- All tables within one schema call core.deploy_merge(<Database>, <Source>, <Table>); -- One table |
Settings
Get settings of specified scope → APP for application settings, DEFAULT for default (template) source settings, <Source> for specific source settings.
...
app_name: Name of the application.
Database management
Create new database for the application.
...
| Code Block | ||
|---|---|---|
| ||
call core.delete_db(<Database>); |
Source management
Register a new source. It creates a new schema if it does not already exist and sets default source settings.
...
| Code Block | ||
|---|---|---|
| ||
call core.remove_source(<Database>, <Source>); |
Housekeeping
You can pause and resume housekeeping task by executing:
| Code Block | ||
|---|---|---|
| ||
call core.resume_housekeeping(); call core.suspend_housekeeping(); |
Cleanup
Drop an SNP Glue™ by specifying its source, type (view, stream, or task), and name.
...