How do I create a database in Snowsight?

467 viewsSnowsight and Classic UI

How do I create a database in Snowsight?

Daniel Steinhold Asked question October 26, 2023

As of my last knowledge update in September 2021, Snowsight is a web-based user interface for Snowflake, a cloud-based data warehousing platform. To create a database in Snowflake (which can be managed through Snowsight), you typically need to use SQL commands within the Snowflake environment. Here's how you can create a database using SQL commands:

  1. Log in to the Snowflake Web Interface: Access the Snowflake web interface (https://<your-account> and log in with an account that has the necessary privileges to create a database. Typically, you need the 'ACCOUNTADMIN' role or a role with the necessary permissions for database management.
  2. Navigate to the SQL Worksheet:
    • In the Snowflake web interface, click on the "Worksheet" tab to access the SQL Worksheet.
  3. Write SQL Command to Create a Database:
    • Use SQL to create a database. The SQL command to create a database typically follows this pattern:
    CREATE DATABASE <database_name>;

    Replace <database_name> with the name you want to give to the new database.

    For example, to create a database named "mydata," you can use this SQL command:

  4. Execute the SQL Command:
    • After writing the SQL command, click the "Run" or "Execute" button in the SQL Worksheet to execute the command.
  5. Verify the Database Creation:
    • You can verify that the database has been created by querying the Snowflake information schema or by checking the list of databases in the Snowflake web interface.

Please note that creating a database in Snowflake may require administrative privileges or a role with the necessary permissions. The exact steps and options may have changed since my last update in September 2021, so I recommend referring to the latest Snowflake documentation or contacting your organization's Snowflake administrator for the most up-to-date instructions and best practices for database management.

Additionally, if Snowflake has introduced new features or changes related to database management within the Snowsight interface specifically, it's advisable to check the most recent Snowsight documentation for any specific details on this process.

Daniel Steinhold Changed status to publish October 26, 2023

Maximize Your Data Potential With ITS

Feedback on Q&A