Wiring Nimble into Snowflake: paste the raw API token into the secret, without the Bearer prefix, or authentication fails. Expose Nimble as a scalar function or procedure for Cortex Agents; UDTFs are not supported in that path. Test the function with a single URL before building the agent on top of it, so a credential-format problem shows up immediately instead of mid-run.

Context: Web (Nimble official cookbook, Snowflake integration): documents two gotchas that break setups. First, the Snowflake external access integration expects the raw Nimble token with no Bearer prefix; including 'Bearer ' fails authentication. Second, Snowflake Cortex Agents accept scalar functions and stored procedures, not user-defined table functions (UDTFs), so model the Nimble call as a scalar function returning the extracted payload.