How can I parameterize a BigQuery table in Dataprep?

118 views Asked by At

I'm used to use Dataprep to recipe json and csv files from Cloud Storage, but today I tried to ingest a table from BigQuery and could not parametrize.

Is it possible to do that?

Here are some screenshots to illustrate my question:

The prefix that I need

The standard does not work

From Cloud Storage works

1

There are 1 answers

0
DamPlz On

In order to ingest a table from BigQuery, you can directly create a Dataset with SQL. I am not sure on what you would like to achieve with the 'Search' input, but it does not accept regular expressions. So, the '*' would not be needed, and just writing 'event_', the interface will filter the matching entries.