Datameer Blog

Tag: Dbt

dbt

A Review of Dbt (Data Build Tool) and the Top Missing Features

A Review of Dbt and the Top Missing Features Dbt has become a market darling for data transformation tools – the T in your ELT data stack and processes.  The simplistic app...

  • John Morrell
  • September 21, 2021

How to connect DBT to multiple databases in the same project

Let’s look at how you can connect DBT to multiple databases in the same project. While this isn’t a native function to DBT, there are some workarounds to help m...

  • How-Tos FAQs
  • July 15, 2021
snowflake faq

Materialized View vs Table with Dbt in Snowflake

Materialized View vs Table with Dbt in Snowflake Deciding to create a view or a table in Dbt is a common design decision when transforming data for use in analytics and BI ...

  • How-Tos FAQs
  • March 29, 2021
snowflake faq

How to connect to Snowflake using SSO authentication from DBT

Let’s explore how to connect to Snowflake using SSO authentication from Dbt. This article refers to connecting to Snowflake through the Dbt command line, not DBT Clou...

  • How-Tos FAQs
  • March 29, 2021
snowflake faq

How to parse a variable in Snowflake as a source reference in dbt

There are a number of reasons why you might want to have a dynamic source in dbt. Variables are one way to achieve this. But, there are issues with using dynamic sources in...

  • How-Tos FAQs
  • March 29, 2021
snowflake faq

Dbt to Snowflake Connection Failure via Profiles.yml

Let’s explore the Dbt to Snowflake connection failure via Profiles.yml. When getting started developing with dbt CLI, you will need to configure a profiles.yml file t...

  • How-Tos FAQs
  • March 16, 2021
snowflake faq

Querying with dbt from an external source in Snowflake

Native Tables vs External Tables in Snowflake Let’s explore querying with dbt from an external source in Snowflake. It is very common to have data stored in public cl...

  • How-Tos FAQs
  • March 16, 2021