Snowflake

​

Webhook receiver (paid runtime)

POST /webhooks/snowflake/{tenant_id}

​

Setup

1. Create an API Integration in Snowflake:
   CREATE OR REPLACE API INTEGRATION mycelium_integration
     API_PROVIDER = aws_api_gateway  -- or azure_api_management
     API_AWS_ROLE_ARN = '<iam_role>'
     API_ALLOWED_PREFIXES = ('https://runtime.myceliumai.co/')
     ENABLED = TRUE;
   
2. Create a Snowflake External Function:
   CREATE OR REPLACE EXTERNAL FUNCTION mycelium_ingest(payload VARIANT)
     RETURNS VARIANT
     API_INTEGRATION = mycelium_integration
     AS 'https://runtime.myceliumai.co/webhooks/snowflake/{your_tenant_id}';
   
3. Call the function from Tasks or Alerts on the tables/queries you want to monitor.
4. Add to the runtime env:
   • SNOWFLAKE_AUTH_TOKEN_{TENANT_ID} (the sf-custom-auth-token value)

​

Events ingested

​

Retry behavior

POST /admin/webhooks/replay/{tenant_id}/{event_id}