Tags

Data Monitoring: using dbt and SnowFlake’s time-travel to track your KPIs

June 20, 2023

|

by: Andre Deroide

|

Categories: Analytics, Code, dbt, KPIs, Snowflake, Snowflake Computing, Time Travel

Data Monitoring: using dbt and SnowFlake’s time-travel to track your KPIs

Analysts, Data Engineers and all data crew are always eager to offer the best set of analytical tools, qualified data, a good performance and agility when delivering data products to the user areas. And when it comes to KPI’s, the interest is a bit higher, because if you’re not tracking your indicators correctly, you may […]

Package Delivered: Accelerate Your DBT Project Initialization

January 12, 2021

|

by: Greg.suk

|

Categories: Code, Coding, dbt

Package Delivered: Accelerate Your DBT Project Initialization
Anyone who has worked with dbt knows that one of the most powerful features is packages. Packages allow you to reuse code across multiple projects in an organization. Packages can be installed from other projects in your organization, or by using the dbt hub you can install packages from the open-source community and Fishtown Analytics. [...]

Bored in Quarantine? Our Events are now Free Webinars!

March 26, 2020

|

by: Renee Miller

|

Categories: dbt, Events, Oracle, Red Pill Analytics' Tips, Red Pill News, Tips

Bored in Quarantine? Our Events are now Free Webinars!
COVID-19 has created an anxiety-ridden week. With the chaos of preparing to quarantine over (hopefully), what’s next? If you’re looking for a way to be productive at home, we have an answer - we’ve taken our canceled and postponed live events and converted them to online educational opportunities. With a worldwide pandemic at our heels, [...]

How DBT was used to convert from Google BigQuery Scheduled Queries

March 4, 2020

|

by: angie.brown

|

Categories: Code, Coding, dbt, Modernize Not Migrate

How DBT was used to convert from Google BigQuery Scheduled Queries
Google BigQuery has neat functionality that allows users to schedule queries in standard SQL, DDL or DML statements. Additionally, you can set them to run on a recurring basis. This can be great for light transformations; however, if more comprehensive transformation and automated regression testing is needed dbt (data build tool) is an affordable solution. [...]