Skip to content

Instantly share code, notes, and snippets.

@SimonGoring
Created June 9, 2021 17:46
Show Gist options
  • Save SimonGoring/c8f03f7c09ec77d0f5c71438ca9235f1 to your computer and use it in GitHub Desktop.
Save SimonGoring/c8f03f7c09ec77d0f5c71438ca9235f1 to your computer and use it in GitHub Desktop.
Condenser config File
{
"initial_targets": [
{
"table":"ndb.sites",
"percent": 100
}
],
"db_type": "postgres",
"source_db_connection_info": {
"user_name": "postgres",
"host": "localhost",
"db_name": "neotoma",
"password": "postgres",
"port": 5432
},
"destination_db_connection_info": {
"user_name": "postgres",
"host": "localhost",
"db_name": "export",
"port": 5432,
"password": "postgres"
},
"upstream_filters": [
{
"table": "ndb.constituentdatabases",
"where": "databaseid=28"
}
],
"excluded_tables": [
],
"passthrough_tables": [
"ndb.rocktypes",
"ndb.depenvttypes",
"ndb.chroncontroltypes",
"ndb.geopoliticalunits",
"ndb.taxa",
"ndb.lithostrat"
],
"fk_augmentation": [],
"post_subset_sql": [],
"keep_disconnected_tables": true,
"dependency_breaks": [
{"fk_table": "ndb.geopoliticalunits", "target_table": "geopoliticalunits"},
{"fk_table": "ndb.taxa", "target_table": "ndb.taxa"},
{"fk_table": "ndb.chroncontroltypes", "target_table": "ndb.chroncontroltypes"},
{"fk_table": "ndb.depenvttypes", "target_table": "ndb.depenvttypes"},
{"fk_table": "ndb.rocktypes", "target_table": "ndb.rocktypes"},
{"fk_table": "ndb.lithostrat", "target_table": "ndb.lithostrat"}
]
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment