Comments (5)
Is there any way to hook into the standard Connector failure handling behavior and send "bad" messages to a dead-letter topic?
from snowflake-kafka-connector.
We need to look into the null issue, but the design is to move all problematic data to the table stage for the target table. You can read more about table stages here, but the short of it is that each table has an associated stage named "@%mytable".
from snowflake-kafka-connector.
I found the mentioned table stage where the faulty messages are going, but it appears that the message contents is showing up under the record_metadata rather than the record_content, and the actual record_metadata is missing. I was required to create a file format with the error_on_column_count_mismatch configuration set to false in order to display the table stage.
from snowflake-kafka-connector.
The file content on table stage is what connector received from Kafka. Since it is invalid (not a JSON or Avro), Connector can't process. So connector directly write it into a file and save on table stage
from snowflake-kafka-connector.
This #171 PR would enable the connector to support non-snowflake converters. If you use native json/avro converters, DLQ is naturally supported.
from snowflake-kafka-connector.
Related Issues (20)
- Snowpipe Streaming Duplicate records / Not Exactly Once HOT 14
- Schema Evolution failing - Quoted field not being found in columnNames HOT 5
- Option to not create new columns in existing table HOT 2
- Ingesting real-time change data to Snowflake HOT 5
- Configuring temporal type formats with Snowpipe Streaming HOT 3
- Transactional ingest HOT 4
- NDJSON support. HOT 4
- `buffer.flush.time` setting not working correctly. HOT 10
- Struct array elements are being serialized before writing to Array column HOT 4
- CVE-2023-39410 in Snowflake-kafka-connect JAR HOT 1
- Where is the 2.1.1 release? HOT 2
- Using configProviders other than file fails validation HOT 3
- google.cloud.storage.StorageException: 401 Unauthorized, causing RECORD_METADATA Exception: Invalid column name HOT 3
- Snowflake Sink committing offsets for null/tombstone messages HOT 4
- `google.cloud.storage.StorageException: 401 Unauthorized` HOT 3
- SNOW-989387 Connectors errored out after updating to v2.1.2 HOT 18
- Insert order when using snowpipe streaming HOT 2
- Streaming Channel Offset Migration (transient exception) HOT 2
- SCHEMA EVOLUTION: Converting a String to Number Column HOT 2
- Ingestion loop when Snowflake Ingestion fails HOT 3
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from snowflake-kafka-connector.