Snowflake Spoke
Summarize
Summary of Snowflake Spoke
The Snowflake Spoke enables ServiceNow users to manage data warehousing capabilities directly from their ServiceNow instance. Users can perform tasks such as creating, deleting, searching records, executing queries, and other data manipulations in Snowflake seamlessly through ServiceNow. This functionality enhances efficiency by integrating data management into existing workflows.
Show less
Key Features
- Record Management: Automate data manipulation tasks with various actions including creating, deleting, updating, and retrieving records.
- Execute Custom Queries: Run custom queries on your Snowflake database and retrieve results as needed.
- Look Up Operations: Retrieve columns, records, and tables from Snowflake, ensuring that your Service Account has the necessary access privileges.
Key Outcomes
By utilizing the Snowflake Spoke, ServiceNow customers can streamline their data management processes, reduce the need for switching between platforms, and automate key tasks. This integration not only saves time but also enhances data accuracy and accessibility within the ServiceNow environment.
Prerequisites
To utilize this spoke, an Integration Hub subscription is required. Additionally, ensure that your Snowflake account is set up and that the following dependent plugins are installed:
- Complex Object (com.glide.cobject)
- ServiceNow Flow Designer - Dynamic Inputs (com.glide.hub.dynamicinputs)
- ServiceNow Workflow Studio - Dynamic Outputs (com.glide.hub.dynamicoutputs)
- ServiceNow IntegrationHub Action Step - REST (com.glide.hub.actionstep.rest)
- ServiceNow IntegrationHub Runtime (com.glide.hub.integration.runtime)
- Flow Designer - Flow Engine (com.glide.hub.flowengine)
- Flow Designer Action Step - Payload Builder (com.glide.hub.actionstep.payload)
Note: Some plugins may require appropriate licenses if used outside of the spoke implementation.
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 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
- 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)
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. |