Skip to main content

Hi all- 

I'm using the Snowflake data connector and have the Data Sync and Dataflow set up.  Both run without any reported problems (all 200k rows in/out, 0 rows failed).  However, when actually using the dataset in analytics I discovered that there was missing data in individual records.  For example, in the ID field instead of having the actual ID value in some rows it is showing as blank/null in analytics. I compared each individual column in the source data and in Analytics and there were missing values across all columns. For example, looking at my ID field which should have values across all rows, has ~27k missing values. Looking at each individual column the number of missing values ranged anywhere from around 100 to many thousands.  I've tried repopulating the source table in snowflake and rerunning the Data Sync/Flow, creating a net new connection, creating the connection in our sandbox salesforce environment and I continue to have the issue but the numbers of missing values fluctuates and the actual records impacted changes. For example, after one run the ID column I was first missing 26883 records, then 26962, then 26880 and so on, so there is some consistency in the relative number of fields impacted.  

I'm absolutely stumped so any ideas would be super helpful, thanks!

2 条评论
  1. 2020年2月7日 17:27
    Thank you @Chris Ames! I've put the work around in place on one of my datasets and everything looks good and I'll have someone log a case on my behalf. Thanks again!
0/9000