airbyte icon indicating copy to clipboard operation
airbyte copied to clipboard

✨Source Aws Cloudtrail: Migrate Python CDK to Low-code CDK

Open btkcodedev opened this issue 10 months ago • 11 comments

What

Migrating Source Aws Cloudtrail to Low-Code CDK Closes airbytehq/airbyte-internal-issues#7042

How

Developed using (Configuration Based Source) low-code CDK

Recommended reading order

  1. spec.yaml
  2. manifest.yaml
  3. schemas/*

Tests

Integration & Acceptance
  • Test sucessfull

image

🚨 User Impact 🚨

  • Spec Breaking changes, migration to low-code

btkcodedev avatar Apr 10 '24 06:04 btkcodedev

The latest updates on your projects. Learn more about Vercel for Git ↗︎

Name Status Preview Comments Updated (UTC)
airbyte-docs ✅ Ready (Inspect) Visit Preview 💬 Add feedback Jun 25, 2024 7:13pm

vercel[bot] avatar Apr 10 '24 06:04 vercel[bot]

Inline Schema ✅ Poetry lock file ✅ Breaking change referred in metadata ✅ Add migration.md docs file ✅ Docs updated ✅ Incremental Sync :white_check_mark: Formatted :white_check_mark:

airbyte-ci test All pass state: Results: image

btkcodedev avatar Apr 10 '24 06:04 btkcodedev

Marking PR as ready to merge

btkcodedev avatar Apr 10 '24 06:04 btkcodedev

The region is hardcoded as the other regions us-west cannot be used while using Rest endpoints,the previous connector was using boto3 client for creating sessions, it was changed to custom Rest API approach, The Aws documentation is very poor regarding this, Other regions were tested as API base URL but not found working correctly. Thus the API URL could only use US-east region

btkcodedev avatar Apr 16 '24 01:04 btkcodedev

The region is hardcoded as the other regions us-west cannot be used while using Rest endpoints,the previous connector was using boto3 client for creating sessions, it was changed to custom Rest API approach, The Aws documentation is very poor regarding this, Other regions were tested as API base URL but not found working correctly. Thus the API URL could only use US-east region

@btkcodedev What do you mean when you say that it is not working properly for the REST API approach? I have used us-west-2 for your implementation, with deleted the LookupAttributes filter, and it is working as expected.

lazebnyi avatar Apr 16 '24 12:04 lazebnyi

Oh I haven't tried with filter deleted 😅, thanks for the info, I'll fix the comments 🙇

btkcodedev avatar Apr 16 '24 12:04 btkcodedev

@lazebnyi Thanks for the info about the filter, I've removed it, Currently the CI is getting timeout due to the high amount of record fetch with incremental sync, image

There is a need to change the Start_Date in config to the today's date to limit the records to pass the CI Thanks!

btkcodedev avatar Apr 17 '24 20:04 btkcodedev

There is a need to change the Start_Date in config to the today's date to limit the records to pass the CI Thanks!

@btkcodedev is today's date 17/04/2024 ?

lazebnyi avatar Apr 24 '24 22:04 lazebnyi

@lazebnyi The current date, example today- 30/04/2024 to fetch minimal records

btkcodedev avatar Apr 25 '24 03:04 btkcodedev

@lazebnyi, The connector is always getting timeout due to the high amount of records, Do you have any idea how to resolve this? adding a filter or something

btkcodedev avatar May 24 '24 16:05 btkcodedev

Connector is working perfectly, only problem is high amount of records

btkcodedev avatar May 24 '24 16:05 btkcodedev

The region is hardcoded as the other regions us-west cannot be used while using Rest endpoints,the previous connector was using boto3 client for creating sessions, it was changed to custom Rest API approach

If it needs boto3, perhaps we should move that to be a file-based source instead?

If using REST limits the connector to be available for just one region, that's bad and not what we want.

natikgadzhi avatar Jun 10 '24 18:06 natikgadzhi

No the problem is solved, it works on any regions, the problem here is its getting timed out as there are very high amount of records @natikgadzhi

btkcodedev avatar Jun 10 '24 18:06 btkcodedev

@btkcodedev The acceptance tests fail with timeout because the connector no longer limits the number of records during the tests. We need to find a new way to limit records.

tolik0 avatar Jun 19 '24 07:06 tolik0

Yes okay, I will look into it

btkcodedev avatar Jun 19 '24 07:06 btkcodedev

I've added a new filtering capability and sent credentials via slack, hope that does the job

btkcodedev avatar Jun 19 '24 17:06 btkcodedev

I've updated the connector to take the default start date at the current date and sent the config to Daniel Jablonski. Waiting for an update from him.

btkcodedev avatar Jun 20 '24 16:06 btkcodedev

Finally!!!! CI greeeen :white_check_mark:

image

btkcodedev avatar Jun 25 '24 09:06 btkcodedev

image

Thanks @tolik0 @natikgadzhi, Please merge if everything is fine

btkcodedev avatar Jun 25 '24 09:06 btkcodedev

@btkcodedev Please update the docs with the new default start_date.

tolik0 avatar Jun 25 '24 17:06 tolik0

@btkcodedev Please update the docs with the new default start_date.

Done

btkcodedev avatar Jun 25 '24 18:06 btkcodedev