Snowflake

Snowflake – Sequences

As we move our platform onto Snowflake I’ve been testing various aspects out on Snowflake. Usually when creating new tables we can set the column to have a primary key at creation for example if you were working on SQL Server you can use the following:

CREATE TABLE TABLE_A (
  ID_column INT NOT NULL IDENTITY(1,1) PRIMARY KEY,
  ...
);

The code above would create TABLE_A with an auto incrementing primary key starting at 1 and going up by 1 for each row that is added.

Continue reading

Advertisements
tableau

Tableau Viz – LFC vs. KO Time

Luckily at Atheon Analytics we have a personal development day every sprint (2 week sprints) where we can go out and develop our skills and learn new things that can improve us both personally and professionally.¬†Working for a company that converts numbers into amazing dashboards that help customers analyse their data visually, I’ve been intrigued to learn Tableau.

I’ve created this basic viz to analyse how Liverpool FC perform depending on when they kick off.

Continue reading

ubuntu

Installing Ubuntu 18.04 to Windows 10 Machine (Dual Boot)

Installing Ubuntu on a Windows machine was a headache in the past by having to create a new partition and working out how to create a bootable USB to install the setup files for the operating system. I was reading about how to install the latest version of Ubuntu and felt overwhelmed by the task in hand, due to the issues I had in the past.

Thankfully, times have changed now and I’ve documented the process below to how I created a dual boot for my Windows 10 machine with Ubuntu 18.04.

Continue reading

Snowflake

Snowflake – The Data Warehouse Built for the Cloud

I’ve not been blogging much over the past few months and weeks as I’ve been working on a new technology called Snowflake. As the title says “Snowflake – The Data Warehouse Built for the Cloud” is a data warehouse that sits on Amazon S3.

All you need to access your data warehouse is a live connection to the internet. “Snowflake eliminates the administration and management demands of traditional data warehouses and big data platforms. ” I’ve had instances where I’ve had to manually

Continue reading

exasol, python

How to: Create an EXABucketFS service and bucket

We recently upgraded our Exasol version from 5.0.17 to 6.0.3 and we noticed that our existing Python modules were gone and jobs that we’ve automated were failing. After reading through the updated documentation we figured out Exasol has introduced a cool new feature called EXABucketFS.

After reading through various community questions and YouTube videos I was able to get the hang of uploading modules and linking them up with Exasol.

Here’s a quick guide on how to create an EXABucketFS service and bucket.

Continue reading