AWS Databricks connection

AWS Databricks is a unified, cloud-based analytics platform on AWS that combines data warehousing and data lake capabilities.

Limitations

Only structured relational databases are supported.

Create a connection to AWS Databricks

To access your data in AWS Databricks, create a connection to it.

Enter these connection details and select an authentication method.

Connection details

  • Connection name

  • Hostname or IP address of the database

  • Port number

  • HTTP path: Path of the endpoint for which the server is configured in HTTP transport mode.

  • Keepalive interval: Interval in seconds between keepalive validation queries. Set to a value greater than 0 to enable keepalive.

Credentials

Choose an authentication method:

  • Service principal credentials - A service principal is a specialized Databricks identity for automation and programmatic access. It provides secure, API-only access to Databricks resources without using individual user credentials. For more information, see Manage service principals.

    • Client ID of service principal: The client ID of service prinicpal managed by Databricks on AWS.

    • Client secret of service principal: The authentication key that is associated with the client ID of service principal managed by Databricks on AWS.

  • Username and password for the data source