- DMS: Added option
ignore_ddlto ignore DDL events - DMS: Added direct column mapping
- DMS: Started using direct column mapping by default
- DMS: Started using the mapping value
OBJECTwhen defining column types
- Dependencies: Migrated from
zyptotikray. It's effectively the same, but provided using a dedicated package now - CI: Added support for Python 3.13
- DMS: Fixed handling of primary keys
- DMS: Added support for the previously missing
drop-tableoperation - DMS: Fixed primary key / where clause rendering
- DynamoDB/Testing: Use CrateDB nightly again
- DynamoDB: Use
ON CONFLICT DO NOTHINGclause on CDC operations of typeINSERT, to mitigate errors when events are relayed redundantly from retries after partially failed batches on the Lambda processor.
- MongoDB: Fixed BSON decoding of
{"$date": 1180690093000}timestamps - DynamoDB/Testing: Use CrateDB 5.8.3 for because 5.8.4 can no longer
store
ARRAYs with varying inner types intoOBJECT(IGNORED)columns.
- DynamoDB: Change CrateDB data model to use (
pk,data,aux) columns Attention: This is a breaking change. - MongoDB: Handle too large
$date.$numberLongvalues gracefully - Zyp/Moksha: Improve error reporting when rule evaluation fails
- DynamoDB CDC: Fix
MODIFYoperation by propagatingNewImagefully - Zyp/Moksha: Improve error reporting when rule evaluation fails
- MongoDB: Improved
MongoDBCrateDBConverter.decode_canonicalto also decode non-UUID binary values - Zyp/Moksha/jq:
to_objectfunction now respects azapoption, that removes the element altogether if it's empty - Zyp/Moksha/jq: Improve error reporting at
MokshaTransformation.apply - MongoDB: Improved
MongoDBCrateDBConverter.decode_extended_json
- MongoDB: Fixed edge case when decoding MongoDB Extended JSON elements
- Zyp: Added capability to skip rule evaluation when
disabled: true
- MongoDB: Added
MongoDBFullLoadTranslatorandMongoDBCrateDBConverter - Zyp: Fixed execution of collection transformation
- Zyp: Added software test and documentation about flattening lists
- MongoDB: Use
bsonpackage to parse BSON CANONICAL representation - MongoDB: Complete and verify BSON data type mapping end-to-end
- MongoDB: Use improved decoding machinery also for
MongoDBCDCTranslator - Dependencies: Make MongoDB subsystem not strictly depend on Zyp
- Zyp: Translate a few special treatments to jq-based
MokshaTransformationagain - Zyp: Improve documentation
- Packaging: Add missing
MANIFEST.in
- Added Zyp Treatments, a slightly tailored transformation subsystem
- Replace poor man's relation name quoting with implementation
quote_relation_namefromsqlalchemy-cratedbpackage. - DynamoDB: Add special decoding for varied lists, storing them into a separate
OBJECT(IGNORED)column in CrateDB - DynamoDB: Improve
to_sql()to accept list of records
- DMS/DynamoDB: Use parameterized SQL WHERE clauses instead of inlining values
- DMS/DynamoDB/MongoDB: Use SQL with parameters instead of inlining values
- DynamoDB: Fix serializing OBJECT and ARRAY representations to CrateDB
- DynamoDB: Fix
Maprepresentation to CrateDB.
- DynamoDB: Fix
String SetandNumber Setrepresentation for CrateDB - DynamoDB: Fix serializing empty strings
- DynamoDB: Apply rough type evaluation and dispatching when computing
values for
UPDATEstatements
- DynamoDB: Fixed a syntax issue with
textdata type inUPDATEstatements
- Changed
UPDATEstatements from DMS not to write the entiredatacolumn. This allows defining primary keys on the sink table.
- Changed
UPDATEstatements from DynamoDB not to write the entiredatacolumn. This allows defining primary keys on the sink table.
- Added Zyp Transformations, a minimal transformation engine based on JSON Pointer (RFC 6901).
- Added documentation using Sphinx and Read the Docs
- Added transformer for AWS DMS to CrateDB SQL
- Dropped support for Python 3.7
- Added transformer for MongoDB CDC to CrateDB SQL conversion
- Rename "Airrohr" decoder to "Sensor.Community"
- Added decoders for Airrohr, Tasmota, and TTS/TTN from Kotori DAQ
- Added transformer for DynamoDB CDC to CrateDB SQL conversion