Google Cloud Platform - Data Fusion - Wrangler

user_17702762 0
Viewed 244

I am trying to join two input sources in the Google Cloud Platform, one from BigQuery and the other from Google Cloud Storage which contains a .csv file. I see using a joiner is the best option.

But I am curious whether the same can be achieved using the table lookup: column 'table' directive. The input records will be from BigQuery, and the 'table' will refer to the .csv file in Google Cloud Storage. Is it possible to achieve this with just Wrangler without using joiner?

record google-cloud-platform directive csv join
1 Answers

Absolutely yes, you can use Wrangler instead of joiner to connect two data sources, you can apply basic transformations and export this information into a sink in Google Cloud Platform.

For your specific scenario using BigQuery for the input records and the 'table' from the .CSV file contained in Google Cloud Storage please check this tutorial which contains the specific steps on how to achieve it.

user_169291450
Related