databricks-lakebase-autoscale

You can set up autoscaling for PostgreSQL on Databricks by creating a Lakebase project. The service dynamically adjusts compute resources from 0.5 to 112 compute units based on your workload load.

Yes, you can create isolated database branches for development and testing. These branches provide isolated environments and automatically scale down to zero when inactive to save compute costs.

Databricks Lakebase supports scale-to-zero for managed PostgreSQL. It suspends compute resources automatically after a period of inactivity, which helps save costs for idle OLTP workloads.

You can move data from Delta Lake to PostgreSQL tables using the reverse ETL capabilities. This facilitates syncing data from your lakehouse directly into your managed PostgreSQL database for OLTP access.

The compute size limit for PostgreSQL autoscaling on Databricks ranges from 0.5 to 112 compute units. This allows dynamic resource adjustment to handle varying OLTP load requirements.

You can generate credentials for secure database connections using the project management features. This facilitates secure access to your managed PostgreSQL service on Databricks.