cortex-ai-function-studio
**[REQUIRED]** Use for ALL Snowflake AI function operations — running, authoring, or estimating cost for any AI_* function. **Must be invoked before writing any AI_SENTIMENT, AI_COMPLETE, AI_CLASSIFY, AI_SUMMARIZE_AGG, AI_EXTRACT, AI_FILTER, AI_TRANSLATE, AI_EMBED, AI_PARSE_DOCUMENT, AI_REDACT, AI_TRANSCRIBE, AI_SIMILARITY, or AI_COUNT_TOKENS SQL.** Also covers custom AI function creation, evaluation, and optimization. Triggers: run AI_SENTIMENT, use AI_COMPLETE, AI_CLASSIFY, AI_SUMMARIZE_AGG, AI_EXTRACT, AI_FILTER, AI_TRANSLATE, AI_EMBED, AI_PARSE_DOCUMENT, AI_REDACT, AI_TRANSCRIBE, AI_SIMILARITY, estimate tokens, count tokens, AI function cost, how many tokens will this use, token estimate, sentiment analysis, classify text, extract from text, filter rows, summarize text, analyze data with AI, explore AI functions, unstructured data, custom ai function, build my own llm function, evaluate ai function, optimize ai function, BYOM, bring your own model, SPCS inference, which AI function, built-in AI function, cortex function.
Pinned to revision 05cff3d0ec12, so it is the text this page describes rather than whatever the author pushed since.
Files
- skills/cortex-ai-function-studio/SKILL.md
- skills/cortex-ai-function-studio/.claude/CLAUDE.md
- skills/cortex-ai-function-studio/.gitignore
- skills/cortex-ai-function-studio/.pre-commit-config.yaml
- skills/cortex-ai-function-studio/AGENTS.md
- skills/cortex-ai-function-studio/CONVENTIONS.md
- skills/cortex-ai-function-studio/LICENSE
- skills/cortex-ai-function-studio/Makefile
- skills/cortex-ai-function-studio/README.md
- skills/cortex-ai-function-studio/built-in-ai-functions/SKILL.md
- skills/cortex-ai-function-studio/byom/SKILL.md
- skills/cortex-ai-function-studio/byom/prerequisites.md
- skills/cortex-ai-function-studio/byom/pricing/SKILL.md
- skills/cortex-ai-function-studio/create/SKILL.md
- skills/cortex-ai-function-studio/demos/SKILL.md
- skills/cortex-ai-function-studio/demos/classification/SKILL.md
- skills/cortex-ai-function-studio/demos/insurance-claim-routing/SKILL.md
- skills/cortex-ai-function-studio/demos/legal-doc-extraction/SKILL.md
- skills/cortex-ai-function-studio/demos/legal-doc-extraction/create_contract_extraction_metric.sql
- skills/cortex-ai-function-studio/demos/pdf-field-extraction/SKILL.md
- skills/cortex-ai-function-studio/demos/pdf-field-extraction/build_dataset.py
- skills/cortex-ai-function-studio/demos/pdf-field-extraction/data.zip
- skills/cortex-ai-function-studio/demos/policy-conditioned-routing/SKILL.md
- skills/cortex-ai-function-studio/demos/policy-conditioned-routing/create_support_ticket_v6_dataset.sql.j2
- skills/cortex-ai-function-studio/demos/policy-conditioned-routing/load_dataset.py
- skills/cortex-ai-function-studio/demos/redaction/SKILL.md
- skills/cortex-ai-function-studio/dev/models/README.md
- skills/cortex-ai-function-studio/dev/models/diff_capabilities.py
- skills/cortex-ai-function-studio/dev/models/diff_models.py
- skills/cortex-ai-function-studio/dev/models/fetch_capabilities.py
- skills/cortex-ai-function-studio/dev/models/validate_models.py
- skills/cortex-ai-function-studio/dev/scripts/check_copyright.sh
- skills/cortex-ai-function-studio/dev/scripts/copy-skill-clean.py
- skills/cortex-ai-function-studio/evaluate/SKILL.md
- skills/cortex-ai-function-studio/handlers/__init__.py
- skills/cortex-ai-function-studio/handlers/evaluate_handler.py
- skills/cortex-ai-function-studio/handlers/execute_eval_opts_handler.py
- skills/cortex-ai-function-studio/handlers/optimize_handler.py
- skills/cortex-ai-function-studio/mypy-full.ini
- skills/cortex-ai-function-studio/optimize/SKILL.md
- skills/cortex-ai-function-studio/packages/snowflake-ai-optimize-core/pyproject.toml
- skills/cortex-ai-function-studio/packages/snowflake-ai-optimize-core/src/snowflake_ai_optimize/core/__init__.py
- skills/cortex-ai-function-studio/packages/snowflake-ai-optimize-core/src/snowflake_ai_optimize/core/constants.py
- skills/cortex-ai-function-studio/packages/snowflake-ai-optimize-core/src/snowflake_ai_optimize/core/ddl_rewrite.py
- skills/cortex-ai-function-studio/packages/snowflake-ai-optimize-core/src/snowflake_ai_optimize/core/errors.py
- skills/cortex-ai-function-studio/packages/snowflake-ai-optimize-core/src/snowflake_ai_optimize/core/evaluation.py
- skills/cortex-ai-function-studio/packages/snowflake-ai-optimize-core/src/snowflake_ai_optimize/core/experiment.py
- skills/cortex-ai-function-studio/packages/snowflake-ai-optimize-core/src/snowflake_ai_optimize/core/metrics/__init__.py
- skills/cortex-ai-function-studio/packages/snowflake-ai-optimize-core/src/snowflake_ai_optimize/core/metrics/aggregation.py
- skills/cortex-ai-function-studio/packages/snowflake-ai-optimize-core/src/snowflake_ai_optimize/core/metrics/builtin.py
- skills/cortex-ai-function-studio/packages/snowflake-ai-optimize-core/src/snowflake_ai_optimize/core/metrics/custom_udf.py
- skills/cortex-ai-function-studio/packages/snowflake-ai-optimize-core/src/snowflake_ai_optimize/core/metrics/dispatch.py
- skills/cortex-ai-function-studio/packages/snowflake-ai-optimize-core/src/snowflake_ai_optimize/core/metrics/llm_judge.py
- skills/cortex-ai-function-studio/packages/snowflake-ai-optimize-core/src/snowflake_ai_optimize/core/metrics/protocol.py
- skills/cortex-ai-function-studio/packages/snowflake-ai-optimize-core/src/snowflake_ai_optimize/core/metrics/utils.py
- skills/cortex-ai-function-studio/packages/snowflake-ai-optimize-core/src/snowflake_ai_optimize/core/model_capabilities.json
- skills/cortex-ai-function-studio/packages/snowflake-ai-optimize-core/src/snowflake_ai_optimize/core/models.json
- skills/cortex-ai-function-studio/packages/snowflake-ai-optimize-core/src/snowflake_ai_optimize/core/optimize_registry.py
- skills/cortex-ai-function-studio/packages/snowflake-ai-optimize-core/src/snowflake_ai_optimize/core/py.typed
- skills/cortex-ai-function-studio/packages/snowflake-ai-optimize-core/src/snowflake_ai_optimize/core/run_params.py
- skills/cortex-ai-function-studio/packages/snowflake-ai-optimize-core/src/snowflake_ai_optimize/core/scorer.py
- skills/cortex-ai-function-studio/packages/snowflake-ai-optimize-core/src/snowflake_ai_optimize/core/session.py
- skills/cortex-ai-function-studio/packages/snowflake-ai-optimize-core/src/snowflake_ai_optimize/core/sproc_decorators.py
- skills/cortex-ai-function-studio/packages/snowflake-ai-optimize-core/src/snowflake_ai_optimize/core/sproc_render.py
- skills/cortex-ai-function-studio/packages/snowflake-ai-optimize-core/src/snowflake_ai_optimize/core/sql_utils.py
- skills/cortex-ai-function-studio/packages/snowflake-ai-optimize-core/src/snowflake_ai_optimize/core/stage.py
- skills/cortex-ai-function-studio/packages/snowflake-ai-optimize-core/src/snowflake_ai_optimize/core/temp_ai_function.py
- skills/cortex-ai-function-studio/packages/snowflake-ai-optimize-core/src/snowflake_ai_optimize/core/timing.py
- skills/cortex-ai-function-studio/packages/snowflake-ai-optimize-core/src/snowflake_ai_optimize/core/types.py
- skills/cortex-ai-function-studio/packages/snowflake-ai-optimize-core/src/snowflake_ai_optimize/core/udf_ddl.py
- skills/cortex-ai-function-studio/packages/snowflake-ai-optimize-core/src/snowflake_ai_optimize/core/udf_types.py
- skills/cortex-ai-function-studio/packages/snowflake-ai-optimize-gepa/pyproject.toml
- skills/cortex-ai-function-studio/packages/snowflake-ai-optimize-gepa/src/snowflake_ai_optimize/gepa/__init__.py
- skills/cortex-ai-function-studio/packages/snowflake-ai-optimize-gepa/src/snowflake_ai_optimize/gepa/_registry.py
- skills/cortex-ai-function-studio/packages/snowflake-ai-optimize-gepa/src/snowflake_ai_optimize/gepa/adapter.py
- skills/cortex-ai-function-studio/packages/snowflake-ai-optimize-gepa/src/snowflake_ai_optimize/gepa/engine.py
- skills/cortex-ai-function-studio/packages/snowflake-ai-optimize-gepa/src/snowflake_ai_optimize/gepa/engine_registry.py
- skills/cortex-ai-function-studio/packages/snowflake-ai-optimize-gepa/src/snowflake_ai_optimize/gepa/experiment.py
- skills/cortex-ai-function-studio/packages/snowflake-ai-optimize-gepa/src/snowflake_ai_optimize/gepa/optimize.py
- skills/cortex-ai-function-studio/packages/snowflake-ai-optimize-gepa/src/snowflake_ai_optimize/gepa/optimize_body.py
- skills/cortex-ai-function-studio/packages/snowflake-ai-optimize-gepa/src/snowflake_ai_optimize/gepa/optimize_prompt.py
- skills/cortex-ai-function-studio/packages/snowflake-ai-optimize-gepa/src/snowflake_ai_optimize/gepa/py.typed
- skills/cortex-ai-function-studio/packages/snowflake-ai-optimize-synthetic/pyproject.toml
- skills/cortex-ai-function-studio/packages/snowflake-ai-optimize-synthetic/src/snowflake_ai_optimize/synthetic/__init__.py
- skills/cortex-ai-function-studio/packages/snowflake-ai-optimize-synthetic/src/snowflake_ai_optimize/synthetic/py.typed
- skills/cortex-ai-function-studio/packages/snowflake-ai-optimize-synthetic/src/snowflake_ai_optimize/synthetic/synthetic_data.py
- skills/cortex-ai-function-studio/pyproject.toml
- skills/cortex-ai-function-studio/references/access_control.md
- skills/cortex-ai-function-studio/references/ai-function-rules.md
- skills/cortex-ai-function-studio/references/async_status.md
- skills/cortex-ai-function-studio/references/byom/deploy_model_yaml_template.yml
- skills/cortex-ai-function-studio/references/byom/import_model_yaml_template.yml
- skills/cortex-ai-function-studio/references/byom/model_catalog.md
- skills/cortex-ai-function-studio/references/byom/spcs_service_template.md
- skills/cortex-ai-function-studio/references/cost_estimation.md
- skills/cortex-ai-function-studio/references/custom_metrics.md
- skills/cortex-ai-function-studio/references/data_preparation.md
- skills/cortex-ai-function-studio/references/metrics.md
- skills/cortex-ai-function-studio/references/model_selection.md
- skills/cortex-ai-function-studio/references/multimodal_setup.md
- skills/cortex-ai-function-studio/references/prerequisites.md
- skills/cortex-ai-function-studio/references/presentation_quick_ref.md
- skills/cortex-ai-function-studio/references/snowsight/core.md
- skills/cortex-ai-function-studio/references/snowsight/create.md
- skills/cortex-ai-function-studio/references/snowsight/custom_metrics.md
- skills/cortex-ai-function-studio/references/snowsight/evaluate.md
- skills/cortex-ai-function-studio/references/snowsight/optimize.md
- skills/cortex-ai-function-studio/references/snowsight/synthetic_data.md
- skills/cortex-ai-function-studio/scripts/__init__.py
- skills/cortex-ai-function-studio/scripts/create_udf.py
- skills/cortex-ai-function-studio/scripts/data_generators/__init__.py
- skills/cortex-ai-function-studio/scripts/data_generators/generate_claims_data.py
- skills/cortex-ai-function-studio/scripts/data_generators/generate_cuad_data.py
- skills/cortex-ai-function-studio/scripts/data_generators/generate_redaction_data.py
- skills/cortex-ai-function-studio/scripts/data_generators/generate_sec_filing_data.py
- skills/cortex-ai-function-studio/scripts/data_generators/generate_toxicity_data.py
- skills/cortex-ai-function-studio/scripts/deploy_ai_function_manager.py
- skills/cortex-ai-function-studio/scripts/notebook_manager.py
- skills/cortex-ai-function-studio/scripts/presentation.py
- skills/cortex-ai-function-studio/scripts/run.py
- skills/cortex-ai-function-studio/synthetic-data/SKILL.md
- skills/cortex-ai-function-studio/templates/evaluate_async_sproc.sql.j2
- skills/cortex-ai-function-studio/templates/evaluate_sproc.sql.j2
- skills/cortex-ai-function-studio/templates/optimize_async_sproc.sql.j2
- skills/cortex-ai-function-studio/templates/optimize_sproc.sql.j2
- skills/cortex-ai-function-studio/templates/sproc_config.yaml
- skills/cortex-ai-function-studio/templates/synthetic_data_sproc.sql.j2
- skills/cortex-ai-function-studio/tests/README.md
- skills/cortex-ai-function-studio/tests/__init__.py
- skills/cortex-ai-function-studio/tests/_experiment_golden.py
- skills/cortex-ai-function-studio/tests/_experiment_tree.py
- skills/cortex-ai-function-studio/tests/_optimize_scenario.py
- skills/cortex-ai-function-studio/tests/_paths.py
- skills/cortex-ai-function-studio/tests/conftest.py
- skills/cortex-ai-function-studio/tests/e2e_scenarios/optimize_input_types/01_single_text.yaml
- skills/cortex-ai-function-studio/tests/e2e_scenarios/optimize_input_types/03_integer.yaml
- skills/cortex-ai-function-studio/tests/e2e_scenarios/optimize_input_types/04_float.yaml
- skills/cortex-ai-function-studio/tests/e2e_scenarios/optimize_input_types/05_boolean.yaml
- skills/cortex-ai-function-studio/tests/e2e_scenarios/optimize_input_types/06_array.yaml
- skills/cortex-ai-function-studio/tests/e2e_scenarios/optimize_input_types/07_object.yaml
- skills/cortex-ai-function-studio/tests/e2e_scenarios/optimize_input_types/08_variant.yaml
- skills/cortex-ai-function-studio/tests/e2e_scenarios/yaml_handler/golden/eval_01_exact_named_list.golden.yaml
- skills/cortex-ai-function-studio/tests/e2e_scenarios/yaml_handler/golden/eval_02_exact_named_mapping_2runs.golden.yaml
- skills/cortex-ai-function-studio/tests/e2e_scenarios/yaml_handler/golden/eval_03_fuzzy_positional_list.golden.yaml
- skills/cortex-ai-function-studio/tests/e2e_scenarios/yaml_handler/golden/eval_04_contains_named_list.golden.yaml
- skills/cortex-ai-function-studio/tests/e2e_scenarios/yaml_handler/golden/eval_06_llmjudge_named_judgemodel.golden.yaml
- skills/cortex-ai-function-studio/tests/e2e_scenarios/yaml_handler/golden/eval_07_builtin_exact_argmap.golden.yaml
- skills/cortex-ai-function-studio/tests/e2e_scenarios/yaml_handler/golden/eval_08_builtin_contains_noargmap.golden.yaml
- skills/cortex-ai-function-studio/tests/e2e_scenarios/yaml_handler/golden/eval_09_builtin_fuzzy_noargmap.golden.yaml
- skills/cortex-ai-function-studio/tests/e2e_scenarios/yaml_handler/golden/eval_11_custom_udf_named.golden.yaml
- skills/cortex-ai-function-studio/tests/e2e_scenarios/yaml_handler/golden/opt_01_userfn_exact_holdout.golden.yaml
- skills/cortex-ai-function-studio/tests/e2e_scenarios/yaml_handler/golden/opt_02_builtin_exact_holdout.golden.yaml
- skills/cortex-ai-function-studio/tests/e2e_scenarios/yaml_handler/golden/opt_03_userfn_fuzzy_noholdout.golden.yaml
- skills/cortex-ai-function-studio/tests/e2e_scenarios/yaml_handler/golden/opt_04_builtin_contains_noholdout.golden.yaml
- skills/cortex-ai-function-studio/tests/e2e_scenarios/yaml_handler/golden/opt_05_userfn_llmjudge_holdout.golden.yaml
- skills/cortex-ai-function-studio/tests/e2e_scenarios/yaml_handler/golden/opt_06_userfn_custom_holdout.golden.yaml
- skills/cortex-ai-function-studio/tests/e2e_scenarios/yaml_handler/golden/opt_07_userfn_exact_positional_default_reflection.golden.yaml
- skills/cortex-ai-function-studio/tests/e2e_scenarios/yaml_handler/golden/opt_08_multimodel_exact_holdout.golden.yaml
- skills/cortex-ai-function-studio/tests/e2e_scenarios/yaml_handler/invalid/err_eval_conflicting_function.yaml
- skills/cortex-ai-function-studio/tests/e2e_scenarios/yaml_handler/invalid/err_eval_unsupported_metric.yaml
- skills/cortex-ai-function-studio/tests/e2e_scenarios/yaml_handler/invalid/err_opt_bad_budget.yaml
- skills/cortex-ai-function-studio/tests/e2e_scenarios/yaml_handler/invalid/err_opt_non_ai_complete_query_text.yaml
- skills/cortex-ai-function-studio/tests/e2e_scenarios/yaml_handler/specs/eval_01_exact_named_list.yaml
- skills/cortex-ai-function-studio/tests/e2e_scenarios/yaml_handler/specs/eval_02_exact_named_mapping_2runs.yaml
- skills/cortex-ai-function-studio/tests/e2e_scenarios/yaml_handler/specs/eval_03_fuzzy_positional_list.yaml
- skills/cortex-ai-function-studio/tests/e2e_scenarios/yaml_handler/specs/eval_04_contains_named_list.yaml
- skills/cortex-ai-function-studio/tests/e2e_scenarios/yaml_handler/specs/eval_06_llmjudge_named_judgemodel.yaml
- skills/cortex-ai-function-studio/tests/e2e_scenarios/yaml_handler/specs/eval_07_builtin_exact_argmap.yaml
- skills/cortex-ai-function-studio/tests/e2e_scenarios/yaml_handler/specs/eval_08_builtin_contains_noargmap.yaml
- skills/cortex-ai-function-studio/tests/e2e_scenarios/yaml_handler/specs/eval_09_builtin_fuzzy_noargmap.yaml
- skills/cortex-ai-function-studio/tests/e2e_scenarios/yaml_handler/specs/eval_11_custom_udf_named.yaml
- skills/cortex-ai-function-studio/tests/e2e_scenarios/yaml_handler/specs/opt_01_userfn_exact_holdout.yaml
- skills/cortex-ai-function-studio/tests/e2e_scenarios/yaml_handler/specs/opt_02_builtin_exact_holdout.yaml
- skills/cortex-ai-function-studio/tests/e2e_scenarios/yaml_handler/specs/opt_03_userfn_fuzzy_noholdout.yaml
- skills/cortex-ai-function-studio/tests/e2e_scenarios/yaml_handler/specs/opt_04_builtin_contains_noholdout.yaml
- skills/cortex-ai-function-studio/tests/e2e_scenarios/yaml_handler/specs/opt_05_userfn_llmjudge_holdout.yaml
- skills/cortex-ai-function-studio/tests/e2e_scenarios/yaml_handler/specs/opt_06_userfn_custom_holdout.yaml
- skills/cortex-ai-function-studio/tests/e2e_scenarios/yaml_handler/specs/opt_07_userfn_exact_positional_default_reflection.yaml
- skills/cortex-ai-function-studio/tests/e2e_scenarios/yaml_handler/specs/opt_08_multimodel_exact_holdout.yaml
- skills/cortex-ai-function-studio/tests/test_adapter.py
- skills/cortex-ai-function-studio/tests/test_body_reflection_fatal.py
- skills/cortex-ai-function-studio/tests/test_budget_and_split.py
- skills/cortex-ai-function-studio/tests/test_budget_weight_benchmark_e2e.py
- skills/cortex-ai-function-studio/tests/test_byom_docs.py
- skills/cortex-ai-function-studio/tests/test_cost_compared_to_base.py
- skills/cortex-ai-function-studio/tests/test_create_udf_cli_e2e.py
- skills/cortex-ai-function-studio/tests/test_create_udf_raw_sql_cli_e2e.py
- skills/cortex-ai-function-studio/tests/test_create_udf_raw_sql_unit.py
- skills/cortex-ai-function-studio/tests/test_data_uploads_unit.py
- skills/cortex-ai-function-studio/tests/test_deploy_manager.py
- skills/cortex-ai-function-studio/tests/test_e2e.py
- skills/cortex-ai-function-studio/tests/test_error_taxonomy.py
- skills/cortex-ai-function-studio/tests/test_eval_detail_capture.py
- skills/cortex-ai-function-studio/tests/test_eval_opts_experiment_e2e.py
- skills/cortex-ai-function-studio/tests/test_execute_eval_opts_handler.py
- skills/cortex-ai-function-studio/tests/test_experiment_golden.py
- skills/cortex-ai-function-studio/tests/test_experiment_tree.py
- skills/cortex-ai-function-studio/tests/test_generate_object_tag_alter_e2e.py
- skills/cortex-ai-function-studio/tests/test_global_run_structure.py
- skills/cortex-ai-function-studio/tests/test_inline_eval_schema.py
- skills/cortex-ai-function-studio/tests/test_metrics.py
- skills/cortex-ai-function-studio/tests/test_model_capabilities.py
- skills/cortex-ai-function-studio/tests/test_notebook_manager.py
- skills/cortex-ai-function-studio/tests/test_optimize_body_feedback_truncation.py
- skills/cortex-ai-function-studio/tests/test_optimize_body_frontier_commit.py
- skills/cortex-ai-function-studio/tests/test_optimize_handler_reflection_forwarding.py
- skills/cortex-ai-function-studio/tests/test_optimize_input_types_e2e.py
- skills/cortex-ai-function-studio/tests/test_pareto_frontier_metrics.py
- skills/cortex-ai-function-studio/tests/test_presentation.py
- skills/cortex-ai-function-studio/tests/test_progressive_experiment_tracker.py
- skills/cortex-ai-function-studio/tests/test_query_text_eval_unit.py
- skills/cortex-ai-function-studio/tests/test_robust_ai_complete.py
- skills/cortex-ai-function-studio/tests/test_run_optimization_forwarding.py
- skills/cortex-ai-function-studio/tests/test_run_query_tag_e2e.py
- skills/cortex-ai-function-studio/tests/test_runner_scripts.py
- skills/cortex-ai-function-studio/tests/test_schema_patcher.py
- skills/cortex-ai-function-studio/tests/test_sproc_render.py
- skills/cortex-ai-function-studio/tests/test_sproc_render_cli_e2e.py
- skills/cortex-ai-function-studio/tests/test_sql_utils.py
- skills/cortex-ai-function-studio/tests/test_unit.py
- skills/cortex-ai-function-studio/tests/test_yaml_handler_golden_e2e.py
Every link opens the file at its source, pinned to the revision this page describes.