1
0
mirror of synced 2025-12-21 02:51:29 -05:00
Commit Graph

482 Commits

Author SHA1 Message Date
Ben Church
5c56ac1d84 Airbyte-ci: Remove gradle task connectorAcceptanceTest (#30326) 2023-09-19 15:16:37 -05:00
Duy Nguyen
f226503bd1 [Source-MySQL] Enhanced Standard sync with PK initial load -> Cursor based switch over (#30270) 2023-09-18 17:17:00 -05:00
Marius Posta
a5eb24e2fc bump testcontainers version to latest (#30493) 2023-09-18 03:50:43 -05:00
Duy Nguyen
fca0b6f62e [Source-MySQL] Correctly set Debezium MySQL connector database timezone property (#30333)
Co-authored-by: subodh <subodh1810@gmail.com>
2023-09-14 16:10:14 -05:00
Rodi Reich Zilberman
0936143f1e 🐛 Only take table size info for streams syncing via primary key (#30375)
Co-authored-by: subodh <subodh1810@gmail.com>
2023-09-13 14:35:10 -05:00
Subodh Kant Chaturvedi
6f0c4e2594 mysql-source-cdc: enable compression logic for schema history (#30308)
Co-authored-by: subodh1810 <subodh1810@users.noreply.github.com>
Co-authored-by: Prateek Mukhedkar <prateek@airbyte.io>
2023-09-13 13:14:01 -05:00
Subodh Kant Chaturvedi
5a4cc0d8b0 source-mysql-cdc: introduce logic to compress schema history if greater than 3MB (#30289)
Co-authored-by: subodh1810 <subodh1810@users.noreply.github.com>
Co-authored-by: Prateek Mukhedkar <prateek@airbyte.io>
2023-09-13 12:41:28 -05:00
Subodh Kant Chaturvedi
ad47884297 postgres+mysql sources: use constants to keep checkpointing behaviour same (#30197)
Co-authored-by: subodh1810 <subodh1810@users.noreply.github.com>
2023-09-12 02:43:23 -05:00
Marius Posta
51c67d7eaa gradle: remove airbyteDocker.outputs dependencies (#30314) 2023-09-11 17:16:27 -07:00
Akash Kulkarni
09df4f4875 Enable MySQL CDC + PK 100% (#30213) 2023-09-07 15:32:29 -05:00
Marius Posta
ef2849e35e gradle: fix airbyteDocker task inputs (#30187) 2023-09-07 03:46:31 -07:00
Augustin
f8d9a38edd [skip ci] beta connectors should be community (#29577) 2023-09-04 19:36:16 +02:00
Akash Kulkarni
86b4e03092 Add escape quoting to selecting max (pk_field) query (#30059) 2023-08-31 18:01:35 -05:00
Lake Mossman
b19ed6d8b3 Support display_type property for oneOf fields and adjust CDC connectors to use it (#29821)
Co-authored-by: lmossman <lmossman@users.noreply.github.com>
2023-08-31 12:19:02 -05:00
Akash Kulkarni
da80408a53 Log storage engines used in MySQL (#30015)
Co-authored-by: Octavia Squidington III <octavia-squidington-iii@users.noreply.github.com>
Co-authored-by: akashkulk <akashkulk@users.noreply.github.com>
2023-08-30 18:35:46 -05:00
Jonathan Pearlin
13ef239ccc Source MongoDB Internal POC: CDC Metadata Injector (#29730)
Co-authored-by: jdpgrailsdev <jdpgrailsdev@users.noreply.github.com>
Co-authored-by: Jose Pefaur <jose.pefaur@gmail.com>
Co-authored-by: subodh <subodh1810@gmail.com>
2023-08-28 14:01:32 -05:00
Jonathan Pearlin
0724132a1a Source MongoDB Internal POC: Debezium Configuration Properties (#29727) 2023-08-28 08:44:39 -05:00
Marius Posta
f5c7c1c0b8 chore: get ./gradlew format to pass for the whole repo (same java style) (#29786) 2023-08-24 05:09:42 -05:00
Akash Kulkarni
cb3a4e0dc8 Initial load stopping condition (#29731) 2023-08-23 11:46:35 -05:00
Akash Kulkarni
e321b9e1ae source-mysql : Initial load. Handle composite pk case w/multiple repeated values (#29634)
Co-authored-by: subodh <subodh1810@gmail.com>
2023-08-22 16:12:00 -05:00
Duy Nguyen
b7dc462c4c [Source-MySQL]CDC: Enable frequent state emission during incremental runs (#29308) 2023-08-21 20:13:31 -05:00
Akash Kulkarni
2b18864f3b source-mysql : chunking queries impl (#29109) 2023-08-18 14:26:40 -05:00
Duy Nguyen
6ee426a261 [Source-Mysql] Set default cursor value for cdc mode (#28756) 2023-08-17 13:13:39 -05:00
Subodh Kant Chaturvedi
cc85da9a78 db-sources:sort primary key based on key-seq (#29346)
Co-authored-by: Akash Kulkarni <113392464+akashkulk@users.noreply.github.com>
2023-08-15 17:47:11 -05:00
Lake Mossman
cb863bb552 🎨 Source MySQL: Add 'Recommended' before CDC description (#29220)
* add 'Recommended' before CDC description

* bump version
2023-08-08 16:58:50 -05:00
Subodh Kant Chaturvedi
c9d6eb7833 mysql-cdc:implementation to validate that saved offset still exists on server (#29013)
* mysql-cdc:implementation to validate that saved offset still exists on server

* Automated Commit - Format and Process Resources Changes

* add the check to the main code flow + test

* address review comments

---------

Co-authored-by: subodh1810 <subodh1810@users.noreply.github.com>
2023-08-08 12:43:46 -05:00
Akash Kulkarni
807f104414 source-mysql : CDC PK snapshotting (#28757)
* Initial Commit of CDC PK snapshotting

* Added unit tests

* Flip to true

* Refactor flags

* Re-add flag

* Comment cleanup

* Code review comments

* Automated Commit - Format and Process Resources Changes

* minor refactor

* Address comments

---------

Co-authored-by: akashkulk <akashkulk@users.noreply.github.com>
Co-authored-by: subodh <subodh1810@gmail.com>
2023-08-04 13:57:51 -05:00
Lake Mossman
96df471940 🎨 Improve replication method selection UX (#28882)
* update replication method in MySQL source

* bump version

* update expected specs

* update registries

* bump strict encrypt version

* make password always_show

* change url

* update registries
2023-08-03 15:18:34 -05:00
Jonathan Pearlin
549e36f156 Proof of concept parallel source stream reading implementation for MySQL (#26580)
* Proof of concept parallel source stream reading implementation for MySQL

* Automated Change

* Add read method that supports concurrent execution to Source interface

* Remove parallel iterator

* Ensure that executor service is stopped

* Automated Commit - Format and Process Resources Changes

* Expose method to fix compilation issue

* Use concurrent map to avoid access issues

* Automated Commit - Format and Process Resources Changes

* Ensure concurrent streams finish before closing source

* Fix compile issue

* Formatting

* Exclude concurrent stream threads from orphan thread watcher

* Automated Commit - Format and Process Resources Changes

* Refactor orphaned thread logic to account for concurrent execution

* PR feedback

* Implement readStreams in wrapper source

* Automated Commit - Format and Process Resources Changes

* Add readStream override

* Automated Commit - Format and Process Resources Changes

* 🤖 Auto format source-mysql code [skip ci]

* 🤖 Auto format source-mysql code [skip ci]

* 🤖 Auto format source-mysql code [skip ci]

* 🤖 Auto format source-mysql code [skip ci]

* 🤖 Auto format source-mysql code [skip ci]

* Debug logging

* Reduce logging level

* Replace synchronized calls to System.out.println when concurrent

* Close consumer

* Flush before close

* Automated Commit - Format and Process Resources Changes

* Remove charset

* Use ASCII and flush periodically for parallel streams

* Test performance harness patch

* Automated Commit - Format and Process Resources Changes

* Cleanup

* Logging to identify concurrent read enabled

* Mark parameter as final

---------

Co-authored-by: jdpgrailsdev <jdpgrailsdev@users.noreply.github.com>
Co-authored-by: octavia-squidington-iii <octavia-squidington-iii@users.noreply.github.com>
Co-authored-by: Rodi Reich Zilberman <867491+rodireich@users.noreply.github.com>
Co-authored-by: rodireich <rodireich@users.noreply.github.com>
2023-08-03 13:23:52 -05:00
Ben Church
2f7deaee02 [skip ci] Metadata: Remove leading underscore (#29024)
* DNC

* Add test models

* Add model test

* Remove underscore from metadata files

* Regenerate models

* Add test to check for key transformation

* Allow additional fields on metadata

* Delete transform
2023-08-03 10:56:13 -07:00
Ben Church
e9490e3fb6 Connector Levels: Add new internal metadata fields (#28904)
* Add airbyte internal

* Add tests

* First pass

* Set destinations to same levels as sources

* Best guess at missing statuses

* Best guess at _ql

* Add separate enum class

* Fix support level name

* Update templates

* Add one more test
2023-08-01 18:08:33 -05:00
Subodh Kant Chaturvedi
bcb5a4df8d mysql-cdc: implementation to construct initial debezium state (#28561)
* wip

* wip 2

* add tests + finalise implementation

* undo unwanted changes

* Automated Commit - Format and Process Resources Changes

* minor refactor

* add comment

* make method public

---------

Co-authored-by: subodh1810 <subodh1810@users.noreply.github.com>
2023-07-26 06:18:23 -05:00
Duy Nguyen
633c939d46 [Source-postgres] Set default cursor value for cdc mode (#27442)
* use LSN as default cursor for postgres CDC

* Fixed static constant

* Set lsn default cursor value for postgres sync

* Bumped metadata and dockerfile versions

* Disable acceptance backwards compatibility discovery test as this is a breaking change

---------

Co-authored-by: Conor <cpdeethree@users.noreply.github.com>
2023-07-13 11:12:34 -05:00
Subodh Kant Chaturvedi
4ddd057039 source-postgres: implement logic to make CDC compatible with ctid (#27652)
* wip

* wip 2

* undo unwatned change

* some refactoring

* fix few tests

* more fixing

* more fixes

* Automated Commit - Format and Process Resources Changes

* more improvements

* 1 more test

* another test

* add flag for ctid enabling

* fix conflicts

* else block is not required

* use emittedAt

* skip WAL processing if streams under vacuuming

---------

Co-authored-by: subodh1810 <subodh1810@users.noreply.github.com>
Co-authored-by: Augustin <augustin@airbyte.io>
2023-07-06 13:37:28 -05:00
Evan Tahler
9ce3cc6e79 Java DB Source connector licenses to Elv2 (#27737)
* Java DB Source connector licenses to Elv2

* Bump PR Ids
2023-06-28 18:52:02 -07:00
Akash Kulkarni
2f807440da Fix issue in streaming JDBC database (#27212)
* Fix issue in streaming JDBC database

* Bump + publish

* 🤖 Auto format source-db2 code [skip ci]

* 🤖 Auto format source-mssql code [skip ci]

* 🤖 Auto format source-postgres-strict-encrypt code [skip ci]

* 🤖 Auto format source-postgres code [skip ci]

* 🤖 Auto format source-mssql-strict-encrypt code [skip ci]

* 🤖 Auto format source-oracle code [skip ci]

* 🤖 Auto format source-tidb code [skip ci]

* 🤖 Auto format source-snowflake code [skip ci]

* 🤖 Auto format source-redshift code [skip ci]

* 🤖 Auto format source-mysql code [skip ci]

* 🤖 Auto format source-mysql-strict-encrypt code [skip ci]

---------

Co-authored-by: octavia-squidington-iii <octavia-squidington-iii@users.noreply.github.com>
2023-06-20 12:08:47 -05:00
Ben Church
1dabc6208e Metadata: add tags field (#26320)
* Add optional tags field

* Remove duplicate icons

* Add programming tags to all

* Update docs

* supportUrl -> documentationUrl

* Ensure one language tag is applied

* Add keyvalue check

* rebase and fix tests

* Format

* Add cache buster

* Improve test

* Automated Commit - Formatting Changes

* Update error

* Fix missing tags

* Fix scaffold

---------

Co-authored-by: Octavia Squidington III <octavia-squidington-iii@sers.noreply.github.com>
Co-authored-by: bnchrch <bnchrch@users.noreply.github.com>
2023-05-26 16:13:09 -07:00
Subodh Kant Chaturvedi
9b9809b006 fix(cdc): limit queue size to lower memory consumption (#26473)
* fix(cdc): limit queue size to lower memory consumption

* add queue size attribute in spec

* disable retries

* fix log

* review comments

* add validation test for queue size

* update expected spec

* bump version + changelog

* update metadata files

---------

Co-authored-by: Ben Church <ben@airbyte.io>
2023-05-25 22:34:40 +05:30
Augustin
fd3655707e connectors-ci: add finalize_build logic to handle custom Dockerfiles (#26489) 2023-05-25 09:32:19 +02:00
Ben Church
248bbf94c1 HACKDAY: Icon CDN (#26158)
* Move icons to connector folder

* Delete old icons

* Update upload logic

* Add icon url to definitions

* Update registry model

* Populate cdn url

* DNC butcher the pipeline

* Low hanging fruit fixes

* Fix bucket name

* Merge old and new approaches

* Fix metadata upload step

* Format

* Fix test
2023-05-24 17:25:41 -07:00
Rodi Reich Zilberman
804087a052 Don't convert a string to binary base64 unnecessarily (#25586)
* Don't convert a string to binary base64 unnecessarily

* update doc

* update doc
2023-05-24 14:33:20 +00:00
Ryan Fu
8849669420 Destination Performance Harness: Adds support for incremental syncs with GLOBAL state message emission (#26443)
* Adds support for incremental syncs with GLOBAL state message emission

* Adds args to Source to not break, future work is to add same features to Source perf-harness and ./gradlew :spotlessJavaApply
2023-05-23 15:13:31 -07:00
Rodi Reich Zilberman
db799d3abd Bump image tag on metadata to trigger publish (#26442) 2023-05-23 11:39:17 -07:00
Rodi Reich Zilberman
2aa8a0dbbb Allow sessionvariables jdbc url param in source-mysql (#25859)
* initial commit

* cleanup

* cleanup

* Throw a configuration exception in case of bad jdbc url param

* End-to-End test session variable jdbc param

* reafctoring sanity

* sanity

* bump version and update note

* cherry pick fix to unrelated build error

* fix failing test

---------

Co-authored-by: Ryan Fu <ryan.fu@airbyte.io>
2023-05-22 18:53:33 -07:00
Davin Chia
8bfbef23cb Async Code V0 (#26324)
Split out the smallest set of reasonable changes from #26086 .

My goal was to split out the interface, as well as show how the interface it's meant to be used.

Follow up PRs:
- Split out classes from BufferManager and add more tests there.
- Add in the AsyncConsumer with tests.
- Add in the StagingConsumer factory.
2023-05-20 13:41:54 -07:00
Duy Nguyen
1a45a66133 Source Postgres: Number(38,0) is incorrectly translated to a destination Double instead of BigInt (#25898)
* Translate Numeric with no decimals to BigInt + relevant tests
* Update CDC to handle numeric/decimal arrays correctly
* Revert spacing
* Preserve Decimal scale of numeric columns
* Bumped versions to 2.0.29 + docs
* Bumped versions in metadata.yaml
* Automated Change

---------

Co-authored-by: nguyenaiden <nguyenaiden@users.noreply.github.com>
2023-05-18 13:02:27 -07:00
Ben Church
a94ce00876 Simple metadata fix (#25980) 2023-05-10 20:45:53 -05:00
Rodi Reich Zilberman
e598cc9a6c Convert source mysql decimal number with 0 decimal digits to an int (#25460)
* Convert source mysql decimal number with 0 decimal point to an int

* Put int representation in json for decimal with 0 decimal digits

* bump docker image ver and release note

* auto-bump connector version

---------

Co-authored-by: Octavia Squidington III <octavia-squidington-iii@users.noreply.github.com>
2023-05-10 16:19:57 -07:00
Akash Kulkarni
889a5bc50b Run formatter (#25901) 2023-05-09 10:03:22 -07:00
Ben Church
efbdb73e24 Bnchrch/metadata/add missing metadata files (#25899)
* Add source fullstory metadata

* Add source merge metadata

* Add source yotpo metadata

* Update normalization tag

* Update oss diffs

* Add aircall to cloud

* Pin Source sales force

* Ensure strict encrypt matches

* Remove zurora pin

* Make metadata validation mandatory

* Remove top level third party folders
2023-05-08 16:55:11 -05:00