Hi,We are replicating between SQL Server and Snowflake using HVR 6 / LDP.One consideration impacting reporting against both environments is the different behaviour when it comes to handling varchar data with trailing spaces.SQL Server (intuitively..?...
Introduction I recently put myself in the position of a customer analysing a new data source for their business, with the goal to understand the best ways to ingest data to answer customer queries effectively. To do this, I took on the role of a data...
I suppose Fivetran stores metadata of souce system, but does it also store metadata of destination table? And does Fivetran regularly pulls destination schema to maintain its own metadata repo and warning of schema changes ?Or does Fivetran simply us...
In our Postgres database we have a jsonb[] field. The Postgres connector converts all of them to strings, which we then parse with BigQuery.Old values (on initial sync) are serialized like this:["{\"key\": \"value\"}","{\"key\": \"value\"}"]But newly...
Hi team!We are using the Stripe Connector in Fivetran to sync data from Stripe into BigQuery. Recently, we triggered a re-sync of the payment_method_card (and later-on the payment_method) tables. However, after the re-sync we are missing a lot of row...