When talking about the “doing” part of data engineering, folks usually want to say something about ETL like, “How are your ETLs running today?” This is a horrible term and even worse in plural form. The new hotness is to flip the “T” and the...
Have you ever been working on a project and wanted to pull in some data that you didn’t have access to? This has happened to me on far too many occasions. My next step is to figure out where I am going to get that data from then...
Order up! We have another month's worth of hot and fresh data resources ready for you. In this blog roundup, we feature a new Snowflake blog series, a summertime playlist, more webinar recordings than ever and our tried-and-true Tableau tips. With 23 published posts and...
When you think of data science (for the purposes of this blog, this will encompass all machine learning and AI activities), you may think of specific aspects. I would make a wager that most people think specifically about model building. The Data Science Process Data science is...
Snowflake has long been the Cloud Data Warehouse. The organization has completely changed the game with unique architecture purpose-built for the cloud: allowing scalable storage and compute for data warehousing projects, all within a SQL-compliant database. The benefits of Snowflake’s modern architecture were obvious, and over...
What technologies can you pair to enhance the data experience? How can the right blend of tech help you do your job faster and more easily? In this webinar, we hear from Global Database Administrator & BI Analyst at TenCate, Scott Perry, alongside InterWorks’ Dan Murray as...
Five years ago, in the distant past that still included large, boozy, in-person technology conferences, I met two guys from an upstart cloud data warehousing company called Snowflake. Walter Aldana and Uday Keshavdas were those two guys, and while they are both great and were...
This post is the companion to our recent webinar on the modern BI stack. I chose the word “deploying” here intentionally because doing it well means you never finish. You will be “deploying” permanently. It would be convenient for our crew and advantageous for all of...
What we could all use right now is a deep breath. While we can't pause reality or stop the days from progressing, we can spare a moment to be still. As you do, we hope you can find some helpful resources from May's blog roundup....
We're currently in the midst of an exciting series of virtual Master Classes with Snowflake. Some good questions were posed during the first session, Why Snowflake? There were so good, in fact, that we decided to highlight some of them here, so even if you...
If you are a Matillion user, chances are that you have been in the following situation before. You build an entire pipeline and meticulously design each and every aspect to transform your data in the perfect way. At the end of your job, a nice...
One of Snowflake's key selling points is automated clustering. However, it's not immediately clear what this actually means. It's easy to make the assumption that you will never need to think about how your data is clustered, and this is generally the case for tables...
Within your Matillion environment, you already have access to a large array of pre-built connectors (called "profiles" in Matillion parlance). However, if you need to get data from one of your applications that Matillion has yet to bring out a pre-built component for (perhaps it's...
NOTE: The COVID-19 global pandemic continues to evolve. This data visualization is no longer being updated, and we recommend the Johns Hopkins Coronavirus Resource Center for regularly updated data and information. As I write this article, there have been over 560,000 confirmed cases of COVID-19 in the...
The world is a place of unknowns and fear right now. At InterWorks, we've worked extra hard to find ways to creatively connect our team members across the globe. From scheduling "water cooler chats" on Zoom to weekly team check-ins, our community is more important...
One of the fantastic features in Snowflake is the support of zero-copy cloning. This is the capability to duplicate an object while neither creating a physical copy nor adding any additional storage costs. This allows for much greater freedom in the environment as costs are...
Two weeks ago, KeyBanc Capital Markets and the Mosaic network held their 15th Annual Emerging Technology Summit in San Francisco, California. This event connects executives from pre-IPO and public companies in the tech sector with leading private equity and public market investors. The goal is...
The more you use the Snowflake user interface (UI) for query building, the more layers, panels and tricks you discover it has. I’ve come to take the different screens and shortcuts for granted, but whenever I sit with a new client, I run through these...
Earlier in this series we have discussed how to load data into Snowflake using several different methods: Snowflake's user interface, the SnowSQL command line tool and Python. These three methods all perform the same task of loading data into Snowflake; however, they increase in complexity and...
And just like that, another month has gone by. It felt like February came and went in the blink of an eye, but the good news is that we've got loads of resources on the blog that are here to stay. With 25 posts and...
Interworks GmbH
Ratinger Straße 9
40213 Düsseldorf
Germany
Geschäftsführer: Mel Stephenson
Kontaktaufnahme: markus@interworks.eu
Telefon: +49 (0)211 5408 5301
Amtsgericht Düsseldorf HRB 79752
UstldNr: DE 313 353 072