AWS Databricks connection

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

AWS Databricks is a big data analytics tool that is based on Apache Spark.

Create a connection to AWS Databricks

To create the connection asset, you need to enter the connection details and select an authentication method.

Connection details

  • Hostname or IP address of the database
  • Port number of the database
  • HTTP path: Path of the endpoint for which the server is configured in HTTP transport mode.

Authentication and credentials

You can choose between two methods of authentication.

Service Principal Authentication

Required credentials:

  • Client ID of service principal - client ID of service principal managed by Databricks on AWS
  • Client secret of service principal - authentication key associated with the client ID of service principal managed by Databricks on AWS

Username and password

Required credentials:

  • Username
  • Password

Federal Information Processing Standards (FIPS) compliance

This connection is FIPS-compliant and can be used on a FIPS-enabled cluster.

Running SQL statements

To ensure that your SQL statements run correctly, refer to the Databricks SQL language reference for the correct syntax.