InterWorks Blog Roundup — December 2022
Happy New Year, everyone! We hope you all had a fantastic holiday season and are coming into the new year refreshed and ready for a fantastic 12 months. To cap off 2022, we opted for quality over quantity on the blog front. (It also helps that most of us spent the latter half of December […]
Webinar-Wiederholung – Tableau Formatierungen
In diesem Webinar tauchen wir tiefer in die Formatierung in Tableau Desktop ein und lernen die unterschiedlichen Formatierungsebenen kennen: – Was kann alles formatiert werden, was nicht? – Formatierungshierarchien – warum ändert sich mein Text nicht immer, wenn ich ihn formatiere? – Globale Formatierungen (Worksheets, Dashboards) und Tipps und Tricks für Zahlen, Symbole, Tooltips und […]
Quick Start Guide: Snowflake Direct Shares
Snowflake Secure Data Sharing enables users to provide specific data points to consumers using the same cloud provider within the same region. Providers can share tables, external tables, secure views, secure materialized views or secure user defined functions with consumers. Data sharing is customizable, and in this post I will do my best to cover […]
InterWorks Causes: Food Insecurity in Oklahoma
Giving back is a major component of the InterWorks philosophy. Being deliberate and encouraging employees to spend time in the community to help organizations and causes they are passionate about is equally important as growing our business. Above: InterWorkers volunteer at the Regional Food Bank of Oklahoma. Throughout 2022, many employees from our Oklahoma offices […]
9 Tableau Desktop Time Savers
For those who live by the Benjamin Franklin-inspired mantra “every second saved is a second earned” (or maybe that was actually about pennies?), this Tableau time saver post is for you. It’s incredibly refreshing to know that regardless of whether you have been using Tableau Desktop for seven years or seven months, you can always […]
Snowflake with Python: Determine Next Event from CRON with a Python UDF
Snowflake itself is really strong at reporting task schedules and history. If you ever use the TASK_HISTORY table function, you can even view the NEXT_SCHEDULED_TIME for each scheduled task. However, it is common to be in a situation where you are leveraging another tool for your pipeline orchestration, such as Matillion, and may have set up a monitoring […]
Using a Python Stored Procedure to Execute Snowflake Metadata Commands into Tables (SHOW/LIST/DESCRIBE)
In another post earlier this year, we discussed how to store the results of a Snowflake SHOW/LIST/DESCRIBE metadata command in a table. Refresher To refresh our memory, in Snowflake, there are several commands that can be used to retrieve metadata from the Snowflake environment without using a virtual warehouse. The following commands are all examples […]
InterWorks Blog Roundup — November 2022
We’ve made it to the tail end of 2022. Holiday season is upon us, and it’s fitting that Snowflake is the most blogged about topic for us to share in this edition of the InterWorks Blog Roundup — we randomly had a night of golfball-sized snow clumps roll in out of nowhere at the beginning […]
Using Mapbox to Make Better Maps in Tableau
I recently read this great post by Sarah Battersby about using QGIS to isolate a specific geography on a map in Tableau. Isolating geography is a great way to draw your user’s attention to the focus area, reduce dashboard clutter and give your map a nice, clean feel. For example, if you were building a […]
How to Use the Fivetran + dbt Ad Reporting Package
There is a simple and effective way to ingest and transform ad reporting data from multiple platforms by using Fivetran and dbt in tandem. Fivetran is used to ingest the data from a variety of platforms including Apple Search, Facebook, Google, LinkedIn, Microsoft, Pinterest, Snapchat, TikTok and Twitter. Then a dbt model created by the […]
