{"revision":"c10276e953456835cdbb1f3a60d58ae1980be353","document":{"id":21190,"path":"integrate-applications/integration-hub/databricks-spke.md","title":"Databricks Spoke","bundle":null,"doc_type":null,"release":"australia","body":"\n# Databricks Spoke\n\nRetrieves details of warehouses, tables, schemas, and catalogs, and executes SQL statements in Databricks 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\nDatabricks Spoke v1.0.1 is the latest version. For version history of the spoke, see [Databricks Spoke release notes](https://www.servicenow.com/docs/r/store-release-notes/store-integrationhub-rn-databricks-spoke.html).\n\n## Supported versions\n\nThis spoke was built for these versions of Databricks, but may be compatible with later versions:\n\n|Action category|Databricks version|\n|---------------|------------------|\n|Unity Catalog Management|API version 2.1|\n|SQL Management|API version 2.0|\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 IntegrationHub Runtime \\(com.glide.hub.integration.runtime\\)\n-   ServiceNow IntegrationHub Action Template - Data Stream \\(com.glide.hub.action\\_type.datastream\\)\n-   ServiceNow IntegrationHub Action Step - REST \\(com.glide.hub.action\\_step.rest\\)\n\n**Note:** Some of these plugins are licensable features and require appropriate licenses, if used outside the spoke implementation.\n\n## Spoke subflows\n\nThe Databricks spoke provides sample subflows to demonstrate automating tasks. To customize a sample subflow, copy it to a new application scope. Available sample subflows include:\n\n|Subflow|Description|\n|-------|-----------|\n|Look up Catalogs|Retrieves list of all catalogs.|\n|Look up Schemas|Retrieves list of all schemas from a specific catalog.|\n|Look up Tables|Retrieves list of all tables from a specific schema in a catalog.|\n|Sample - Execute Databricks SQL Statement|Executes a SQL statement on Databricks and returns the result columns and data array.|\n\n## Spoke actions\n\nThe Databricks spoke provides actions to automate tasks when events occurs in your ServiceNow instance. Available actions include:\n\n<table id=\"table_tp4_k3n_k3c\"><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=\"4\">\n\nSQL Management\n\n</td><td>\n\nExecute SQL Statement\n\n</td><td>\n\nExecutes the provided SQL statement.\n\n</td></tr><tr><td>\n\nLook up Execution Status\n\n</td><td>\n\nRetrieves the execution status of a SQL statement.\n\n</td></tr><tr><td>\n\nLook up Result Chunk by Index\n\n</td><td>\n\nRetrieves a specific chunk of the result set for a SQL statement by chunk index.**Note:** If the data you want to retrieve is more than 5MB, modify the default value of the system property **glide.pf.rest.response\\_payload\\_max\\_size** and increase it as per your requirement.\n\n</td></tr><tr><td>\n\nLook up Warehouses Stream\n\n</td><td>\n\nRetrieves a list of SQL warehouses.\n\n</td></tr><tr><td rowspan=\"3\">\n\nUnity Catalog Management\n\n</td><td>\n\nLook up Catalogs\n\n</td><td>\n\nRetrieves details of the required number of catalogs.**Note:** To retrieve list of all catalogs, use the Look up Catalogs subflow.\n\n</td></tr><tr><td>\n\nLook up Schemas\n\n</td><td>\n\nRetrieves details of the required number of schemas from a specific catalog.**Note:** To retrieve list of all schemas from a specific catalog, use the Look up Schemas subflow.\n\n</td></tr><tr><td>\n\nLook up Tables\n\n</td><td>\n\nRetrieves details of the required number of tables from a specific schema in a catalog.**Note:** To retrieve list of all tables from a specific schema in a catalog, use the Look up Tables subflow.\n\n</td></tr></tbody>\n</table>## Connection and credential alias requirements\n\nIntegration Hub uses aliases to manage connection and credential information, and OAuth credentials. Using an alias eliminates the need to configure multiple credentials and connection information profiles when using multiple environments. If the connection or credential information changes, you don't need to update any actions that use the connection.\n\n"}}