Salesforce Marketing Cloud

Maia
1

Hi,I am trying to pull data from Salesforce Marketing Cloud and push the data into Snowflake. However for of the tables the job is failing with the below error: An error occurred while staging data to the warehouse. Could not ensure all data was staged into Snowflake.

2026-06-05T06:56:30.069+0000 2 [9974|Q-Id] [AUTH|Messag] Warning: An error was encountered when writing the OAuthSettings to disk: [ at com.matillion.bi.emerald.server.oauth.itokenstore.NoOpITokenStore.writeToken(NoOpITokenStore.java:27)
at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
at java.base/java.lang.reflect.Method.invoke(Method.java:580)
… [Truncated for brevity] …
at com.matillion.bi.emerald.server.snowflake.staging.JDBCQueryToSnowflakeStager.uploadToStagingLocation(JDBCQueryToSnowflakeStager.java:66)
at com.matillion.bi.emerald.server.snowflake.staging.SnowflakeStager.stage(SnowflakeStager.java:77)
at com.matillion.bi.emerald.server.snowflake.staging.SnowflakeStager.doStage(SnowflakeStager.java:46)
at com.matillion.bi.emerald.component.implementation.orchestration.PropertiesLoader.orchestrate(PropertiesLoader.java:283)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1144)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642)
at java.base/java.lang.Thread.run(Thread.java:1583)]. Please try running the application as Administrator or setting ‘OAuthSettingsLocation’ to an accessible location on disk.

SUMMARY:

  • Platform: Matillion Data Productivity Cloud (SaaS)
  • Component: Salesforce Marketing Cloud Query
  • Rows extracted: 573,716
  • Pages fetched: 1,152 (pageSize=500)
  • Total extraction time: ~104 minutes
  • Token store: NoOpITokenStore (platform-managed)
  • Connector driver: SF Marketing Cloud CData (build 230.8669)

FAILURE:
“An error occurred while staging data to the warehouse. Could not ensure all data was staged into Snowflake.”

OBSERVATIONS:

  1. The OAuth warning fires from NoOpITokenStore — a platform-internal implementation,
    not configurable via connection options or OAuthSettingsLocation.
  2. Data extraction completed successfully (all 573K rows received from API).
  3. Failure occurs during Snowflake internal stage upload (JDBCQueryToSnowflakeStager).
  4. Pipeline fails intermittently.

Any configurations changes that can help us with getting rid of this error or help us better understand what does this actually means, as it is affecting few of the tables.