OCNORA
Start free

Snowflake

Databases & warehousesBearer tokencredential probe

Snowflake — SQL, warehouses, tasks, pipes, stages, users/roles, Snowpark Container Services and Cortex AI (via the SQL + REST APIs).

OCNORA ships 105 typed Snowflake operations. Each node has a schema-driven form, input and output tables beside its settings, and is pre-flighted by Workflow Health before your first real run.

Connect Snowflake freeSnowflake API docs ↗

Operations 105

  • REST API Call
    Call any Snowflake REST endpoint under /api/v2/.
    snowflake.api
  • Cortex Analyst
    Ask Cortex Analyst a question against a semantic model.
    snowflake.cortex_analyst
  • Cortex Complete
    Run an LLM completion with Snowflake Cortex.
    snowflake.cortex_complete
  • Cortex Embed Text
    Embed text (768-d) with Snowflake Cortex.
    snowflake.cortex_embed
  • Cortex Extract Answer
    Answer a question from a document with Snowflake Cortex.
    snowflake.cortex_extract_answer
  • Cortex Search
    Query a Cortex Search service.
    snowflake.cortex_search
  • Cortex Sentiment
    Score sentiment (-1…1) with Snowflake Cortex.
    snowflake.cortex_sentiment
  • Cortex Summarize
    Summarize text with Snowflake Cortex.
    snowflake.cortex_summarize
  • Cortex Translate
    Translate text with Snowflake Cortex.
    snowflake.cortex_translate
  • Create Compute Pool
    Create a compute pool.
    snowflake.create_compute_pool
  • Create Database
    Create a database.
    snowflake.create_database
  • Create Database Role
    Create a database role in a database.
    snowflake.create_database_role
  • Create Image Repository
    Create a image repository in a schema.
    snowflake.create_image_repository
  • Create Role
    Create a role.
    snowflake.create_role
  • Create Schema
    Create a schema in a database.
    snowflake.create_schema
  • Create Stage
    Create a stage in a schema.
    snowflake.create_stage
  • Create Stream
    Create a stream in a schema.
    snowflake.create_stream
  • Create User
    Create a user.
    snowflake.create_user
  • Create Warehouse
    Create a warehouse.
    snowflake.create_warehouse
  • Drop Alert
    Drop a alert (ifExists by default).
    snowflake.drop_alert
  • Drop Compute Pool
    Drop a compute pool (ifExists by default).
    snowflake.drop_compute_pool
  • Drop Database
    Drop a database (ifExists by default).
    snowflake.drop_database
  • Drop Database Role
    Drop a database role (ifExists by default).
    snowflake.drop_database_role
  • Drop Image Repository
    Drop a image repository (ifExists by default).
    snowflake.drop_image_repository
  • Drop Role
    Drop a role (ifExists by default).
    snowflake.drop_role
  • Drop Schema
    Drop a schema (ifExists by default).
    snowflake.drop_schema
  • Drop Stage
    Drop a stage (ifExists by default).
    snowflake.drop_stage
  • Drop Stream
    Drop a stream (ifExists by default).
    snowflake.drop_stream
  • Drop Table
    Drop a table (ifExists by default).
    snowflake.drop_table
  • Drop User
    Drop a user (ifExists by default).
    snowflake.drop_user
  • Drop View
    Drop a view (ifExists by default).
    snowflake.drop_view
  • Drop Warehouse
    Drop a warehouse (ifExists by default).
    snowflake.drop_warehouse
  • Execute Alert
    Execute a alert (POST …:execute).
    snowflake.execute_alert
  • Execute Notebook
    Execute a notebook (POST …:execute).
    snowflake.execute_notebook
  • Execute Task
    Execute a task (POST …:execute).
    snowflake.execute_task
  • Get Alert
    Fetch one alert by name.
    snowflake.get_alert
  • Get Api Integration
    Fetch one api integration by name.
    snowflake.get_api_integration
  • Get Catalog Integration
    Fetch one catalog integration by name.
    snowflake.get_catalog_integration
  • Get Compute Pool
    Fetch one compute pool by name.
    snowflake.get_compute_pool
  • Get Database
    Fetch one database by name.
    snowflake.get_database
  • Get Dynamic Table
    Fetch one dynamic table by name.
    snowflake.get_dynamic_table
  • Get Event Table
    Fetch one event table by name.
    snowflake.get_event_table
  • Get External Volume
    Fetch one external volume by name.
    snowflake.get_external_volume
  • Get Function
    Fetch one function by name.
    snowflake.get_function
  • Get Iceberg Table
    Fetch one iceberg table by name.
    snowflake.get_iceberg_table
  • Get Image Repository
    Fetch one image repository by name.
    snowflake.get_image_repository
  • Get Network Policy
    Fetch one network policy by name.
    snowflake.get_network_policy
  • Get Notebook
    Fetch one notebook by name.
    snowflake.get_notebook
Show 57 more
  • Get Notification Integration
    Fetch one notification integration by name.
    snowflake.get_notification_integration
  • Get Pipe
    Fetch one pipe by name.
    snowflake.get_pipe
  • Get Procedure
    Fetch one procedure by name.
    snowflake.get_procedure
  • Get Schema
    Fetch one schema by name.
    snowflake.get_schema
  • Get Container Service
    Fetch one container service by name.
    snowflake.get_service
  • Get Stage
    Fetch one stage by name.
    snowflake.get_stage
  • Get Stream
    Fetch one stream by name.
    snowflake.get_stream
  • Get Table
    Fetch one table by name.
    snowflake.get_table
  • Get Task
    Fetch one task by name.
    snowflake.get_task
  • Get User
    Fetch one user by name.
    snowflake.get_user
  • Get View
    Fetch one view by name.
    snowflake.get_view
  • Get Warehouse
    Fetch one warehouse by name.
    snowflake.get_warehouse
  • Grant Privileges to Role
    Grant privileges on a securable to a role.
    snowflake.grant_role_privileges
  • Insert Rows
    Insert one or more rows into a Snowflake table.
    snowflake.insert
  • List Accounts
    List accounts.
    snowflake.list_accounts
  • List Alerts
    List alerts in a schema.
    snowflake.list_alerts
  • List Api Integrations
    List api integrations.
    snowflake.list_api_integrations
  • List Catalog Integrations
    List catalog integrations.
    snowflake.list_catalog_integrations
  • List Compute Pools
    List compute pools.
    snowflake.list_compute_pools
  • List Database Roles
    List database roles in a database.
    snowflake.list_database_roles
  • List Databases
    List databases.
    snowflake.list_databases
  • List Dynamic Tables
    List dynamic tables in a schema.
    snowflake.list_dynamic_tables
  • List Event Tables
    List event tables in a schema.
    snowflake.list_event_tables
  • List External Volumes
    List external volumes.
    snowflake.list_external_volumes
  • List Functions
    List functions in a schema.
    snowflake.list_functions
  • List Iceberg Tables
    List iceberg tables in a schema.
    snowflake.list_iceberg_tables
  • List Image Repositories
    List image repositories in a schema.
    snowflake.list_image_repositories
  • List Managed Accounts
    List managed accounts.
    snowflake.list_managed_accounts
  • List Network Policies
    List network policies.
    snowflake.list_network_policies
  • List Notebooks
    List notebooks in a schema.
    snowflake.list_notebooks
  • List Notification Integrations
    List notification integrations.
    snowflake.list_notification_integrations
  • List Pipes
    List pipes in a schema.
    snowflake.list_pipes
  • List Procedures
    List procedures in a schema.
    snowflake.list_procedures
  • List Role Grants
    List the privileges granted to a role.
    snowflake.list_role_grants
  • List Roles
    List roles.
    snowflake.list_roles
  • List Schemas
    List schemas in a database.
    snowflake.list_schemas
  • List Services
    List services in a schema.
    snowflake.list_services
  • List Stage Files
    List the files on a stage.
    snowflake.list_stage_files
  • List Stages
    List stages in a schema.
    snowflake.list_stages
  • List Streams
    List streams in a schema.
    snowflake.list_streams
  • List Tables
    List tables in a schema.
    snowflake.list_tables
  • List Tasks
    List tasks in a schema.
    snowflake.list_tasks
  • List Users
    List users.
    snowflake.list_users
  • List Views
    List views in a schema.
    snowflake.list_views
  • List Warehouses
    List warehouses.
    snowflake.list_warehouses
  • Run Query
    Run a SQL statement against Snowflake (SELECT returns rows).
    snowflake.query
  • Refresh Pipe
    Refresh a pipe (POST …:refresh).
    snowflake.refresh_pipe
  • Resume Compute Pool
    Resume a compute pool (POST …:resume).
    snowflake.resume_compute_pool
  • Resume Dynamic Table
    Resume a dynamic table (POST …:resume).
    snowflake.resume_dynamic_table
  • Resume Container Service
    Resume a container service (POST …:resume).
    snowflake.resume_service
  • Resume Task
    Resume a task (POST …:resume).
    snowflake.resume_task
  • Resume Warehouse
    Resume a warehouse (POST …:resume).
    snowflake.resume_warehouse
  • Suspend Compute Pool
    Suspend a compute pool (POST …:suspend).
    snowflake.suspend_compute_pool
  • Suspend Dynamic Table
    Suspend a dynamic table (POST …:suspend).
    snowflake.suspend_dynamic_table
  • Suspend Container Service
    Suspend a container service (POST …:suspend).
    snowflake.suspend_service
  • Suspend Task
    Suspend a task (POST …:suspend).
    snowflake.suspend_task
  • Suspend Warehouse
    Suspend a warehouse (POST …:suspend).
    snowflake.suspend_warehouse

More in Databases & warehouses

Run your first Snowflake workflow today.

Create a free workspace, add the connection, pick a template or describe the workflow to Build with AI. Workflow Health checks it before it runs.

Start freeBook a demo