Google BigQuery Connectors > Part II: Data Integration with Google BigQuery V2 Connector > Mappings and mapping tasks with Google BigQuery V2 Connector > Adding multiple source objects

Adding multiple source objects

When you create a Source transformation, you can select Google BigQuery V2 multiple object as the source type and then configure a join to combine the tables. You can define an advanced relationship or a query to join the tables. You must use the standard SQL to define the query to join the tables.
    1. In the Source transformation, click the Source Type as Multiple Objects.
    2. From the Actions menu, click Add Source Object.
    The image shows how to add a source object.
    3. Select the source object that you want to add from the displayed list.
    The image shows the list of objects from which you can select a source object.
    4. Click OK.
    5. From the Related Objects Actions menu, select Advanced Relationship: The image shows the Advanced Relationship option.
    6. In the Advanced Relationship window, you can click Add Object to add more objects.
    Click Add Object to add more objects.
    7. Click OK.
    8. Set your own conditions or specify a query to define the relationship between the tables:
    The image shows how you can define a relationship between objects.
    Note: When you configure a join expression, select the fields and define a join condition or a query syntax.
    9. Click OK.
    The following image shows an example of an advanced join condition defined between the Google BigQuery V2 tables:
    The image shows how an advanced join condition is displayed in the UI.

Rules and guidelines for adding multiple source objects

Consider the following rules and guidelines when you add multiple source objects: