Skip to main content

Documentation Index

Fetch the complete documentation index at: https://docs.morf.health/docs/llms.txt

Use this file to discover all available pages before exploring further.

images/snowflake.svg

​
Getting Started

Automate your healthcare workflows with Snowflake integrations and Morf. Snowflake is a cloud-based data warehousing platform for analyzing and querying large datasets. Save event data from a Morf workflow to a Snowflake table.

​
Creating the Morf role, warehouse, and database in Snowflake

Replace the first line of the following script, then run it: 
set morfPassword = '<MORF_PASSWORD>'; -- ⚠️ Replace me with a strong password

begin;

-- create Morf role
use role securityadmin;
create role if not exists MORF_HEALTH;
grant role MORF_HEALTH to role sysadmin;

-- create Morf user
create user if not exists MORF_HEALTH
    password = $morfPassword
    default_role = 'MORF_HEALTH'
    default_warehouse = 'MORF_HEALTH';

grant role MORF_HEALTH to user MORF_HEALTH;

-- change role to sysadmin for warehouse / database steps
use role sysadmin;

-- create Morf warehouse
create warehouse if not exists MORF_HEALTH
    warehouse_size = xsmall
    warehouse_type = standard
    auto_suspend = 60
    auto_resume = true
    initially_suspended = true;

-- create Morf database
create database if not exists MORF_HEALTH;

-- grant Morf warehouse access
grant usage
    on warehouse MORF_HEALTH
    to role MORF_HEALTH;

-- grant Morf database access
grant ownership
    on database MORF_HEALTH
    to role MORF_HEALTH;

-- grant Morf schema access
grant ownership
    on schema MORF_HEALTH.PUBLIC
    to role MORF_HEALTH;

commit;

​
Parameters

​
Action
Parameters
{
  "$result_object_key": {
    "table_used": {
      "database_name": "MORF_HEALTH",
      "schema_name": "PUBLIC",
      "table_name": "HEALTHIE_PATIENT_UPDATED"
    }
  }
}

{
  "$result_object_key": {
    "table_used": {
      "database_name": "Database Name",
      "schema_name": "Schema Name",
      "table_name": "Table name used to save the data"
    }
  }
}

​
Result Object Field Details

You can use the result of the action’s data as inputs to downstream workflow actions. Each fetch action requires a result object key to be specified which will nest the action’s result data inside the downstream data context in the Workflow. Here we demonstrate how to refer to this data using the prefix $result_object_key.
​
SaveToTableVariantResponse
Fetch Action Response Object