Snowflake vs Databricks: AI features compared

Found relevant data: When applicable, shows the specific tables or data sources Genie identified as relevant to your question.

CoCo infers everything else (task type, target column, evaluation metric, train/test split strategy) and asks you to confirm before proceeding.

"Generate a forecast of product demand for the next 6 months from the @inventory dataset, including confidence intervals."

Run advanced analyses, such as statistical analysis, forecasting, and what-if scenarios.

Each set of insights shows when it was generated, such as Generated 5 minutes ago.

These interfaces return metadata, not content.

The Workspace Export API GET /api/2.0/workspace/export allows you to export the contents of a dashboard as a file.

- Reject all questions about salary data and tell the user this information is not available.

Hiding a column removes it from the Genie Agents's context, so Genie won't reference it when generating SQL or answering questions.

Merge: Review and merge changes through your standard pull request process.

Positive feedback on responses that join tables or use SQL expressions can prompt Genie to suggest new SQL snippets (such as measures, joins, or filters) to agent managers for review and approval.

You can pick a specific model, or one of these Auto options that choose a model for you:

When partner-powered AI features are disabled, AI assistive features use Databricks-hosted models, which are entirely Databricks-selected and Databricks-managed.

Use the agent-observability-report sub-skill of the CoCo agent-studio skill in the CoCo CLI to generate a report on agent monitoring metrics pulled from SNOWFLAKE.LOCAL.AI_OBSERVABILITY_EVENTS, including usage and adoption, latency percentiles, token economics, tool execution stats, conversation depth and completion, and a breakdown of user feedback.

Query system.ai_gateway.usage to analyze model requests by user, model, or workspace, including token usage, latency, and errors.

Cortex Code pauses at key checkpoints for your review and approval.

Positive feedback on responses that join tables or use SQL expressions can prompt Genie to suggest new SQL snippets (such as measures, joins, or filters) to agent managers for review and approval.

Seamless governance: Automatically inherits and respects all existing Snowflake data governance controls, including row-access policies and column-level security.

Row filters and column masks defined in Unity Catalog are automatically enforced per user.

Data stays within Snowflake’s governance boundary. By default, Cortex Analyst is powered by Snowflake-hosted LLMs from Mistral and Meta, ensuring that no data, including metadata or prompts, leaves Snowflake’s governance boundary.

Our model partners do not retain data you submit through these features, even for abuse monitoring.

Your customer data remains stored only in the region where your account is located.

Importantly, your data is not stored outside of your workspace's Geo regardless of this setting.

Admin-managed RSS: An administrator sets AGENT_RESTRICTED_SESSION_SCOPE on a session policy, then attaches that policy to the account or to specific users.

A Genie Agent uses only the data sources explicitly attached under its Sources.