Context filters in Tableau are very useful, and if you are not using them yet, you probably need to go back and test your dashboards again :) In this tutorial, we are going to go over how context filters work through a step-by-step guided exercise. …

In this beginner level Tableau tutorial, we will be learning how to allow the end user to have control over where to position a reference line on a visualization. Tableau parameters are dynamic values that can be changed by the user. Tableau parameters are incredibly powerful and have a variety…

Time Travel is an interesting and powerful feature of Snowflake that makes it possible to access data at a specific point in the past. This feature comes in very handy in case there are accidental updates on data that you would want to revert. Similarly, if you accidentally drop an…

Access management refers to the policies used to ensure the right users (human or machine) can access the right objects. They also help define the operations can be done on those objects, and define who can control access policies. Snowflake access control can be either Role Based Access Control (RBAC)…

In this article, we will be going through various data loading methods into Snowflake. We will be covering loading batch data (or bulk load) from cloud storage or local storage, accessing data directly on cloud storage, and loading streaming data via Snowpipe. Loading batch data Batch data usually consists of bulk rows that…

So you have successfully run your dbt project. Congrats! Running dbt is just the beginning. In order to ensure a durable and successful setup, and in order to make it possible for multiple team members to contribute to a dbt project, you are bound to adopting some best practice rules…

One of the most helpful features of dbt Cloud is that it allows you to integrate your project with your GitHub account. You can configure dbt Cloud to run a set of jobs anytime a “Pull Request” is created. …

In this step-by-step tutorial, we are going to be setting up dbt (data build tool), connect it to Snowflake, and create our first dbt model. Step 1 — Create a new GitHub repository and clone it locally. Go to your GitHub.com account and create a new repository by clicking on the “+” sign on the top right corner. Specify a name for…

The dbt (data build tool) and SQL community owe a big thanks to tail.com’s head of data, Sir Alan Cruikshank. SQL, the dinosaur of a language that has been there since the 1970’s has up until very recently been still out there in the wild, with no linter that is…