Preview tab

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:
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request


Please sign in to leave a comment.