Other data sources like your CRM will be powered by API access to that tool. As an example, here's a view of the BigQuery datasets from our production database: Your database will limit how you can replicate that data, but Fivetran provides connectors that cover most circumstance - as an example, our Heroku Postgres lacks logical replication support, so Fivetran falls back to periodically scanning tables and using xmin as a cursor, instead of reading WAL.įivetran will automatically manage the warehouse schema on your behalf, creating tables within the destination dataset for each table in the source. This data literally is our product, and your equivalent is likely the most high value data asset to push into your warehouse. incidents, every incident managed in the product.organisations, a row for each organisation using the product.incident.io has a monolithic application powered by Postgres, in which we store tables like: If you're building a SaaS product, one of the most crucial data sources will be whatever database powers your product. It's worth noting the variety of sources. Here's a view of the connectors we have configured in Fivetran:
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |