NEW documentation: This article covers setup for OWOX BI. For the latest guides on setting up FREE connectors and Data Marts, visit the new OWOX Data Marts documentation.
On the Operation page, you can view the compiled SQL code that will be executed in BigQuery when the Transformation is run.
Features of the Preview tab
- The code already contains values for all variables. Here you can view the fully prepared SQL code ready for execution.
- Editing the code on this tab is not available. However, by using the "Copy to clipboard" button, you can easily copy the entire SQL code with a single click and use it as needed.
- In the Destination table settings, you can see the actual path to the BigQuery table where your data will be saved as a result of the query execution. This is particularly useful if you are using variables in the Destination table settings.
The path to the Destination table is a direct link to it in the Google Cloud Console interface. - In the Destination table settings, if a variable is not replaced with a value, you will see an error:
0 Comments