Is there any way to bulk load table from a particu...
# getting-started
a
Is there any way to bulk load table from a particular db based on some pattern in table name in tap-mysql. for ex: I want to select tables ending with "_sql" or starting with "tab" . How to achieve that ?
e
Hi @atif_imam. Yes, the docs mention you can use Unix shell-style wildcards like
*_sql.*
or
tab*.*
a
@edgar_ramirez_mondragon . I am trying to select all of the table starting with "booking" in databese "db_name", ``db_name-booking.*` and
db_name-booking*
but it is not fetching any table. Am i missing something ?
e
@atif_imam the syntax for selection is
<stream>.<property>
, so what you want it
db_name-booking*.*
meaning all tables in db db_name starting with booking and select all fields from those tables
a
@edgar_ramirez_mondragon , got it . its working now . Thank you so much.
e
Awesome! Glad to help 😄