Getting Started¶
This guide walks you through everything needed to connect to the AWS Databricks Lakehouse and run your first query.
Prerequisites¶
| Requirement | Notes |
|---|---|
| AWS IAM access | You need an IAM identity with permission to assume the Databricks role |
| Databricks account | Request access from your workspace admin |
| Python 3.9+ | Required for the Databricks CLI and local development |
| AWS CLI v2 | Required to configure credentials |
Step 1 — Configure AWS credentials¶
aws configure --profile lakehouse
# Enter: Access Key ID, Secret Access Key, region (e.g. us-east-1), output format (json)
Verify:
Step 2 — Install the Databricks CLI¶
Step 3 — Configure the Databricks CLI¶
databricks configure --token
# Host: https://<workspace-id>.cloud.databricks.com
# Token: <personal-access-token>
Verify:
Step 4 — Clone the notebooks repo (optional)¶
If your team manages notebooks in source control:
Step 5 — Run a test query¶
Open the Databricks SQL editor or a notebook and run:
You should see your user, the default catalog (unity_catalog), and schema.
Environments¶
| Environment | Workspace URL | Catalog prefix |
|---|---|---|
| Development | https://dev-<id>.cloud.databricks.com |
dev_ |
| Staging | https://staging-<id>.cloud.databricks.com |
stg_ |
| Production | https://prod-<id>.cloud.databricks.com |
prd_ |
Warning
Production credentials are managed via AWS Secrets Manager. Never store production tokens in plain text or commit them to version control.
Troubleshooting¶
PERMISSION_DENIED on a table
: Request access from the Unity Catalog admin. Permissions are granted at the catalog, schema, or table level.
Cluster fails to start : Check the cluster event log in the Databricks UI. Common causes are insufficient EC2 quota or a missing IAM instance profile.
NoCredentialProviders error in AWS CLI
: Run aws configure --profile lakehouse again or check that AWS_PROFILE=lakehouse is exported in your shell.