Hi Team,
Hope you are doing well.
I am getting one issue when I am using tap-postgres and target-jsonl for my custom connector.
Can anyone please help.
> _(meltanoEnv) PS C:\Siba_\Work\POC_ConnectorFactory\Gerrit\Connector_Factory_Development\meltano-backend> meltano invoke tap-postgres_
>
2025-03-21T081517.883761Z [warning ] Failed to create symlink to 'meltano.exe': administrator privilege required
>
2025-03-21T081517.917544Z [info ] Environment 'dev' is active
>
2025-03-21 134520,737 | INFO | tap-postgres | Skipping deselected stream 'public-accounts'.
> _(meltanoEnv) PS C:\Siba_\Work\POC_ConnectorFactory\Gerrit\Connector_Factory_Development\meltano-backend>_
>
>
meltano=# \dp public.accounts
>
Access privileges
>
Schema | Name | Type | Access privileges | Column privileges | Policies
>
--------+----------+-------+----------------------------+-------------------+----------
>
public | accounts | table | postgres=arwdDxtm/postgres | |
>
(1 row)
>
>
meltano=#
>
> Below is my meltano.yml configuration.
> - name: tap-postgres
> namespace: tap_postgres
> pip_url: ./connectors/tap-postgres
> executable: tap-postgres
> config:
> database: meltano
> host: localhost
> port: 5432
> user: postgres
> password: ********
> filter_schemas: [public]
> select_all_tables: true # Or false, and use a selection JSON
> select_all_fields: true # If false, use a selection JSON to specify fields
> sqlalchemy_url: "
postgresql://postgres:"******"@localhost:5432/meltano"
>
> meltano=#
>
2025-03-21 134520,737 | INFO | tap-postgres | Skipping deselected stream 'public-accounts'.
> _(meltanoEnv) PS C:\Siba_\Work\POC_ConnectorFactory\Gerrit\Connector_Factory_Development\meltano-backend>_