Hey folks, First time with Meltano. interested in performing a very simple worflow: extracting from

tap-shopify

and loading to

postgres

postgres config: {

"add_record_metadata": true,

"database": "postgres",

"dialect+driver": "postgresql+psycopg2",

"hard_delete": false,

"host": "localhost",

"load_method": "append-only",

"password": "password",

"port": 5432,

"ssh_tunnel": {

"enable": false,

"port": 22

},

"ssl_certificate_authority": "~/.postgresql/root.crl",

"ssl_client_certificate": "~/.postgresql/postgresql.crt",

"ssl_client_certificate_enable": false,

"ssl_client_private_key": "~/.postgresql/postgresql.key",

"ssl_enable": false,

"ssl_mode": "verify-full",

"ssl_storage_directory": ".secrets",

"user": "meltano"

}

However while doing a

--full-refresh

I cannot see the data . Duummy json loader works fine. What I’m missing?

meltano run --full-refresh tap-shopify target-postgres

postgres=# \dt
Did not find any relations.
postgres=# \meltano
invalid command \meltano
Try \? for help.
postgres=# \dt
Did not find any relations.

Hi @servando_torres! So data is normally synced, but not not when

--full-refresh

is used?

Hi @edgar_ramirez_mondragon I'm using a full refresh because this is a Shopify Toy website. Has a few products, no sales. Data isn't displaying in PostgreSQL even when not using full refresh