Snowflake
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.
Before you connect Snowflake
- Authentication
- Bearer token
- Credential
- the token, or {"token": "…"}
- Connection test
- Available: the stored credential can be checked against the provider when you add it. This is not a record that a test was run or passed.
What you can do with Snowflake
Operations, grouped by what they do to your data.
Create and send 15
Read and search 56
Update 6
Other operations 28
A sample Snowflake workflow
- 1A core triggerStart the run from a chat, form, manual, schedule, webhook, workflow trigger — no Snowflake trigger is needed.
- 2Get Alertsnowflake.get_alertFetch one alert by name.
- 3REST API Callsnowflake.apiCall any Snowflake REST endpoint under /api/v2/.
An outline built from this provider’s node contracts, not a recorded run. Each step’s output fields are available to the next in the field picker.
Every node below has a reference page: what it does, the connection it needs, its config fields with types, constraints and examples, and the shapes it emits.
Operations 105
- REST API CallCall any Snowflake REST endpoint under /api/v2/.snowflake.api
- Cortex AnalystAsk Cortex Analyst a question against a semantic model.snowflake.cortex_analyst
- Cortex CompleteRun an LLM completion with Snowflake Cortex.snowflake.cortex_complete
- Cortex Embed TextEmbed text (768-d) with Snowflake Cortex.snowflake.cortex_embed
- Cortex Extract AnswerAnswer a question from a document with Snowflake Cortex.snowflake.cortex_extract_answer
- Cortex SearchQuery a Cortex Search service.snowflake.cortex_search
- Cortex SentimentScore sentiment (-1…1) with Snowflake Cortex.snowflake.cortex_sentiment
- Cortex SummarizeSummarize text with Snowflake Cortex.snowflake.cortex_summarize
- Cortex TranslateTranslate text with Snowflake Cortex.snowflake.cortex_translate
- Create Compute PoolCreate a compute pool.snowflake.create_compute_pool
- Create DatabaseCreate a database.snowflake.create_database
- Create Database RoleCreate a database role in a database.snowflake.create_database_role
- Create Image RepositoryCreate a image repository in a schema.snowflake.create_image_repository
- Create RoleCreate a role.snowflake.create_role
- Create SchemaCreate a schema in a database.snowflake.create_schema
- Create StageCreate a stage in a schema.snowflake.create_stage
- Create StreamCreate a stream in a schema.snowflake.create_stream
- Create UserCreate a user.snowflake.create_user
- Create WarehouseCreate a warehouse.snowflake.create_warehouse
- Drop AlertDrop a alert (ifExists by default).snowflake.drop_alert
- Drop Compute PoolDrop a compute pool (ifExists by default).snowflake.drop_compute_pool
- Drop DatabaseDrop a database (ifExists by default).snowflake.drop_database
- Drop Database RoleDrop a database role (ifExists by default).snowflake.drop_database_role
- Drop Image RepositoryDrop a image repository (ifExists by default).snowflake.drop_image_repository
- Drop RoleDrop a role (ifExists by default).snowflake.drop_role
- Drop SchemaDrop a schema (ifExists by default).snowflake.drop_schema
- Drop StageDrop a stage (ifExists by default).snowflake.drop_stage
- Drop StreamDrop a stream (ifExists by default).snowflake.drop_stream
- Drop TableDrop a table (ifExists by default).snowflake.drop_table
- Drop UserDrop a user (ifExists by default).snowflake.drop_user
- Drop ViewDrop a view (ifExists by default).snowflake.drop_view
- Drop WarehouseDrop a warehouse (ifExists by default).snowflake.drop_warehouse
- Execute AlertExecute a alert (POST …:execute).snowflake.execute_alert
- Execute NotebookExecute a notebook (POST …:execute).snowflake.execute_notebook
- Execute TaskExecute a task (POST …:execute).snowflake.execute_task
- Get AlertFetch one alert by name.snowflake.get_alert
- Get Api IntegrationFetch one api integration by name.snowflake.get_api_integration
- Get Catalog IntegrationFetch one catalog integration by name.snowflake.get_catalog_integration
- Get Compute PoolFetch one compute pool by name.snowflake.get_compute_pool
- Get DatabaseFetch one database by name.snowflake.get_database
- Get Dynamic TableFetch one dynamic table by name.snowflake.get_dynamic_table
- Get Event TableFetch one event table by name.snowflake.get_event_table
- Get External VolumeFetch one external volume by name.snowflake.get_external_volume
- Get FunctionFetch one function by name.snowflake.get_function
- Get Iceberg TableFetch one iceberg table by name.snowflake.get_iceberg_table
- Get Image RepositoryFetch one image repository by name.snowflake.get_image_repository
- Get Network PolicyFetch one network policy by name.snowflake.get_network_policy
- Get NotebookFetch one notebook by name.snowflake.get_notebook
Show 57 more
- Get Notification IntegrationFetch one notification integration by name.snowflake.get_notification_integration
- Get PipeFetch one pipe by name.snowflake.get_pipe
- Get ProcedureFetch one procedure by name.snowflake.get_procedure
- Get SchemaFetch one schema by name.snowflake.get_schema
- Get Container ServiceFetch one container service by name.snowflake.get_service
- Get StageFetch one stage by name.snowflake.get_stage
- Get StreamFetch one stream by name.snowflake.get_stream
- Get TableFetch one table by name.snowflake.get_table
- Get TaskFetch one task by name.snowflake.get_task
- Get UserFetch one user by name.snowflake.get_user
- Get ViewFetch one view by name.snowflake.get_view
- Get WarehouseFetch one warehouse by name.snowflake.get_warehouse
- Grant Privileges to RoleGrant privileges on a securable to a role.snowflake.grant_role_privileges
- Insert RowsInsert one or more rows into a Snowflake table.snowflake.insert
- List AccountsList accounts.snowflake.list_accounts
- List AlertsList alerts in a schema.snowflake.list_alerts
- List Api IntegrationsList api integrations.snowflake.list_api_integrations
- List Catalog IntegrationsList catalog integrations.snowflake.list_catalog_integrations
- List Compute PoolsList compute pools.snowflake.list_compute_pools
- List Database RolesList database roles in a database.snowflake.list_database_roles
- List DatabasesList databases.snowflake.list_databases
- List Dynamic TablesList dynamic tables in a schema.snowflake.list_dynamic_tables
- List Event TablesList event tables in a schema.snowflake.list_event_tables
- List External VolumesList external volumes.snowflake.list_external_volumes
- List FunctionsList functions in a schema.snowflake.list_functions
- List Iceberg TablesList iceberg tables in a schema.snowflake.list_iceberg_tables
- List Image RepositoriesList image repositories in a schema.snowflake.list_image_repositories
- List Managed AccountsList managed accounts.snowflake.list_managed_accounts
- List Network PoliciesList network policies.snowflake.list_network_policies
- List NotebooksList notebooks in a schema.snowflake.list_notebooks
- List Notification IntegrationsList notification integrations.snowflake.list_notification_integrations
- List PipesList pipes in a schema.snowflake.list_pipes
- List ProceduresList procedures in a schema.snowflake.list_procedures
- List Role GrantsList the privileges granted to a role.snowflake.list_role_grants
- List RolesList roles.snowflake.list_roles
- List SchemasList schemas in a database.snowflake.list_schemas
- List ServicesList services in a schema.snowflake.list_services
- List Stage FilesList the files on a stage.snowflake.list_stage_files
- List StagesList stages in a schema.snowflake.list_stages
- List StreamsList streams in a schema.snowflake.list_streams
- List TablesList tables in a schema.snowflake.list_tables
- List TasksList tasks in a schema.snowflake.list_tasks
- List UsersList users.snowflake.list_users
- List ViewsList views in a schema.snowflake.list_views
- List WarehousesList warehouses.snowflake.list_warehouses
- Run QueryRun a SQL statement against Snowflake (SELECT returns rows).snowflake.query
- Refresh PipeRefresh a pipe (POST …:refresh).snowflake.refresh_pipe
- Resume Compute PoolResume a compute pool (POST …:resume).snowflake.resume_compute_pool
- Resume Dynamic TableResume a dynamic table (POST …:resume).snowflake.resume_dynamic_table
- Resume Container ServiceResume a container service (POST …:resume).snowflake.resume_service
- Resume TaskResume a task (POST …:resume).snowflake.resume_task
- Resume WarehouseResume a warehouse (POST …:resume).snowflake.resume_warehouse
- Suspend Compute PoolSuspend a compute pool (POST …:suspend).snowflake.suspend_compute_pool
- Suspend Dynamic TableSuspend a dynamic table (POST …:suspend).snowflake.suspend_dynamic_table
- Suspend Container ServiceSuspend a container service (POST …:suspend).snowflake.suspend_service
- Suspend TaskSuspend a task (POST …:suspend).snowflake.suspend_task
- Suspend WarehouseSuspend a warehouse (POST …:suspend).snowflake.suspend_warehouse
Snowflake questions
- How does OCNORA authenticate with Snowflake?
- With a stored Bearer token credential, shaped the token, or {"token": "…"}. A connection test can check it when you add it.
- What can I automate with Snowflake?
- 105 typed operations, each with a reference page listing its config fields and the shapes it emits.
- What if the Snowflake operation I need is not listed?
- Where Snowflake has an HTTP API, call it from the HTTP node with the same credential, or describe the step to the AI builder, which asks our team for a typed node when one is missing.
- Are there templates that use Snowflake?
- Not yet. Start from a blank workflow, or describe the workflow to Build with AI.
- How are Snowflake calls controlled?
- Every call and every run step is audited, runs count against the execution budget, and Workflow Health pre-flights the workflow when you save it.
More in Databases & warehouses
See your first Snowflake workflow run.
Book a technical demo. We add the connection, pick a template or describe the workflow to Build with AI, and Workflow Health checks it before it runs.