SQLite cloudquery plugin does not work

[moadibfr]

Expected Behavior

The plugin will fail with an error saying the sqlite plugin is not found.

Actual Behaviour

No response

Steps To Reproduce

No response

Environment Information

• Plugin version: 0.13.0

Example flow

❯ cat aws.yml
spec:
path: cloudquery/aws
tables:

• aws_cloudtrail_events
  destinations:
• sqlite
  name: aws
  version: v22.13.2
  spec:
  custom_endpoint_url: http://127.0.0.1:32835
  custom_endpoint_hostname_immutable: "true"
  max_retries: 0
  custom_endpoint_partition_id: aws
  custom_endpoint_signing_region: us-east-1
  kind: source
  ❯ cat sqlite.yml
  spec:
  version: v2.3.0
  name: sqlite
  spec:
  connection_string: ./db.sqlite
  path: cloudquery/sqlite
  kind: destination

[moadibfr]

cloudquery bug report submitted here: cloudquery/cloudquery#14465

[aitoehigie]

Is this issue related to this error while trying to use sqlite destination plugin?
Binary was compiled with 'CGO_ENABLED=0', go-sqlite3 requires cgo to work. This is a stub

[Ben8t]

cloudquery/cloudquery#14465 is fixed

@moadibfr are you still facing the issue ?

[the-raja]

Here is the possible solution that might work.

1. Ensure the Plugins are Installed Correctly
   cloudquery plugins list

2. If the sqlite plugin isn’t listed, install it
   cloudquery plugins install cloudquery/sqlite

3. Check if the aws plugin is installed
   cloudquery plugins install cloudquery/aws

4. Verify YAML Configuration

5. aws.yml

spec:
  path: cloudquery/aws

  tables:

    - aws_cloudtrail_events
    - 
  destinations:

    - sqlite
  name: aws

  version: v22.13.2

  spec:

    custom_endpoint_url: http://127.0.0.1:32835

    custom_endpoint_hostname_immutable: "true"

    max_retries: 0

    custom_endpoint_partition_id: aws

    custom_endpoint_signing_region: us-east-1

  kind: source

2. sqlite.yml

spec:

  version: v2.3.0

  name: sqlite

  spec:

  connection_string: ./db.sqlite

  path: cloudquery/sqlite

  kind: destination