Perhaps a dumb question, where does Meltano's basic pipeline output data? The UI shows some data, but no data found in the Postgres DB as referenced by the

.env

file with localhost values, even after a restart of

meltano ui

. Stripe's connection logs show tables have been created and records have been inserted. psql's

\l

and

\d

shows nothing newly created.

@john_g Are you looking at the correct schema? If you’re not using a transformation, the data will be loaded into a schema named after the plugin’s namespace (e.g. tap_gitlab for tap-gitlab). If you are using transformations, the data will ultimately end up in the analytics schema

Other than the .env file, it is default everything. Stripe has been connected with the following logs:

Running with dbt=0.14.4
Found 26 models, 15 tests, 0 snapshots, 0 analyses, 118 macros, 0 operations, 0 seed files, 0 sources

16:46:39 | Concurrency: 2 threads (target='postgres')
16:46:39 |
16:46:39 | 1 of 18 START table model analytics.stripe_balance_transactions...... [RUN]
16:46:39 | 2 of 18 START table model analytics.stripe_dates..................... [RUN]
16:46:39 | 1 of 18 OK created table model analytics.stripe_balance_transactions. [SELECT 40 in 0.10s]
16:46:39 | 3 of 18 START table model analytics.stripe_invoice_items............. [RUN]
16:46:39 | 3 of 18 OK created table model analytics.stripe_invoice_items........ [SELECT 5 in 0.05s]
16:46:39 | 4 of 18 START table model analytics.stripe_invoices.................. [RUN]
16:46:39 | 4 of 18 OK created table model analytics.stripe_invoices............. [SELECT 87 in 0.04s]
16:46:39 | 5 of 18 START table model analytics.stripe_charges................... [RUN]
16:46:39 | 5 of 18 OK created table model analytics.stripe_charges.............. [SELECT 28 in 0.04s]
16:46:39 | 6 of 18 START table model analytics.stripe_coupons................... [RUN]
16:46:39 | 6 of 18 OK created table model analytics.stripe_coupons.............. [SELECT 8 in 0.04s]
16:46:39 | 7 of 18 START table model analytics.stripe_customers................. [RUN]
16:46:39 | 7 of 18 OK created table model analytics.stripe_customers............ [SELECT 138 in 0.07s]
16:46:39 | 8 of 18 START table model analytics.stripe_events.................... [RUN]
16:46:39 | 2 of 18 OK created table model analytics.stripe_dates................ [SELECT 18403 in 0.36s]
16:46:39 | 9 of 18 START table model analytics.stripe_invoice_line_items........ [RUN]
16:46:39 | 8 of 18 OK created table model analytics.stripe_events............... [SELECT 349 in 0.07s]
16:46:39 | 10 of 18 START table model analytics.stripe_payouts.................. [RUN]
16:46:39 | 9 of 18 OK created table model analytics.stripe_invoice_line_items... [SELECT 290 in 0.07s]
16:46:39 | 11 of 18 START table model analytics.stripe_plans.................... [RUN]
16:46:39 | 10 of 18 OK created table model analytics.stripe_payouts............. [SELECT 11 in 0.06s]
16:46:39 | 12 of 18 START table model analytics.stripe_subscription_items....... [RUN]
16:46:39 | 11 of 18 OK created table model analytics.stripe_plans............... [SELECT 14 in 0.06s]
16:46:39 | 13 of 18 START table model analytics.stripe_subscriptions............ [RUN]
16:46:39 | 12 of 18 OK created table model analytics.stripe_subscription_items.. [SELECT 36 in 0.06s]
16:46:39 | 14 of 18 START table model analytics.stripe_transfers................ [RUN]
16:46:39 | 13 of 18 OK created table model analytics.stripe_subscriptions....... [SELECT 9 in 0.07s]
16:46:39 | 15 of 18 START table model analytics.stripe_invoice_items_xf......... [RUN]
16:46:39 | 15 of 18 OK created table model analytics.stripe_invoice_items_xf.... [SELECT 5 in 0.06s]
16:46:39 | 16 of 18 START table model analytics.stripe_balance_stats_per_day.... [RUN]
16:46:39 | 14 of 18 OK created table model analytics.stripe_transfers........... [SELECT 0 in 0.07s]
16:46:39 | 17 of 18 START table model analytics.stripe_balance_stats_per_month.. [RUN]
16:46:39 | 17 of 18 OK created table model analytics.stripe_balance_stats_per_month [SELECT 605 in 0.07s]
16:46:39 | 18 of 18 START table model analytics.stripe_balance_stats_per_week... [RUN]
16:46:39 | 16 of 18 OK created table model analytics.stripe_balance_stats_per_day [SELECT 18403 in 0.08s]
16:46:39 | 18 of 18 OK created table model analytics.stripe_balance_stats_per_week [SELECT 2629 in 0.05s]
16:46:39 |
16:46:39 | Finished running 18 table models in 1.33s.

Completed successfully

Done. PASS=18 WARN=0 ERROR=0 SKIP=0 TOTAL=18
Transformation complete!

😄