Tray Snowflake Connector: SQL Compilation Error – “ninvalid identifier”
Tray.io is an easy-to-use low code API Integration tool that’s great at streamlining your workflows and data in the workplace. I recently tried it out! I wanted to create a basic data flow that pulls Typeform survey data into a Snowflake server for use later in an internal Tableau dashboard. The flow is “triggered” when […]
Tableau Hacks: Horizontal Synchronised Scrolling
Have you ever been in a situation with Tableau where you have developed a couple of great views, you put them in a dashboard, and they won’t fit to width unless you squash everything up? And then you cannot make sense of things anymore and you end up with multiple scrollbars? Do you flip the […]
Unleashing the Power of Tableau Cloud: Elevating Data Security and Administration
Step into the realm of data security and embark on a thrilling journey with Tableau Cloud! Get ready to witness the fusion of innovation and protection as we unveil a series of captivating blogs. Join us as we delve into the cutting-edge features that safeguard your data fortress. Brace yourself for an adventure that explores […]
Converting Geospatial Coordinate Encoding in Snowflake
Recently, I was involved in a project which required using geospatial (basically maps) data for an analytical application. Now, with ESRI shape files being around for more than three decades, any sincere BI application like Tableau can easily read and work with these spatial files. But Snowflake has geospatial data types available, too; and when […]
2023 Tableau Fantasy Football Draft Kit
Football season is almost upon us. While we slog through the purgatory that is preseason matchups, some very real preparations are starting to get underway: drafting the perfect fantasy football lineup. Drafting your favorite players and hoping for the best is, uh, one strategy. Another strategy is using actual data to inform your decisions. While […]
SQL Delight in Snowflake | EXCLUDE, RENAME, REPLACE, ILIKE, GROUP BY ALL
Snowflake is like that friend who’s always got something new up their sleeve! Snowflake is all about staying up-to-date and cool, regularly spicing up its lineup of awesome features to keep up with the changing times in the world of data. So, in this blog post, get ready for a front-row seat to the show […]
PYD123 – Data Science, AI and Dataiku with Rachel Kurtz
InterWorks Content Manager Garrett Sauls sits down with two time Dataiku Neuron and InterWorks Analytics Architect Rachel Kurtz about the AI/ML craze, what’s new with Dataiku and more.
Does Home Field Advantage in the World Series Even Matter?
During the summer between 6th and 7th grade, my best friend Paul and I walked to the Piggly Wiggly across from the street from my house, and we each impulse purchased our first pack of baseball trading cards. I was immediately hooked! Many more packs (and boxes) followed, and I spent the rest of the […]
How To Be a Great Presenter
I’ve been with InterWorks for almost a year now. It’s interesting being surrounded by a team of expert consultants. There is quite an immeasurable collection of shared IT and business intelligence experiences represented throughout our organization. And much of the regular scope of work for most of our employees is client-facing, meaning we have hundreds […]
Understanding Micro-Partitions and Clustering in Snowflake
There are several features in Snowflake that contribute to your environment’s performance and scalability. Two of the most important in my experience have been micro-partitions and clustering. In short, micro-partitions are the fundamental storage units of Snowflake, and clustering is a feature that organizes data within micro-partitions based on one or more columns. The two […]
