3.3.6 BigQuery Data Sets

To create a new BigQuery Data Set, open the Data Sets grid in the relevant project and click "Add Data Set" for global Data Set. Alternatively, you can create a local Data Set directly within a Test. 
Then, select your BigQuery Data Source as Data Source: 

Create Data Set using "Query Builder" mode:

 

Friendly name - the user can choose an alias that will be used instead of the original name in the "Selected columns" area in the column "Table". 

When building Data Set based on BigQuery  and using "Query Builder" mode - additional table entities can be added: 

1. Click "Add Data Entity" button. Choose join type (Left Join, Inner Join) between 2 or more tables. Define the join condition between the tables (more than one condition could be applied). For example:

Click "</> Display Code" below the condition to see the SQL query that will be applied: 

2. In the "Selected Columns" area from the right you can choose the columns that will participate in Data Set. Below there is an option to "Add Group By". Clicking it will open a new window:

Aggregate functions can be used. 

3. Add filter(s) to the Data Set:

Filters can be added easily and can combine more than one condition for each filter. 

It's possible to use predefined variables for the Data Set. 

On the top right side of this window click "Custom Command Filter" - the query will be revealed (will be possible to edit it manually):


 

In conclusion "Query Builder" mode allows to build a complex query without writing the SQL code itself! 

Create Data Set using "Custom SQL" mode:

User can customize his own SQL query and also to use all previously described functionalities.
When "Custom SQL" mode is chosen, a new checkbox “Save Query” appears. 

Save Query - when checked, a warning appears before changing the Data Source, prompting you to confirm whether you want to save the current query to the clipboard.