External script index for Snowflake
Review available SQL script templates supported by the Scripts API for setting up tasks, views, tables, and streams in Snowflake.
General script templates
Use these script names to generate SQL templates for Snowflake objects such as views, tables, tasks, and streams. All scripts are retrieved using the scripts endpoint of the adapter API and may require placeholder substitution.
| Script name | Resource | Description | Placeholders |
|---|---|---|---|
| db.stages.create-stage | Stage | Create internal stage with directory auto-refresh | stageName, schema, database |
| db.tasks.create-task-load_new_file_data | Task | Copy stage files into landing table | warehouse, database, schema, landingTableName, stageName |
| db.tables.create-table-datatable | Table | Create landing table for staged JSON | database, schema, landingTableName |
| db.views.create-view-activeworkflows | View | View of workflow_data filtered to active | database, schema |
| db.tasks.create-task-workflowtask | Task | Merge workflow records from stream | warehouse, database, schema |
| db.streams.create-stream-workflowstream | Stream | Create Stream for workflow table | database, schema, landingTableName |
| db.tables.create-table-workflow_data | Table | Create workflow_data table | database, schema |
| db.views.create-view-activeactivities | View | View of activities filtered to active | database, schema |
| db.tasks.create-task-activitiestask | Task | Merge activities from stream | warehouse, database, schema |
| db.streams.create-stream-activitiesstream | Stream | Stream for activity table | database, schema, landingTableName |
| db.tables.create-table-activities | Table | Create activities table | database, schema |
| db.views.create-view-activelinks | View | View of links filtered to active | database, schema |
| db.tasks.create-task-linkstask | Task | Merge links from stream | warehouse, database, schema |
| db.streams.create-stream-linksstream | Stream | Stream for links | database, schema, landingTableName |
| db.tables.create-table-links | Table | Create links table | database, schema |
| db.views.create-view-activerelations_ov | View | Relations view (OV only) | database, schema |
| db.views.create-view-activerelations_all | View | Relations view (all) | database, schema |
| db.tasks.create-task-relationstask | Task | Merge relations from stream | warehouse, database, schema |
| db.streams.create-stream-relationsstream | Stream | Stream for relations | database, schema, landingTableName |
| db.tables.create-table-relations | Table | Create relations table | database, schema |
| db.views.create-view-activemerges | View | View of merges filtered to active | database, schema |
| db.tasks.create-task-mergestask | Task | Merge latest merges | warehouse, database, schema |
| db.streams.create-stream-mergesstream | Stream | Stream for merges | database, schema, landingTableName |
| db.tables.create-table-merges | Table | Create merges table | database, schema |
| db.views.create-view-activematches | View | View of matches filtered to active | database, schema |
| db.tasks.create-task-matchestask | Task | Merge latest matches | warehouse, database, schema |
| db.streams.create-stream-matchesstream | Stream | Stream for matches | database, schema, landingTableName |
| db.tables.create-table-matches | Table | Create matches table | database, schema |
| db.views.create-view-activeinteractions | View | Interactions view (active) | database, schema |
| db.tasks.create-task-interactionstask | Task | Merge interactions from stream | warehouse, database, schema |
| db.streams.create-stream-interactionsstream | Stream | Stream for interactions | database, schema, landingTableName |
| db.tables.create-table-interactions | Table | Create interactions table | database, schema |
| db.views.create-view-activeentities_ov | View | Entities view (OV only) | database, schema |
| db.views.create-view-activeentities_all | View | Entities view (all) | database, schema |
| db.tasks.create-task-entitiestask | Task | Merge latest entities | warehouse, database, schema |
| db.streams.create-stream-entitiesstream | Stream | Stream for entities | database, schema, landingTableName |
| db.tables.create-table-entities | Table | Create entities table | database, schema |
| db.streams.create-stream-reltio_stream | Stream | Stage-level stream for file arrivals | stageName, schema, database |
| db.file_formats.create-file_format | File Format | GZIP JSON format | — |
| db.functions.create-function-single_value_transformation | Function | UDF: Single OV flatten | — |
| db.functions.create-function-multi_value_transformation | Function | UDF: Multi-OV flatten | — |
| db.functions.create-function-crosswalks_transformation | Function | UDF: Crosswalk simplification | — |
| db.functions.create-function-attributes_multi_value_transformation | Function | UDF: Multi-OV (attributes only) | — |
| common.remove-old-rows-task | Task | Task to remove old landing table rows | warehouse, database, schema, landingTableName |
| common.auto-refresh-stage | Task | Auto-refresh stage for GCP and Azure | warehouse, stageName, schema, database |
Type-specific view scripts
Use these scripts to generate views scoped to a specific entity, relation, or interaction type. These are commonly used to build filters on top of the base data tables in Snowflake.
| Script name | Resource | Description | Placeholders |
|---|---|---|---|
| entities.views_all | View | Entity view (all values) | entityType |
| entities.views_ov | View | Entity view (OV only) | entityType |
| interactions.views_all | View | Interaction view by type | interactionType |
| relations.views_all | View | Relation view (all values) | relationType |
| relations.views_ov | View | Relation view (OV only) | relationType |