Sync Replicated support bundles into Snowflake on a schedule

Description

Replicated Support Bundles → Snowflake

Syncs all Replicated support bundles from your vendor account into a Snowflake table on a daily schedule. Useful for tracking support bundle activity, correlating bundles with customer health, and building operational dashboards.

How it works

A Schedule Trigger fires daily
The Replicated Vendor API (/vendor/v3/supportbundles) is called to fetch all support bundles
The bundles array is split and each record is mapped to a flat structure with typed fields
The Snowflake destination table is truncated (full refresh), then all records are bulk-inserted

Setup

Create the table — run the [CREATE] REPLICATED_SUPPORTBUNDLES node manually once before activating. Adjust the database/schema to match your Snowflake environment
Add your Replicated API Token as an HTTP Header Auth credential (Authorization header)
Connect your Snowflake credential
Activate the workflow

Notes

This is a full replace on every run, not an upsert — suitable as long as your total bundle count stays manageable
Fields synced: id, name, uploadedAt, collectedAt, source, customerId, instanceId, size, viewed