Hi, I’m using the mysql tap and I’m having some trouble using environment variables in the

select

statement. I need to do this because my local database has a different name than my stage and prod database. Here’s an example of what I’m trying to do:

plugins:
  extractors:
  - name: tap-mysql
    variant: transferwise
    pip_url: pipelinewise-tap-mysql
    config:
      host: host
      user: root
      database: ${DB_NAME}
    select:
    - ${DB_NAME}-table_name.id
    - ${DB_NAME}-table_name.email
    metadata:
      ${DB_NAME}-table_name:
        replication-method: FULL_TABLE

That doesn’t work. It doesn’t recognize the columns I’m trying to select. I’ll add what does work and what I’d ideally like to do in the thread.