Databricks
Databricks is a unified data analytics platform that combines data warehousing, data lakes, and machine learning. Aptrics seamlessly integrates with Databricks to provide a governed semantic layer on top of your Databricks workspace.
This integration allows you to define metrics across your Databricks data and make them accessible to your entire organization through Aptrics' intuitive interface.
Integration Setup
Prerequisites
Before connecting Databricks to Aptrics, ensure you have access to a Databricks workspace and have enabled SQL Warehouse or cluster access. You'll need administrative access to create service principals and configure connection parameters.
Create Service Principal
In your Databricks workspace, create a service principal for Aptrics. Generate an API token and save it securely. This service principal should have permissions to query your data but not modify production tables.
Configure Connector
In Aptrics, navigate to your environment settings and add a new Databricks connector. Provide your workspace URL, HTTP path, and the API token for the service principal you created.
Test Connection
Click "Test Connection" to verify that Aptrics can access your Databricks workspace. If successful, Aptrics will discover available schemas and tables automatically.
Best Practices
Optimize Table Structure
Organize your tables in logical schemas and use clear naming conventions. This makes it easier for Aptrics to discover and catalog your data.
Enable Row-Level Security
Use Databricks row-level security policies in conjunction with Aptrics' access controls to ensure users only see data they're authorized to access.