FAQ

What's the difference between Replace and Append mode?

Replace deletes all existing rows in the table and loads the latest data from your source on every run. Use this when you always want the table to reflect the current state — for example, a live snapshot of your ad campaigns or subscriptions.

Append adds new rows to the bottom of the table without removing existing data. Use this for historical tracking — for example, logging daily metrics, transaction events, or usage data over time.

What happens if the schema or table I specify doesn't exist yet?

Coupler.io will create them automatically on the first successful run. You don't need to pre-create anything in Snowflake — just make sure the connected role has USAGE on the database and CREATE TABLE privileges on the schema.

Can I send data from multiple sources into the same Snowflake database?

Yes. You can create multiple data flows, each pointing to the same Snowflake database but writing to different tables or schemas. You can also use a single data flow with multiple sources and apply Join, Append, or Aggregate transformations before the data lands in Snowflake.

Does Coupler.io enforce data types when writing to Snowflake?

Yes. Coupler.io detects column types from your source data and enforces them when writing to Snowflake. This means numeric fields land as numbers, dates as date types, and so on — rather than everything being stored as text. If the existing table has different types, you may see type mismatch errors. Letting Coupler.io create the table from scratch (using Replace mode on a new table) is the cleanest way to get properly typed columns.

Does my Snowflake warehouse need to be running for the data flow to work?

Yes. The warehouse must be running (or set to auto-resume) when Coupler.io executes the data flow. If the warehouse is suspended and auto-resume is off, the run will fail. Enable auto-resume in Snowflake to avoid this: ALTER WAREHOUSE your_warehouse SET AUTO_RESUME = TRUE;

What schema does Coupler.io use by default?

If you don't specify a schema, Coupler.io defaults to public. You can change this to any schema your Snowflake role has access to.

How does Coupler.io authenticate with Snowflake?

Coupler.io uses OAuth to connect to Snowflake. When you add a Snowflake account, you'll be redirected to Snowflake's login page to authorize access. No passwords are stored in Coupler.io — the connection is managed through OAuth tokens.

How do I keep my existing Snowflake data safe when using Replace mode?

Replace mode overwrites everything in the target table on each run. If you need to preserve historical data, switch to Append mode instead. Alternatively, set up a separate table for Coupler.io's writes and use SQL views or queries to combine it with your other data.