SQL Scripting in Snowflake
From its inception, Snowflake has always supported the ANSI standard version of the SQL language. As much as we may enjoy using SQL to manipulate data – how cool is it to write in a language based on something called lambda calculus? Still, it doesn’t quite work when it comes time to write some procedural commands, […]
DataWomen Event Recap: IEEE Mixer
On Friday 24 October, we were invited to an IEEE NSW Education Chapter and DataWomen university mixer where we had the privilege to talk to information technology students of all levels about all the different roles they can pursue in the IT field. We paired that with examples of the roles we have here at […]
Lost in Translation: The Importance of Developer/User Communication
I know the endoplasmic reticulum is a thing. I know the Inuit people have 50 words for snow. I couldn’t tell you what the endoplasmic reticulum does, nor do I know a single Inuit word for snow. But, to a biologist or someone from Nunavut or Quebec, these might be considered common knowledge. Just like […]
What a Designer Actually Does
What does it mean to be a (graphic) designer? You could ask a variety of people and get a whole slew of different answers to this. Heck, Debbie Millman even wrote a whole book that’s chalk full of great insights from a variety of well-established designers about this very subject. But, the everyday person doesn’t […]
InterWorks Blog Roundup — October 2022
Well, spooky season may have come and gone like a ghost in the night, but that doesn’t mean we didn’t have fun while it was here. Parties, trick or treating and (probably) too much candy marked our scariest time of year, and I think we’re all about ready to prepare for a season of thanks […]
Oklahoma State University Launches Spears Assist Powered by InterWorks
We’ve been sharing it to social media for a while now, but we thought it was high time we shared something on the blog to bolster a very exciting announcement that took place at the start of the 2022 fall semester: InterWorks is officially partnering with Oklahoma State University to launch a new analytics help […]
PYD118 – Catching Up with Journalist Alberto Cairo
In this episode of Podcast Your Data, analytics consultants Emily Miley and Jack Hulbert catch up with podcaster, professor, author and journalist Alberto Cairo for the third time on the PYD Podcast to discuss the intersection between data and journalism, Cairo’s new book and data humanism, among other topics.
Using Failover Groups to Migrate or Failover Between Snowflake Accounts
The purpose of this post is to step through the processes involved in setting up a new Snowflake account to replicate an existing one. There are several reasons to do this, the main two being: Fully migrating to a new account, for example if you want your main account to be in a different region […]
Exploring the SQL Pipeline Features in Dataiku
In the modern analytics stack, data is constantly on the move. While all data originates somewhere, it typically must go somewhere else before it becomes valuable for the data analysts/engineers/scientists. However, when working with pipelines that deal with large amounts of data, it is important to construct them to work as efficiently as possible. A […]
The InterWorks Italian Takeover
The EMEA InterWorks team recently finished a long awaited, and most welcome, meet-up of InterWorkers from all across Europe! Planning for this trip with Andrea Thum and Sam Riley started back in July 2022, and as an events planner, it’s always more stressful planning and executing an internal event than it is one that is […]