Snowflake → AEP Streaming Connector Setup - Key Differences from Batch?

[RS195]

Hi everyone,

We’re in the process of configuring the Snowflake → AEP streaming connector (using Snowflake Streaming. Before we proceed further, I’d like to confirm a few details:

What we understand so far:

• Similar to batch ingestion, we’ll be creating a dedicated Snowflake service account/user for AEP

• We’ll need to coordinate authentication for that user (preferably key-pair)

• We’ll also need to set up the warehouse, database, schema, and target table/view for AEP to read from

• Access privileges needed: USAGE on warehouse, database, schema + SELECT on the target table/view

Question for the community:

1. Are these steps exactly the same as what’s required for the batch Snowflake connector, or are there additional/different requirements specific to the streaming connector?

2. Are there any best-practices or checklist items you’d recommend specifically for the streaming setup?

3. Any gotchas or configurations that differ for streaming versus batch when using Snowflake → AEP?

Thanks in advance for any insights. We want to make sure we’ve covered everything correctly before we engage the Snowflake team.