Skip to main content
You can create custom tables in Snowflake which will allow you to aggregate data from your master database to analyze and run reports. For more information check out the Snowflake documentation https://docs.snowflake.com/en/sql-reference/sql/create-table Step 1: Create your database
  1. On the left hand navigation bar click on Data > Database.
  2. On the top right hand corner click on the Blue Database button
Snowflake Databases page showing 3 existing databases, with "Data > Databases" selected in the left nav and the "+ Database" button highlighted in the top right corner. Step 2: Name your database and give it an optional comment New Database dialog with Name field filled in as "MY_CUSTOM_DATABASE" and an optional Comment field partially showing appointment-related text, ready to click Create. Click on the Create button once you are finished Step 3: Create a Schema
  1. Once the Database has been created you will see it on the left hand navigation along with your other database(s)
  2. Click on the newly created Database then click on the blue Schema button on the top right hand side of the page.
  3. Give your Schema a name and hit the create button
MY_CUSTOM_DATABASE selected in the left nav, showing the Database Details tab with ACCOUNTADMIN ownership. The "+ Schema" button is highlighted in the top right corner. New Schema dialog in MY_CUSTOM_DATABASE, showing the Name field filled with "schema_name," an optional Comment field, unchecked Managed access, and the Create button. Step 4: Create your table
  1. Click on your newly created Schema
  2. On the top right hand side corner of your screen click on the Blue Create button
  3. Click on table then the appropriate option.
SCHEMA_NAME selected in left nav under MY_CUSTOM_DATABASE, with the Create dropdown open showing Table, View, Stage, and other object type options. For this example we will be choosing Table > As Select This will take you to a new worksheet Pick your warehouse > Enter the criteria for you custom table > Click Create Snowflake worksheet showing USERADMIN role selected and SUPPORT_TESTING_WH warehouse selected (highlighted in red), with the Create Table button visible in the top right. Enter the criteria for your new table and click Create Table Make sure to reference your main hosted database and schema’s full path SQL editor showing a CREATE TABLE AS SELECT statement for patient_id_to_appointmentas, with the SQL highlighted in red and the Create Table button highlighted in the top right corner. You have successfully created a custom table Database object browser showing MY_CUSTOM_DATABASE > SCHEMA_NAME > Tables expanded, with PATIENT_ID_TO_APPOINTMENT table selected and highlighted inside a red callout box. If you have any questions please contact Elation Support Portal