AWS Lake Formation: Part 10 Troubleshooting and Optimization
In the final part of the AWS Lake Formation series, I address common issues and their resolutions and performance optimization tips for large-scale data...

Todd Bernson
2024-09-28

In the final part of the AWS Lake Formation series, I address common issues and their resolutions and performance optimization tips for large-scale data operations.

This guidance will help you maintain and enhance the performance and reliability of your AWS infrastructure.
Clone the project repo here.
Common Issues and Their Resolutions
Managing AWS infrastructure can present challenges. Here are some common issues and their solutions:
Terraform State Locking Issues:
Issue: The Terraform state is locked by another process. Resolution: Use the terraform force-unlock command to unlock the state file manually.
Resource Dependency Errors:
Issue: The Terraform application fails due to resource dependency issues.
Resolution: Ensure that resource dependencies are explicitly defined using the depends_on attribute.
module "s3_bucket" {
source = "terraform-aws-modules/s3-bucket/aws"
...
depends_on = [random_string.this]
}
Timeouts During Resource Creation:
Issue: Resource creation times out.
- Resolution: Increase the
timeoutsconfiguration for resources that require more time to create.
module "s3_bucket" {
source = "terraform-aws-modules/s3-bucket/aws"
...
timeouts {
create = "60m"
}
}
Performance Optimization Tips for Large-Scale Data Operations
Optimizing the performance of your AWS infrastructure is crucial for large-scale data operations. Here are some tips to enhance performance:
Optimize S3 Data Access Patterns:
Use S3 Select to retrieve only the required data from S3 objects, reducing the amount of data scanned and improving performance.
Example S3 Select Query:
SELECT s.name, s.age FROM S3Object s WHERE s.age > 30
This series has provided a comprehensive overview of AWS Lake Formation and related AWS services, from basic concepts to advanced configurations. You can build a robust, secure, and scalable data infrastructure by applying the techniques and best practices discussed. Whether it's modularizing your Terraform code, ensuring compliance, or optimizing performance, these insights will help you manage your AWS resources more effectively.
Visit my website here.
Read More
View all posts
AI/ML
Why Enterprise AI Must Be Application-Led, Not Agent-Led
A deep dive by Todd Bernson, CTO and Chief AI Officer, on why enterprise AI systems should be architected as application-led, deterministic platforms with embedded agentic AI—not fully autonomous agents. This article explains how API-first, governed, multi-channel architectures deliver higher reliability, compliance, scalability, and business value in real-world Fortune-500 environments.

Todd Bernson
2025-12-02

AI/ML
Application-First Agentic AI
Application-first agentic AI is emerging as the only reliable path to real enterprise ROI. In this in-depth analysis, Todd Bernson, CTO & CAIO, breaks down why most generative AI initiatives stall in production—and how disciplined enterprise architecture, deterministic workflows, and narrowly scoped AI agents can finally unlock repeatable business value. Using a real sprint-intelligence system as a case study, the article shows how organizations can combine serverless engineering, structured orchestration, and constrained LLM reasoning to reduce reporting effort, increase trust, eliminate hallucinations, and deliver actionable insights across engineering, operations, compliance, and customer experience.

Todd Bernson
2025-11-28
AI/ML
Why 95% of AI Projects Fail and How to Be Among the 5% That Succeed

Lee Hylton
2025-08-22