matt_cooley
12/15/2020, 10:07 PMselect
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.matt_cooley
12/15/2020, 10:07 PMplugins:
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
This would be ideal:
table_names:
table_name: db_name-table_name
plugins:
extractors:
- name: tap-mysql
variant: transferwise
pip_url: pipelinewise-tap-mysql
config:
host: host
user: root
database: ${DB_NAME}
select:
- talbe_name.id
- table_name.email
metadata:
table_name:
replication-method: FULL_TABLE
douwe_maan
12/15/2020, 10:10 PMselect:
- "*-users.id"
- "*-users.email"
douwe_maan
12/15/2020, 10:11 PMobject
config values, not array
values as you're using here.matt_cooley
12/15/2020, 10:11 PMdouwe_maan
12/15/2020, 10:12 PMdouwe_maan
12/15/2020, 10:13 PMmatt_cooley
12/15/2020, 10:15 PMmatt_cooley
12/15/2020, 10:15 PMdouwe_maan
12/15/2020, 10:17 PMdouwe_maan
12/15/2020, 10:17 PMmeltano select tap-mysql --list --all
?matt_cooley
12/15/2020, 10:24 PMdouwe_maan
12/15/2020, 10:27 PMdouwe_maan
12/15/2020, 10:27 PMdatabase
, thoughmatt_cooley
12/15/2020, 10:57 PMdouwe_maan
12/15/2020, 11:09 PMdouwe_maan
12/16/2020, 4:41 PM