While our reporting data has been designed for automated transfer between computer systems (like Snowflake), it is perfectly possible to work with this data locally.

<aside> <img src="/icons/warning_red.svg" alt="/icons/warning_red.svg" width="40px" />

We recommend that users primarily work with this data in Snowflake (as this is covered by data processing agreements). If you need to work with the data locally, please ensure that you understand the implications under the GDPR and other relevant data protection acts. Beat Technology is not responsible for how you process your data.

</aside>

Downloading files

To configure an app to connect to the S3 bucket, you need to have the following things before you start:

You can get this from Beat Technology directly.

Free alternative: Cyberduck

Cyberduck | Libre server and cloud storage browser for Mac and Windows with support for FTP, SFTP, WebDAV, Amazon S3, OpenStack Swift, Backblaze B2, Microsoft Azure & OneDrive, Google Drive and Dropbox

This software works by allowing you to connect to an S3-compatible bucket (in our case this is Backblaze), and is free for Mac and Windows. You will have to connect, manually download the file you want, and then work with it locally.

Paid alternative: Mountain Duck

This software, made by the same developer as Cyberduck, allows you to mount the remote bucket as a drive on your computer. You can then simply copy the files you want directly from the folder, without opening the Mountain Duck app.

It costs USD 47 per user.

Decompressing files

We use a compression algorithm know as Zstandard, which is very efficient but has not yet found great adoption among desktop users. There are currently no alternatives for users who prefer a graphical user interface to do this.

Command line

To decompress it from the command line, you can use the following options:

<aside> <img src="/icons/apple_blue.svg" alt="/icons/apple_blue.svg" width="40px" />

macOS

$ brew install zstd # only required to install
$ zstd -d somefile.csv.zst
# alternatively
$ unzstd somefile.csv.zst

This decompresses the file to somefile.csv within the same folder.

</aside>

<aside> <img src="/icons/window_yellow.svg" alt="/icons/window_yellow.svg" width="40px" />

Windows

Download the latest release of Zstandard from their releases page:

https://github.com/facebook/zstd/releases

You want the file that ends in -win64.zip , as of this writing it is zstd-v1.5.7-win64.zip.

Once you have the file, running it works the same way as on macOS:

C:\\> zstd -d somefile.csv.zst

</aside>