Skip to main content

USE

The USE command enables you to specify the context to be used for the current query session. When running Arctic-specific queries, this command enables you to change the reference for the current query session.

Syntax
USE { <path> | { REF | BRANCH | TAG | COMMIT <refValue> } }
   [ IN <catalog_name> ]

Parameters​

{{< sql-section file="data/sql/branches.json" data="specifyingABranch" >}}

Examples​

Use the demo source
USE Samples."samples.dremio.com"
Use the specified branch as the reference for the current Arctic query session
USE BRANCH myBranch
Use the specified reference for the current Arctic query session in the specified catalog
USE BRANCH myBranch
  IN myCatalog