Version Control in SQL Work Files

In a SQL work file, your code is automatically saved as you work on it. You can also save new versions so that you and your team can iterate quickly and build upon prior work.

Prerequisites

Procedure

  1. To save a new version manually, click Save As. The following commands are available:
    • Save as new version: Saves a new version of the file in the versioning list. This does not affect previous changes/versions.
    • Replace current version: Replaces the current version you are working on.
    • Save file as a Team Studio View: Saves the query/results as a Team Studio view. Team Studio views can be used in analytic workflows just like database tables.
    • Save selection as a Team Studio View: Saves a selection of text as a Team Studio view.



  2. To review the previous versions of an SQL work file, click the Version link, and then choose the revision that interests you. You can then edit and run that version of the file without disrupting the most recent version.


Related concepts

You can also delete previous versions of the work file. When code is generally useful, your team members can make copies of it in their workspaces to use as their own starting points.

Procedure