Automatic data type resolution ensures your data is correctly mapped to the optimal Redshift type.
Create projects and invite colleagues to collaborate. Lodr is built for data driven teams!
All the essential transformations in an easy to use UI. Split, extract, find and replace, and more!
The SQL IDE designed for Amazon Redshift. Inspect table schema and execute queries against your cluster.
Automatic DDL generation with UI to configure Sort Keys and Distribution Keys.
Incrementally update data using the Lodr merge option. You can repeatedly load a file and update matching records.
Optionally choose to receive email notifications when your data loads are successfully completed. You can disable notifications.
You can upload files from your desktop or connect to an existing S3 bucket.
Sync your entire bucket into Redshift. Schedule Lodr to autoload newly added files.
Use our comprehensive time based scheduler to trigger loads. i.e. Monthly on the first and last Monday at 1 AM EST
Have a Zip full of files? No problem! Upload zip, bzip, gz, txt, csv and more!
Load large files concurrently into your Redshift cluster and monitor throughput and performance in the Lodr dashboard.
Our serverless backend enables high throughput file transformations and data loading. Every field is analyzed at break neck speeds.
Use Lodr's visual JSON extractor to make the unwieldiest JSON file yield insightful data. Learn More
Lodr can handle everything from Zipped files to Log files. Lodr can even be configured to automatically select the latest file matching a prefix.
Create a Loader with our intuitive step by step wizzard. Lodr will automatically determine the best target data types and automatically create a target table for you. Many more options to configure how you load data.
You can schedule the Loader to run on a regular basis or run it immediately. Use our new SQL IDE to explore your data. You just saved yourself hours of boring work!