Snapchat Marketing Connector - No Records Loaded Issue

Slack Knowledge Base Q&A Connector Questions
, , , ,
1

Summary

The user is facing an issue with the Snapchat Marketing v1.2.12 connector where no records are being loaded despite the job finishing successfully. The logs show that data is processed but not taken from streams. The user is seeking advice on the possible reasons for this problem.


Question

Hey community
I’m using Snapchat Marketing v1.2.12 connector and I’m getting no records loaded every time the job’s finished successfully
As I see, some data is processed, however no data seems to be taken from streams:

  "status" : "completed",
  "recordsSynced" : 0,
  "bytesSynced" : 0,
  "startTime" : 1728990627711,
  "endTime" : 1728990646241,
  "totalStats" : {
    "bytesCommitted" : 0,
    "bytesEmitted" : 0,
    "destinationStateMessagesEmitted" : 5,
    "destinationWriteEndTime" : 1728990646025,
    "destinationWriteStartTime" : 1728990627798,
    "meanSecondsBeforeSourceStateMessageEmitted" : 0,
    "maxSecondsBeforeSourceStateMessageEmitted" : 1,
    "maxSecondsBetweenStateMessageEmittedandCommitted" : 3,
    "meanSecondsBetweenStateMessageEmittedandCommitted" : 2,
    "recordsEmitted" : 0,
    "recordsCommitted" : 0,
    "replicationEndTime" : 1728990646238,
    "replicationStartTime" : 1728990627711,
    "sourceReadEndTime" : 1728990644921,
    "sourceReadStartTime" : 1728990627799,
    "sourceStateMessagesEmitted" : 5
  },
  "streamStats" : [ {
    "streamName" : "campaigns",
    "stats" : {
      "bytesCommitted" : 0,
      "bytesEmitted" : 0,
      "recordsEmitted" : 0,
      "recordsCommitted" : 0
    }
}, {
    "streamName" : "ads_stats_daily",
    "stats" : {
      "bytesCommitted" : 0,
      "bytesEmitted" : 0,
      "recordsEmitted" : 0,
      "recordsCommitted" : 0
    }
  }, {
    "streamName" : "adsquads",
    "stats" : {
      "bytesCommitted" : 0,
      "bytesEmitted" : 0,
      "recordsEmitted" : 0,
      "recordsCommitted" : 0
    }
  }, {
    "streamName" : "adaccounts",
    "stats" : {
      "bytesCommitted" : 0,
      "bytesEmitted" : 0,
      "recordsEmitted" : 0,
      "recordsCommitted" : 0
    }
  }, {
   "streamName" : "ads",
    "stats" : {
      "bytesCommitted" : 0,
      "bytesEmitted" : 0,
      "recordsEmitted" : 0,
      "recordsCommitted" : 0
    }
  } ],
  "performanceMetrics" : {
    "processFromSource" : {
      "elapsedTimeInNanos" : 263443763,
      "executionCount" : 15,
      "avgExecTimeInNanos" : 1.7562917533333335E7
    },
    "readFromSource" : {
      "elapsedTimeInNanos" : 5998954472,
      "executionCount" : 41867,
      "avgExecTimeInNanos" : 143285.98829627153
    },
    "processFromDest" : {
      "elapsedTimeInNanos" : 344026064,
      "executionCount" : 5,
      "avgExecTimeInNanos" : 6.88052128E7
    },
    "writeToDest" : {
      "elapsedTimeInNanos" : 291377331,
      "executionCount" : 5,
      "avgExecTimeInNanos" : 5.82754662E7
    },
    "readFromDest" : {
      "elapsedTimeInNanos" : 6803074768,
      "executionCount" : 400519,
      "avgExecTimeInNanos" : 16985.64804166594
    }
  }
}```
could you pls advise what might be the reason?

<br>

---

This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. [Click here](https://airbytehq.slack.com/archives/C021JANJ6TY/p1728993323987649) if you want 
to access the original thread.

[Join the conversation on Slack](https://slack.airbyte.com)

<sub>
["snapchat-marketing-connector", "no-records-loaded", "data-processing", "streams"]
</sub>
2

Hi! I’m getting the same error here and was wondering if you managed to figure out what the issue was?

3

Did you need to change some config? Just trying to solve it now on my end!

4

basically, you need to set start date earlier
there is a problem with a cursor for all streams (I mean in YAML manifest)
so you need to adjust start date to be not later than updated_at value for required organization_id

5

Thanks for this info! Unfortunately didn’t solve my problem, but appreciate the pointers.