Description
I am getting one issue when I am using tap-postgres and target-jsonl for my custom connector.
(meltanoEnv) PS C:\Siba_\Work\POC_ConnectorFactory\Gerrit\Connector_Factory_Development\meltano-backend> meltano invoke tap-postgres
2025-03-21T08:15:17.883761Z [warning ] Failed to create symlink to 'meltano.exe': administrator privilege required
2025-03-21T08:15:17.917544Z [info ] Environment 'dev' is active
2025-03-21 13:45:20,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: siba1234
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:siba1234@localhost:5432/meltano"
Metadata
Metadata
Assignees
Type
Projects
Status