For Organizations New to Snowflake

No Snowflake account? No problem. We'll set up everything for you:

The setup process:

1. We create your account - Mappedin sets up a specialized Snowflake account (called a "reader account") with your analytics data already available

2. We create your login - We'll create a user account and send you an invitation to access the system via email. We will provide you with a URL containing the Snowflake reader account username and temporary password. Once you login, you will be asked to change password and set up multi-factor authentication.

URL: https://a1b2c3d4-customer1.snowflakecomputing.com
User: customer1@company.com
Temp Pass: secret_password

3. Set up MFA (optional) - If you need to add an extra layer of security to your account, follow these steps:
   • Click username that's on left bottom → Settings → Authentication → Add new authentication method
   • As of now, snowflake supports 3 types of MFA methods:
     1. Passkey
     2. Authenticator
     3. Duo

4. Manage Programmatic Access Tokens (PAT) - A PAT provides a secure way for these tools to access your data automatically, without requiring someone to manually log in each time.
   • Click username that's on left bottom → Settings → Authentication → Generate new token
   • Create/rotate/delete a PAT. You are responsible for managing programmatic access token lifetimes, rotation, etc.

5. Managing Users - The provided SERVICE_USER user has permission to create new users through the USERADMIN role.

   • Creating a new user
     1. Change to the USERADMIN role by clicking on your user info in the bottom left corner.
     2. Menu → Admin → Users and Roles
        1. 
     3. Click on the blue plus button in the top right to create a new user.
     4. Fill in at least the User Name and Password fields and choose appropriate options then press Create User.
        1. 
     5. The user does not automatically have access to your data. To get access to your data the user must be granted the READER role.

6. Grant roles to users

   • Find the user in the list and open the menu for that user's row and select Grant a Role
   • From the dropdown select READER and click Grant.
   • You'll be able to edit users created/owned by the USERADMIN role only. USERADMIN role cannot assign roles other than the READER role to users.

7. Running Queries
   • Data Base
     1. To access your analytics database:
        1. Navigate to Menu → Catalog → Database Explorer
        2. Locate the database named MAPPEDIN_ANALYTICS
        3. Within this database, you will find the session_events_view view containing your analytics data

• SQL Worksheet Creation
  1. Snowflake worksheets provide an integrated development environment for executing SQL queries and analyzing your data. These worksheets allow you to write, test, and run SQL statements directly against your analytics database.
  2. To create a SQL worksheet:
     1. Navigate to Menu → Projects → Worksheets
     2. Select Create (located in the top-right corner)
     3. A new SQL worksheet will be generated where you can compose and execute your queries

• Warehouse Configuration
  1. In Snowflake, SQL queries are executed using a warehouse, which functions as a dedicated compute resource (similar to a virtual machine). Warehouses provide the processing power necessary to run your analytics queries and return results.
  2. Warehouse Selection: When executing SQL queries, you have the ability to specify:
     1. Role: Determines your access permissions and data visibility
     2. Warehouse: Controls the compute resources allocated to your query execution

Important Details

• Timezone settings: We can configure your account to display data in your preferred timezone
• Single sign-on (SSO): If your organization uses SSO, we can set that up for you during the account creation process
• Usage limitations: Your reader account will have some built-in limitations that we'll explain when we set up your account