Snowflake and Azure are incredibly capable of storing data securely. You can see all reports available to customers through their pages of security and compliance reports, for both Azure and Snowflake. This is fantastic for data stored in the platform; though, we must still consider how...
On a recent project, I heard a colleague recommend dbt and it sounded amazing. Every feature of this product seemed to address challenges I run into on almost every data project. I decided it was time to take a look. Unravelling the Spaghetti As a consultant, I...
Every Snowflake account comes with a shared database called "SNOWFLAKE" which stores a fantastic amount of account-level and organisation-level information. Most notably, this shared database contains a series of account usage views which covers all of the activity that has taken place in the account. This...
In the world of data analytics, there is always a tendency to focus solely on the tech stack above everything else. We get it – technology is new and shiny and exciting. Tech, however, is only part of the equation, you also need people who...
You've probably heard about Snowflake by now, but if you haven't, it needs to be a part of your analytics practice. This series will lay out all the essentials for getting started with this cloud-based data warehouse. Snowflake is built differently from other data warehouses. Its...
Once you've collected the data, you need a way to store it, right? What good is collecting it if you can't properly store it in a way that's easy to keep and also easy to recall? This week, Garrett is joined by solutions architect Matthew Brimer...
After attending an in-depth technical training in Dallas, Texas, I thought it could be beneficial to give some examples of how Snowflake is unique in a series of blog posts moving forward. This week, I’m talking about JSON (although Snowflake’s functionality displayed in the article...
We’re pleased to announce that InterWorks is officially a Snowflake Solution Partner. After getting to know the Snowflake team as well as the ins and outs of their product, we see the immediate value Snowflake can bring to clients in search of a modern data...
As “big data” becomes increasingly ubiquitous and important to a variety of organizations, many of the existing database systems and platforms have become too cumbersome to set up and maintain: On-site systems can be complex and difficult to scale; and other “big data” solutions require...
Outside of being a powerful data visualization tool, Tableau is known for its ability to connect to just about anything. This includes a multitude of brand-name databases. But there’s a rising database on the block that’s making waves in the industry called EXASOL. What Is EXASOL? EXASOL...
Tim Costello - InterWorks' own analytics consultant and SQL guru - switches sides of the mic and is interviewed about his move from medical responder to agile promoter. Tim and Ben talk about SQL Saturdays, agile data warehousing, getting into a meetup, making yourself better. Subscribe...
In most real world data sets, we want to compare “year over year” values. How were we doing last year? How does that compare to this year? Monitoring these comparisons can provide valuable insights to your business; however, the calculation is cumbersome and slow to generate in...
Keeping track of the growing number and types of database products is a full-time chore. This week I spent a few days in Vail, Colorado at the Pacific Crest Global Technology Forum. This is the 17th year that Pacific Crest Securities has sponsored the event—bringing...
A few years ago, I decided to try to count all of the database products that were available. After spending several hours on a Friday evening trying to count all of them, I gave up at around 2 a.m., having counted 200. I classified them...
A couple years ago, Josh Varner was a consultant working on our BI team at InterWorks. The last time I saw Josh (when he was still on our team) was at the Vertica Conference in Boston. I was leaving early for a gig in New...
In my first InterWorks blog post, I’ve decided to write about something that I commonly used in other BI platforms. The idea of passing parameters in Microsoft and IBM products is vastly used in reporting. A user can define their parameter before running the report....
To be more proactive in prevention of account expirations, create an automated report identifying those nearing expiration. Using the scripts outlined below, a report can be set up to run on startup. This provides awareness with ease. The following were excecuted using the SYS account. Create...
Using descriptive, consistent naming conventions is important and should not go overlooked. Variability and inconsistencies often lead to confusion, error and loss of time. It is not uncommon to come across tables and columns cluttered with abbreviations or shorthand that may be insightful to some,...
(This is a multi-part series about the proper care & feeding of a Vertica cluster. There’s simply too much content for one post, so I’ll be splitting this up into a three-part series. Check back in a few days for the next installment.) Vertica is a...
Scenario Our sales team collects information and forecasts possible sales using a data-table called ‘Opportunities’. If a sales opportunity converts to an actual sales lead, the customer and his information is moved to the ‘Leads’ table. Opportunities that do not convert remain on the original table. Additionally,...
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