Sync Schema Between Application and Data Lake
Question
How can I keep a single canonical schema or model and apply it to multiple database drivers (for example, an application Postgres database and a data-lake store) so the two remain in sync?
Skipping Constraint Renames in Schema Migrations
How do I instruct Atlas to not generate RENAME commands for table constraints in schema migrations when running commands
such as migrate diff, schema apply, schema plan, etc.?
Running SQL Server Init Scripts in GitHub Actions
Question
How can I run init scripts on SQL Server when using GitHub Actions services instead of the Atlas docker blocks?
How can I keep sensitive values out of Terraform state?
Terraform can write resource arguments into state and saved plans. HashiCorp's
Terraform state documentation warns that
state files can expose stored secrets. The sensitive flag redacts CLI and UI output, but Terraform can
still record the value in state.
With the atlas_schema resource, Terraform can pass connection metadata while Atlas resolves the
credential when it evaluates atlas.hcl.
Handling Special Characters in Database Passwords
How to use a database URL that contains a password with special characters such as @ or #?