*Running and Schedule a pipeline*: Hi, i'm using M...
# troubleshooting
j
Running and Schedule a pipeline: Hi, i'm using Meltano on the docker container. I've set tap-mysql and target-bigquery and i'm able to run it both from the UI and command line. All tables are set with replication method = LOG_BASED. 1. If i run it from the command line using this command: docker run -v $(pwd):/project -w /project meltano/meltano --log-level=debug elt tap-mysql target-bigquery it seems that it doesn't keep the state. Can this be because it creates a new container and it's ephemeral? What's the best way of synchronizing this with the UI container? 2. When i schedule the pipeline in the UI and set it to run every hour, nothing happens. I've checked meltano.yml and the metadata is there. Any idea what can be the issue? Below is the content of meltano.yml
Copy code
schedules:
- name: mysql-to-bigquery
  extractor: tap-mysql
  loader: target-bigquery
  transform: skip
  interval: 0 */1 * * *
  start_date: 2022-06-10 10:36:19.142156