Yandex Cloud
Search
Contact UsGet started
  • Blog
  • Pricing
  • Documentation
  • All Services
  • System Status
    • Featured
    • Infrastructure & Network
    • Data Platform
    • Containers
    • Developer tools
    • Serverless
    • Security
    • Monitoring & Resources
    • ML & AI
    • Business tools
  • All Solutions
    • By industry
    • By use case
    • Economics and Pricing
    • Security
    • Technical Support
    • Customer Stories
    • Start testing with double trial credits
    • Cloud credits to scale your IT product
    • Gateway to Russia
    • Cloud for Startups
    • Education and Science
    • Yandex Cloud Partner program
  • Blog
  • Pricing
  • Documentation
© 2025 Direct Cursus Technology L.L.C.
Yandex DataLens
    • Overview
    • Caching
    • Combining data
      • Creating a ClickHouse® connection
      • Creating a PostgreSQL connection
      • Creating a MySQL® connection
      • Creating a YDB connection
      • Creating a Greenplum® connection
      • Creating a SQL Server connection
      • Creating an Oracle Database connection
      • Creating a Prometheus connection
      • Creating a Snowflake connection
  • Audit Trails events
  1. Connections
  2. Databases
  3. Creating a Snowflake connection

Creating a Snowflake connection

Written by
Yandex Cloud
Updated at November 15, 2024

To create a Snowflake connection:

  1. Open the page for creating a new connection.

  2. Under Databases, select the Snowflake connection.

  3. Fill out the fields in the Authentication section.

    Note

    To get the token, create a user with limited access rights on Snowflake.

    1. If this is your first connection to Snowflake in DataLens, set up the OAuth integration:

      1. In the OAuth integration field, add a name for the integration object using Latin characters, and then click Get snippet.

      2. Create an integration: in the Snowflake environment, run the snippet that you copied to the clipboard. Run the snippet code on behalf of the user who has the relevant permission. In the request response, you will get values to insert to DataLens.

        Note

        You can use the resulting parameters for other Snowflake connections from the same account.

    2. Fill out the parameters you got after executing the snipped code in the Snowflake environment:

      • ACCOUNT_NAME: Name of the account in the Snowflake environment.
      • CLIENT_ID: Client ID for the created integration object.
      • CLIENT_SECRET: Client secret.
    3. Click Get token next to the Refresh token field. This will open the Snowflake page for access approval. Make sure you are logged in with the Snowflake user account with limited access rights.

  4. Specify the connection parameters under Database details:

    • User name: Name of the user who confirmed the access rights to Snowflake.
    • Database name: Name of the database you are connecting to.
    • Database schema: Database schema.
    • Warehouse: Storage used by the database.
    • User role: Role of the user who has access to the database you are connecting to.

    image

  5. (Optional) Test the connection. To do this, click Check connection.

  6. Click Create connection.

  7. Select a workbook to save your connection to or create a new one. If using legacy folder navigation, select a folder to save the connection to. Click Create.

  8. Enter a name for the connection and click Create.

Was the article helpful?

Previous
Creating a Prometheus connection
Next
Creating a connection to files
© 2025 Direct Cursus Technology L.L.C.