{"revision":"c10276e953456835cdbb1f3a60d58ae1980be353","document":{"id":20659,"path":"integrate-applications/databricks-zcc.md","title":"Databricks","bundle":null,"doc_type":null,"release":"australia","body":"\n# Databricks\n\nThe Databricks connector provides read-only access to data and metadata from the Databricks data analytics platform.\n\nA connection admin can set up a connection to Databricks in the Zero Copy Connector Hub and grant data stewards access to this connection. Data stewards can then use the established connection to create a data fabric table and map data from Databricks. This allows users to access Databricks data through the table list view or by using GlideRecord scripts. For details on creating data fabric tables and mapping data, see [Managing data fabric tables](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/australia/integrate-applications/managing-data-fabric-tables-zcc.md).\n\nWhen you configure the connection with an access token, you can choose whether the connection authenticates using a shared, system-level OAuth entity profile or personal authentication.\n\n**Note:** With personal authentication, each user's access to Databricks data is authenticated and audited against their own credentials, not a shared account. This supports stricter access control and clearer audit trails.\n\nThe connector has been enhanced to improve the performance of the following Glide queries and list view operations. These improvements allow the majority of queries to be executed at the data source.\n\n-   Sort\n-   Limit\n-   Filter\n-   GroupBy\n-   avg\\(\\)\n-   count\\(\\)\n-   max\\(\\)\n-   min\\(\\)\n-   sum\\(\\)\n-   References\n\n## Supported data types\n\nThe following table lists supported Databricks data types and the default matching data types in a data fabric table.\n\n**Important:** Databricks data types not included in the table aren't supported for data mapping in Zero Copy Connector Hub.\n\n|Databricks|Data fabric table|\n|----------|-----------------|\n|bigint|Long Integer String|\n|int|Long Integer String|\n|smallint|Long Integer String|\n|tinyint|Long Integer String|\n|timestamp\\_ntz|Basic Date/Time|\n|char|Char|\n|timestamp|Basic Date/Time|\n|date|Date|\n|decimal|Decimal|\n|string|String|\n|boolean|True/False|\n|double|Floating Point Number|\n|float|Floating Point Number|\n\n**Related topics**  \n\n\n[Create a Databricks connection](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/australia/integrate-applications/create-databricks-connection-zcc.md)\n\n"}}