https://linen.dev logo
#plugins-general
Title
# plugins-general
m

matt_cooley

12/15/2020, 10:07 PM
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:
Copy code
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.