Hello, I am trying to pull the data from Salesforce Marketing Cloud and load it into Snowflake.
The Salesforce Marketing Cloud integration component throws a hard [0] Not Authorized crash exactly 20 minutes into the job execution.
The underlying driver is entering an endless metadata loops parsing system tables and global schemas (HTTP|Res: 16990). The driver is spending the entire 20-minute window processing thousands of metadata payload lines before it ever issues the actual target data extraction command.
Snippet of the error I am getting: [0] Not Authorized.
The log file has been truncated because it’s too large.
If you require a full size logfile please visit our support website for full instructions.
You can access our support website via the help menu (top right)