Wasabi
Wasabi has been changing the cloud storage landscape with Hot Cloud Storage, a disruptively simple, one size fits all cloud storage technology that is 1/5th the price and faster than the competition with no egress fees, API call charges, or additional hidden fees. Wasabi is game changing, leading-edge cloud technology that allows users to affordably store a nearly infinite amount of data.ย Wasabi is an entirely new approach to cloud storageโฆ a bottomless cloud that grows with your business. DataLakeHouse supports your integration from Wasabi.
Our Wasabi DataLakeHouse integration:
- replicates Wasabi data to your Cloud Data Warehouse target
- synchronizes to your target destination at a scheduled frequency
- provides a single platform to analyze your data and integrate with other data so that you can combine all into a single source of truth repository for true analytics that will empower your business
It allows you to replicate/synchronize your Wasabi data files, 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 โ DataLakeHouse.io will automatically handle all the heavy lifting for you.
All you need is to specify the connection to your Wasabi, point to your target system, or use a DataLakeHouse.io managed Data Warehouse and DataLakeHouse.io does the rest. Our support team can even help you set it up for you during a short technical on-boarding session.
DataLakeHouse.io securely connects to your Wasabi storage. Using the form in the DataLakeHouse.io portal please complete the following basic steps.
- Enter a Name or Alias for this connection, in the 'Name/Alias' field, that is unique from other connectors
- Enter a 'Target Schema Prefix', which will be the prefix for the schema at the target you will sync to
- Enter a 'Bucket' name, where your files are stored
- Typically starts with s3:// or https://, so enter just the name without the prefix.
- Select your 'Region'
- Enter your 'Access Key', credentials to access the bucket
- Enter your 'Secret Key', credentials to access the bucket
- Enter any other optional details in the available fields (See the setup video if you need help or contact support)
- Folder Path, is a path on the root bucket from where desired files will be retrieved
- File Pattern, is a regular expression (RegEx) used to isolated only certain files to be retrieved
- File Type, allows for a pre-determined type of file extension to be retreived
- Click the Save & Test button. Once your credentials are accepted you should be able to see a successful connection.
๏ปฟ
If any issues occur with the authorization simply return to the sources page in DataLakeHouse.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 DataLakeHouse Support Portal.
๏ปฟ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 DataLakeHouse.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).
