WebhookDB can take its nicely schematized and normalized data and send it to any other database. Usually this means a data warehouse like Snowflake, Redshift, or some other Postgres instance. Most other database syncing systems update your data only periodically, but WebhookDB will sync data in near-real-time.
DB Sync is pretty easy to get going. When you run
webhookdb dbsync create <integration id or table>,
we'll prompt you for the connection string and sync interval
(sync intervals can even be lowered to zero for near-real-time, but you'll need a paid license for that).
By default, we'll replicate to the
public schema and the same table name as the integration's table,
or you can provide the schema and table name.
$ webhookdb integrations list NAME TABLE ID stripe_customer_v1 stripe_customer_v1_8f82 svi_6i8987gxug15z0mxhi0dhwns0 $ webhookdb dbsync create stripe_customer_v1 Enter the database connection string that WebhookDB should sync data to: postgres://user:pass@dburl/db How many seconds between syncs (60 to 86400): 800 Every 800 seconds, data from stripe_customer_v1 in stripe_customer_v1_8f82 will be synchronized to postgres://***:***@dburl/db
You can also provide the schema and table with flags (this will sync to
stripe.customers in the configured database):
$ webhookdb dbsync create stripe_customer_v1 --schema stripe --table customers stripe_customer_v1_8f82
Once the DB sync is successfully set up, it will periodically post new information to the endpoint using the interval you provided.
You can also trigger a sync manually using the command
webhookdb dbsync trigger.
We currently support syncing with Postgres & Snowflake databases. Other databases, including Redshift, BigQuery, MySQL, and SQL Server are still experimental. Please get in touch if you need access.
For more information on working with DB Syncing, you can check out the
dbsync manual page.