rockstarETL: SQL job type

Leave a Comment / rockstarETL, SQL / By
sql job type

With the SQL job type, rockstarETL simply runs your query.

You should use a DML or BQ ML statement. A select statement won’t display the result back to you.

The reason is because with rockstarETL, you build pipelines, which run the steps at the time and frequency you specify.

How do I use the SQL job type?

  •  Write your SQL statement and validate it in the web UI 
  • Copy the statement into a text file
  • Save the text file in your Cloud Storage bucket
  • Complete the ProjectID, Location, Job Name fields in the SQL job type form
  • In the SQL statement field, add the location to the text file you created containing your SQL statement
  • Select “Save”
  • Done!

Leave a Comment