Using worksheets to write queries

Accessing Worksheets To Write Queries

Worksheet lets you write your SQL statements allowing you to pull your data. This is also where you can download, save, and organize your queries for future reference. Step 1: Start a New Worksheet

On the left hand navigation bar click on Projects > Worksheets
Click on the blue + button on the right hand corner of the page
Select SQL Worksheet

Snowflake Worksheets page with Projects > Worksheets highlighted in the left nav, and the + menu open showing "SQL Worksheet" selected at top.

Step 2: Pick your Role and Warehouse On the top right hand side of the worksheet click on the link located left of the Share button Select the USERADMIN role and choose the warehouse named after your practice.

Role and warehouse selector showing USERADMIN role and SUPPORT_TESTING_WH warehouse selected, both highlighted in the toolbar and dropdown menus.

Step 4: Select your database and warehouse On the top left hand corner of your Worksheet click on No Database selected and choose your Database name. Your Database name will start with ELATIONHEALTH_EHDW

Database dropdown open showing three options: ACCOUNT_MANAGEMENT, ELATIONHEALTH_EHDW_SUPP… (highlighted), and SNOWFLAKE. "No Database selected" button is outlined in red.

Now choose your Schema which will be your practice name

Database selector showing ELATIONHEALTH_EHDW_SUPP... selected, with SUPPORT_TESTING schema highlighted in red as the schema to select.

Pro tip: You can run the below commands in a worksheet to choose your database, schema, role, and warehouse

USE DATABASE ELATIONHEALTH_EHDW_YOUR_PRACTICE_NAME
USE SCHEMA YOUR_PRACTICE_NAME;
USE ROLE USERADMIN;  
USE WAREHOUSE YOUR_PRACTICE_NAME_WH;

select * from appointments; 

You are now all set to run your first query! Test this out by typing the below query into your worksheet.

SELECT * FROM APPOINTMENT;

SQL autocomplete dropdown showing "select * from appoin" with suggestions for "appointment" table (selected, 648.4K rows) and "appointment_status" table.

Press the blue play button on the top right hand corner of your worksheet to get your results

Submit a request through the Elation Support Portal with the subject line HDB - unable to run queries and include the error message you are receiving.

Managing your users

⌘I

Hosted Database

Overview

How Tos

Common Queries

Elation Billing

Frequently Asked Questions

Changelog

Using worksheets to write queries

Accessing Worksheets To Write Queries

​Accessing Worksheets To Write Queries

Accessing Worksheets To Write Queries