APPLY_INBOUND_SYNC_SETTINGS
Applies settings to an inbound sync/branch. If a BRANCH_NAME other than 'main' is provided and the branch doesn't exist, it will be created. If MATCH_REQUIRED is true and the provided SYNC_PARAMETERS and STREAMS_CONFIGURATION don't match, then the response 'data' element 'settingsApplied' will be false, along with 'mismatchDetails' which describe why. This is used by external schedulers such as dbt to know when their configuration definition is the correct one.
INBOUND_RECORDS_BEHAVIOUR
INBOUND_STREAM_STATE_BEHAVIOUR
OBJECT
APPLY_OUTBOUND_SYNC_SETTINGS
Applies settings to an outbound sync/branch. If a BRANCH_NAME other than 'main' is provided and the branch doesn't exist, it will be created. If MATCH_REQUIRED is true and the provided SYNC_PARAMETERS and STREAMS_CONFIGURATION don't match, then the response 'data' element 'settingsApplied' will be false, along with 'mismatchDetails' which describe why. This is used by external schedulers such as dbt to know when their configuration definition is the correct one.
OUTBOUND_RECORD_STATE_BEHAVIOUR
OUTBOUND_BRANCH_RECORD_FILTER
OBJECT
DELETE_OUTBOUND_STAGED_RECORDS_BY_APPLY_STATE
Deletes outbound records from the OUTBOUND_SYNC_RECORD_STATE table, if they match the given APPLY_STATE. This procedure is intended to only be used manually in emergencies, such as if duplicate identifiers somehow make their way past the checks into the table.
OBJECT
GET_INBOUND_ALL_STREAMS_VIEW_DEFINITIONS
Provides normalized view definitions to external systems like dbt, if it's their job to create them instead of the sync engine.
OBJECT
GET_INBOUND_STREAM_VIEW_DEFINITION
Provides a normalized view definition to external systems like dbt, if it's their job to create them instead of the sync engine.
OBJECT
MARK_RECORDS_FOR_SKIP
Marks a specific list of outbound records (by identifier) for skip in bulk.
OBJECT
MARK_STREAMS_FOR_FULL_REFRESH
Marks a set of streams for full refresh at the next scheduled run. Includes a flag which determines whether or not to truncate the tables.
OBJECT
Marks a sync as being paused, and suspends any related Snowflake tasks.
OBJECT
Marks a sync as scheduled, and resumes any associated Snowflake tasks.
OBJECT
Enqueues a sync run for processing, and optionally waits for it to finish. If WAIT_FOR_COMPLETION is false, the result of this call is information about whether the sync run was able to be enqueued. In this situation, a second task is manually ran which performs the processing.
If you provide this, SYNC_SLUG must be null.
If you provide this, SYNC_ID must be null.
Pass in 'main' for the main sync.
Provide the value 'external' if you are calling this proc from your own external scheduler.
Provide any values relevant to your external scheduler that you'd like to track.
'true' to execute the proc until the run completes, 'false' to return immediately and run asynchronously.
OBJECT
SET_INBOUND_SYNC_STATE
Manually overrides the current sync state for an inbound sync. Only intended to be used under the direction of support staff, as it's safest for plugins to maintain their own state.
OBJECT
Updates the name of a sync.
OBJECT
