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

Hide parameters

string

This field maps to the destination API databaseName field.

string

This field maps to the destination API schemaName field.

string

This field maps to the destination API tableName field.

Map<string,dynamic (any)>

HI ID PII This field maps to the destination API fields field.

bool

This field maps to the destination API additionallyIncludeEventFieldsAtTheTopLevel field.

{
  "$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 an object name, which nests the action’s result data inside the downstream data context in the workflow. See Passing Data Between Actions for how to set it and reference the result from downstream nodes. Here we demonstrate how to refer to this data using the prefix $result_object_key.

Fetch Action Response Object

Hide fields

object

required

Description coming soon

CEL

$result_object_key.table_used

Example

{
"database_name": "MORF_HEALTH",
"schema_name": "PUBLIC",
"table_name": "HEALTHIE_PATIENT_UPDATED"
}

string

required

Database Name

CEL

$result_object_key.table_used.database_name

Example

"MORF_HEALTH"

string

required

Schema Name

CEL

$result_object_key.table_used.schema_name

Example

"PUBLIC"

string

required

Table name used to save the data

CEL

$result_object_key.table_used.table_name

Example

"HEALTHIE_PATIENT_UPDATED"

Events

Actions

Save To Table Variant

Getting Started

Creating the Morf role, warehouse, and database in Snowflake

Parameters

Result Object Field Details

​Getting Started

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

​Parameters

​Result Object Field Details

Getting Started

Creating the Morf role, warehouse, and database in Snowflake

Parameters

Result Object Field Details