# synchronizingTable
State Resource
This is a State Resource as provided by the tymly-pg-plugin plugin.
# Purpose
Takes the contents of one PostgreSQL table, applies a transformation function to each row and ensures a target table is kept in sync - just a thin wrapper over pg-telepods (opens new window)
# Usage
# Example
{
"synchronizingTable": {
"options": {
"transformerFunctionName": "someBlueprintFunction",
"source": {
"tableName": "someNamespace.some_table_name",
"hashSumColumnName": "hash_sum"
},
"target": {
"tableName": "someNamespace.another_table_name",
"hashSumColumnName": "origin_hash_sum"
},
"join": {
"source_pk_column": "target_pk_column"
}
}
}
}
# Options
# Optional properties
# transformerFunctionName
Identifies which blueprint function should be used to undertake transformation duties. See pg-telepods (opens new window) for more information.
- Type:
string
# source
Used to define a source table along with any other attributes (such as a hash sum column) for where data is to be sourced from. See pg-telepods (opens new window) for more information.
- Type:
object
# target
Likewise, defines a target table with similar attributes explaining where data is to sent to. See pg-telepods (opens new window) for more information.
- Type:
object
# join
A simple object denoting how primary keys on both tables are related - where key values are the name of a column on the source table and its value is a column on the target table.
- Type:
object