ariga/atlas v1.1.0

on GitHub

We're excited to announce Atlas v1.1.

This release delivers on a promise we made in v1.0: Database Security as Code is now available for Atlas Pro users.

We're also shipping declarative data management for lookup tables and seed data, expanding database coverage with Aurora DSQL, Azure Fabric, and CockroachDB Cloud, and further improving our drivers and Atlas Cloud.

Here is what you can find in this release:

• Database Security as Code - Manage roles, users, and permissions declaratively across various popular Atlas-supported databases
• Declarative Data Management - Define lookup tables and seed data as code using various sync modes
• Aurora DSQL Support - Manage schemas on AWS's new serverless distributed SQL database
• Azure Fabric Support - Use Atlas to manage your Microsoft Azure Fabric databases
• Spanner Enhancements - Added support for Spanner's PostgreSQL dialect and vector indexes
• ClickHouse Improvements - Cluster mode and data retention on table recreation
• CockroachDB Support - Full Atlas support for CockroachDB Cloud and self-hosted deployments
• PostgreSQL Enhancements - CAST definitions and replica identity support
• Slack Integration - Connect to our native Slack app for real-time notifications
• Schema Exporters - Declarative export for schema inspection, drift and diff reporting, and more

Read the full announcement in our blogpost.

role "app_readonly" {
  comment = "Read-only access for application"
}

permission {
  for_each   = [table.users, table.orders, table.products]
  for        = each.value
  to         = role.app_readonly
  privileges = [SELECT]
}

role "app_admin" {
  superuser   = false
  create_db   = false
  create_role = false
  login       = true
  member_of   = [role.app_readonly]
}

permission {
  for        = schema.public
  to         = role.app_admin
  privileges = [ALL]
  grantable  = true
}

Quick installation

macOS + Linux:

curl -sSf https://atlasgo.sh | sh

Homebrew:

brew install ariga/tap/atlas

Docker:

docker pull arigaio/atlas

Windows

Download

Legal

The default binaries in this release are distributed released under Atlas EULA, and the community binaries are released under the Apache 2.0 license.