dbt (data building tool) enables analytics engineers to transform data in their data warehouses simply by writing SQL select statements. dbt ensures that these...
The traditional data team consisted of data engineers and data analysts. Where data engineers were responsible for supplying the analysts with the data they required. This meant Extracting the...
During our last training sessions , we received the feedback that it would help trainees tremendously if they had a cheat sheet. In view of the "Open...
Programs like Alteryx have opened up the world of ETL to other people besides programmers and have made it possible for people with a lot of domain knowledge to...
In the previous articles, we've started manually loading data into Snowflake and created a script to automatically download the data from the web and upload it to an S3...
Last week, I wrote a blog about downloading data, uploading it to an S3 bucket, and importing it into Snowflake (which you can find here). Now it's time to...
You've seen and heard us talk a lot about Snowflake with a lot of enthusiasm at The Information Lab but once you're ready to get your hands dirty (or...
While working on some data and importing a few files from an s3 bucket, Snowflake encountered an error that took me too long to figure out: Field delimiter ','...
During conversations with potential clients and peers in the field, we increasingly hear terms such as Artificial Intelligence (A.I.), Machine Learning (M.L.) and other buzzwords mixed in...