{"revision":"c10276e953456835cdbb1f3a60d58ae1980be353","document":{"id":21614,"path":"integrate-applications/integration-hub/snowflake.md","title":"Snowflake Spoke","bundle":null,"doc_type":null,"release":"australia","body":"\n# Snowflake Spoke\n\nManage 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.\n\n## Request apps on the Store\n\nVisit the [ServiceNow Store](https://store.servicenow.com/sn_appstore_store.do#!/store/home) 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](https://www.servicenow.com/docs/r/store-release-notes/sn-store-release-notes.html).\n\n## Integration Hub subscription\n\nThis spoke requires an Integration Hub subscription. For more information, see [Legal schedules - IntegrationHub overview](https://www.servicenow.com/content/dam/servicenow-assets/public/en-us/doc-type/legal/snc-addendum-integrationhub.pdf).\n\n## Spoke version\n\nSnowflake spoke v1.0.3 is the latest version. For version history of the spoke, see [Snowflake Spoke release notes](https://www.servicenow.com/docs/r/store-release-notes/store-integrationhub-rn-snowflake-spoke.html).\n\n## Supported versions\n\nThis spoke was built for Snowflake v2, but may be compatible with later versions.\n\n## Spoke requirements\n\nSnowflake account\n\n## Spoke dependencies\n\nIf you’re having trouble installing the app, ensure that these dependent plugins are installed:\n\n-   Complex Object \\(com.glide.cobject\\)\n-   ServiceNow Flow Designer - Dynamic Inputs \\(com.glide.hub.dynamic\\_inputs\\)\n-   ServiceNow Workflow Studio - Dynamic Outputs \\(com.glide.hub.dynamic\\_outputs\\)\n-   ServiceNow IntegrationHub Action Step - REST \\(com.glide.hub.action\\_step.rest\\)\n-   ServiceNow IntegrationHub Runtime \\(com.glide.hub.integration.runtime\\)\n-   Flow Designer - Flow Engine \\(com.glide.hub.flow\\_engine\\)\n-   Flow Designer Action Step - Payload Builder \\(com.glide.hub.action\\_step.payload\\)\n\n**Note:** Some of these plugins are licensable features and require appropriate licenses, if used outside the spoke implementation.\n\n## Spoke actions\n\nThe Snowflake spoke provides actions to automate Snowflake data manipulation tasks when events occurs in your ServiceNow instance. Available actions include:\n\n<table id=\"table_p5w_f4x_c2c\"><thead><tr><th>\n\nCategory\n\n</th><th>\n\nAction\n\n</th><th>\n\nDescription\n\n</th></tr></thead><tbody><tr><td rowspan=\"7\">\n\nRecord Management\n\n</td><td>\n\nCreate Record\n\n</td><td>\n\nCreates a record in the Snowflake tables with the specified details using the INSERT statement.\n\n</td></tr><tr><td>\n\nDelete Records\n\n</td><td>\n\nDeletes the specified records in the Snowflake tables using the DELETE statement.\n\n</td></tr><tr><td>\n\nExecute Custom Query\n\n</td><td>\n\nRuns the custom query in the Snowflake database using a custom statement and retrieves the result.\n\n</td></tr><tr><td>\n\nLook up Columns\n\n</td><td>\n\nRetrieves 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.\n\n</td></tr><tr><td>\n\nLook up Records\n\n</td><td>\n\nRuns the SELECT statement and retrieves the matching records from Snowflake tables.\n\n</td></tr><tr><td>\n\nLook up Tables\n\n</td><td>\n\nRetrieves 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.\n\n</td></tr><tr><td>\n\nUpdate Records\n\n</td><td>\n\nUpdates the specified records in the Snowflake tables using the UPDATE statement.\n\n</td></tr></tbody>\n</table>"}}