Cloudflare R2
DLH.io documentation for Cloudflare R2
Cloudflare R2 or R2 is a service offered by Cloudflare, a well known web enablement company that has extended its offerings with object storage through a web service interface. Cloudflare R2 uses the same scalable storage infrastructure that it uses to run its infrastructure provided already to tens of thousands of customers. Cloudflare R2 can store any type of object, which allows uses like storage for Internet applications, backups, disaster recovery, data archives, data lakes for analytics, and hybrid cloud storage.
Our Cloudflare R2 Storage DLH.io integration:
- replicates files stored in your R2 buckets to your Cloud Data Warehouse target
- synchronizes to your target destination at a scheduled frequency
It allows you to replicate/synchronize your data, including capturing snapshots of data at any point int time, and keep it up-to-date with little to no configuration efforts. You don't even need to prepare the target schema — DLH.io will automatically handle all the heavy lifting for you.
All you need is to specify the connection to your R2 bucket, point to your target system, or use a DLH.io managed Data Warehouse and DLH.io does the rest. Our support team can even help you set it up for you during a short technical on-boarding session.
Setup Instructions
Follow the setup steps guide for configuring your Cloudflare R2 connection to enable data to flow into your destination via DLH.
Supported Features
Here are key features supported for this connector.
| Sync Feature | Supported | Details |
|---|---|---|
| Custom Data and Development | ✓ | Ability to enhance connector upon request |
| Historical Re-Load/Load | ✓ | |
| Incremental/Delta Load | ✓ | Gets most recent records and changes |
| Column Selection | ✓ | |
| Column Hashing | ✓ | |
| Re-Sync Table/Entity | ✓ | Select at the table level to reload data history (on next Sync Bridge run) |
| Custom Queries | Utilizing SQL Data Query Connector | |
| Custom Data | ||
| Captures Deleted Rows | ✓ | On all supported tables |
| API Sync Bridge Initiation | ✓ | |
| Priority Scheduling | ✓ | |
| Private VPC/Link | ☂ | |
| DLH Data Model Available | - |
If you have any questions about these supported features please reach out to our Customer Support team.
Details on Sync Processing
For this connector, we believe the sync processing is straightforward. We've provided a number of details, steps, and other guidance here and in the setup steps guide. Be sure to also check the change log and notes page from time to time for any changes.
Control Each Column Data Type
SQL Transformations allow logic to be executed against a target connection based on a scheduled frequency or triggered event of new data on tables updated via DLH.io (DLH.io). This especially helps when you want to control the data type set in your Target Connection since all columns are set as VARCHAR(16777216).
Issue Handling
If any issues occur with the authorization simply return to the sources page in DLH.io, edit the source details and click the 'Save & Test' button to confirm connectivity. If any issues persist please contact our support team via the DLH.io Support Portal.