SNOWLDR

SNOWLDR is a software as a service (SaaS) application that makes loading your files into Snowflake fast, easy and cost effective. Reliability and security are built in because it runs on the Amazon Web Services (AWS) and Snowflake platforms. These platforms offer infinite scalability so there is no workload that SNOWLDR cannot handle.

Setting up a custom file loading process typically involves weeks, if not months of development time and comes with a high price tag. With SNOWLDR, almost all of these costs can be eliminated by simply signing up for a monthly plan that can be cancelled anytime. These plans cover a wide range of data volume levels so organizations can choose the best plan to fit their needs. Setup is as quick as one business day and clients can start loading files right away.

To load files simply upload them to the cloud storage using any tool like Cloudberry. Uploads can also be done programmatically. There is no need to know or define the file layout, column names, data types, or the delimiter. These can be any mix of different files. SNOWLDR automatically picks up the files and analyses them. Then the files are written to individual Snowflake tables. These tables are shared to the client using Snowflake secure direct data share. The client gets access to the tables from their own Snowflake account minutes after uploading. The tables can be consumed immediately by users or loaded to downstream warehouses, marts or other applications. All of these happen within minutes (depending on file size) and without any coding or manual activity.

For security, files are deleted from the cloud storage immediately after they are processed. Client data is stored in its own separate schema and never mixed with other client data. The entire process is automated so data is never handled or seen by a human person. Clients can only access their own data in the Snowflake share. They cannot see other client data.

*SNOWLDR currently only supports Snowflake on AWS.