Snowflake Spoke

  • Release version: Xanadu
  • Updated August 19, 2025
  • 2 minutes to read
    • Summarize
    Summarized using AI
    This content was generated using new OpenAI-powered functionality. Results are provided on an as is basis and are not guaranteed to be accurate or complete.

    Summary of Snowflake Spoke

    The Snowflake Spoke enables ServiceNow customers to manage Snowflake data warehousing capabilities directly from their ServiceNow instance. It allows you to perform key data operations such as creating, deleting, searching records, executing queries, and updating data within Snowflake without leaving the ServiceNow platform. This integration streamlines data manipulation workflows by embedding Snowflake actions into your ServiceNow processes.

    Show full answer Show less

    Key Features

    • Record Management: Create, delete, update, and look up records in Snowflake tables using standard SQL operations (INSERT, DELETE, UPDATE, SELECT).
    • Custom Queries: Execute custom SQL queries in Snowflake and retrieve the results directly within ServiceNow.
    • Metadata Retrieval: Look up columns and tables from specified Snowflake databases and warehouses, aiding dynamic data operations and validation.
    • Integration Hub Dependent: Requires an Integration Hub subscription and several dependent plugins related to Flow Designer and IntegrationHub runtime for full functionality.

    Practical Considerations

    • The spoke is compatible with Snowflake version 2 and potentially later versions.
    • Ensure your Snowflake service account has the necessary access privileges to the databases, tables, and columns you intend to manage.
    • Installation requires dependent plugins, some of which may require additional licenses if used beyond this spoke’s scope.
    • The latest available version of the spoke is v1.0.3.

    What to Expect

    By implementing the Snowflake Spoke, ServiceNow customers can automate and integrate Snowflake data operations seamlessly into ServiceNow workflows. This reduces the need to switch between platforms, improves operational efficiency, and supports advanced data management scenarios directly within ServiceNow.

    Manage data warehousing capabilities of Snowflake directly from your ServiceNow instance. You can create, delete, search, records, execute queries, and perform other data manipulation tasks in Snowflake from your ServiceNow instance.

    Request apps on the Store

    Visit the ServiceNow Store website to view all the available apps and for information about submitting requests to the store. For cumulative release notes information for all released apps, see the ServiceNow Store version history release notes.

    Integration Hub subscription

    This spoke requires an Integration Hub subscription. For more information, see Legal schedules - IntegrationHub overview.

    Spoke version

    Snowflake spoke v1.0.3 is the latest version.

    Supported versions

    This spoke was built for Snowflake v2, but may be compatible with later versions.

    Spoke requirements

    Snowflake account

    Spoke dependencies

    If you’re having trouble installing the app, ensure that these dependent plugins are installed:
    • Complex Object (com.glide.cobject)
    • ServiceNow Flow Designer - Dynamic Inputs (com.glide.hub.dynamic_inputs)
    • ServiceNow Workflow Studio - Dynamic Outputs (com.glide.hub.dynamic_outputs)
    • ServiceNow IntegrationHub Action Step - REST (com.glide.hub.action_step.rest)
    • ServiceNow IntegrationHub Runtime (com.glide.hub.integration.runtime)
    • Flow Designer - Flow Engine (com.glide.hub.flow_engine)
    • Flow Designer Action Step - Payload Builder (com.glide.hub.action_step.payload)
    Note:
    Some of these plugins are licensable features and require appropriate licenses, if used outside the spoke implementation.

    Spoke actions

    The Snowflake spoke provides actions to automate Snowflake data manipulation tasks when events occurs in your ServiceNow instance. Available actions include:

    Category Action Description
    Record Management Create Record Creates a record in the Snowflake tables with the specified details using the INSERT statement.
    Delete Records Deletes the specified records in the Snowflake tables using the DELETE statement.
    Execute Custom Query Runs the custom query in the Snowflake database using a custom statement and retrieves the result.
    Look up Columns Retrieves a list of columns from the Snowflake table.
    Note:
    Make sure that your Snowflake Service Account has access privilege to the columns that you want to fetch.
    Look up Records Runs the SELECT statement and retrieves the matching records from Snowflake tables.
    Look up Tables Retrieves a list of tables from the specified database and specified warehouse in Snowflake.
    Note:
    Make sure that your Snowflake Service Account has access privileges to the tables that you want to fetch.
    Update Records Updates the specified records in the Snowflake tables using the UPDATE statement.