airbytehq / airbytehq/airbyte

Iterable source into Snowflake destination - email_sent - transactionalData is failing to parse due to schema error on snowflake

未关闭
#69,348 0 条评论 0 个 reaction 已指派 0 人 在 GitHub 查看
area/connectors autoteam community connectors/source/iterable needs-triage team/extensibility team/use type/bug
主要语言
Python
星标
22.1k
派生
5.3k
PR 合并指标
PR 指标待抓取

描述

### Connector Name

source-iterable

### Connector Version

0.6.53

### What step the error happened?

During the sync

### Relevant information

on Snowflake destination - "changes": [
{
"change": "NULLED",
"field": "transactionalData",
"reason": "DESTINATION_SERIALIZATION_ERROR"
}
],
on all records
the issue is that field transactionalData is mapped into object when it should be mapped as simple varchar.

Snowflake destination maps this as "TRANSACTIONALDATA" OBJECT
instead of VARIANT
--

### Relevant log output

```shell
"changes": [
{
"change": "NULLED",
"field": "transactionalData",
"reason": "DESTINATION_SERIALIZATION_ERROR"
}
],
```

### Contribute

- [ ] Yes, I want to contribute

贡献指南

打开贡献指南

评估

这个 Issue 还没有评估数据。

把新 issue 发到你的邮箱

精选适合新手参与的 GitHub issue 摘要。