Uploaded image for project: 'Subscription Watch'
  1. Subscription Watch
  2. SWATCH-3650

Cron Job to Enable Publishing of data to Fivetran

XMLWordPrintable

    • Icon: Story Story
    • Resolution: Won't Do
    • Icon: Undefined Undefined
    • None
    • None
    • dataverse
    • None
    • False
    • Hide

      None

      Show
      None
    • False

      In order for fivetran to read from our database we need to configure logical replication on our read replica db. 

      All tables should should be enabled for publication and a replication_slot created.

      Start at step 4:
      https://fivetran.com/docs/connectors/databases/postgresql/rds-setup-guide#configureincrementalupdates

      Done:

      • Cron Job that run's necessary sql using a superuser (app default should work)
      • Replication slot created
      • Publications created
      • Fivetran user granted access to rds_replication

       

              Unassigned Unassigned
              kflahert@redhat.com Kevin Flaherty
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Created:
                Updated:
                Resolved: