Links

Base: SnowSQL

There is a possibility to access the databases and tables within Base module using snowSQL CLI. This might be important to the external collaborators who don't have access to the ICA core functionalities. In this tutorial we describe how to obtain the token and use it for accessing the Base module. This tutorial doesn't cover how to install and configure snowSQL.

Obtaining OAuth token and URL

Once the user enables Base module within a project, one can see the following Base details in the Details menu of the project
base-enabled-oauth
After clicking the button "Create OAuth access token" the pop-up authenticator is displayed as below
base-oauth-token
After clicking the button "Generate snowSQL command" the pop-up authenticator presents the snowSQL command
base-oauth-command
The user can copy the snowSQL command and run it in the console to log in
base-oauth-cli
Now the user can perform a variety of tasks including but not limited to
  1. 1.
    Querying Data: Users can execute SQL queries against tables, views, and other database objects to retrieve data from the Snowflake data warehouse.
  2. 2.
    Creating and Managing Database Objects: Users can create tables, views, stored procedures, functions, and other database objects in Snowflake. They can also modify and delete these objects as needed.
  3. 3.
    Loading Data: Users can load data into Snowflake from various sources such as local files, AWS S3, Azure Blob Storage, or Google Cloud Storage.
Overall, snowSQL CLI provides a powerful and flexible interface to work with Snowflake, allowing external users to manage data warehouse and perform a variety of tasks efficiently and effectively without access to the ICA core.