Clocking in at 28 blog entries this month, March was easily one of the most jam-packed months we've had on the InterWorks blog. I feel like I've written that exact same intro several times since I took over compiling these monthly roundups, but the number...
If you've ever tried running SQL queries against Snowflake from an AWS Lambda function using Python, chances are you may have run into an error message like this: ⛔️ No module named 'snowflake' Fear not, there's a simple solution you can apply in no time. In this...
There are several ways to develop, debug and deploy serverless applications to Amazon Web Services (AWS). One of my favorite tools to achieve this locally is the AWS Toolkit for VSCode because it streamlines the application development process in a simple and pain-free manner. For...
February may be the shortest month of the year, but it's definitely been one of the busiest here at InterWorks! There's 28 days in the shortest month, but we've got a whopping 25 blog posts here for your review. You'll notice that there's a new...
A common scenario that people encounter is that people need to move one object in a S3 bucket to a different bucket. Recently, I encountered a data vendor that sent data directly to a customers bucket. The customers data pipeline was set up to access...
To stream/ingest data automatically from an AWS S3 bucket into Snowflake using native functionality, Snowpipe is likely the solution you're seeking. We do have two related posts you can explore for related content: Configuring Storage Integrations Between Snowflake and AWS S3 Automated Ingestion from Azure...
To ingest data stored in AWS S3 into Snowflake, you can use either direct COPY INTO statements or a Snowpipe for automation. Both options require a Snowflake object called an external stage to connect Snowflake to AWS. It's recommended to use Storage Integrations for authentication...
Fivetran's custom connector enables customers to create an ingestion process for data sources that are not currently offered by Fivetran's service. This is accomplished by creating a function in Amazon Web Services (AWS), Microsoft Azure or Google Cloud Platform (GCP) using a programming language such...
Today, I will cover how to make these two great platforms, Tableau and Amazon Athena, work together in just a few steps. We will be using the guides provided by AWS and Tableau as reference points to effectively open a connection from Tableau to a...
On this week of Podcast Your Data, we bring you a conversation with four-year InterWorks partner Matthew Scullion, CEO and co-founder of Matillion. Alongside host and Global Data Practice Director at InterWorks, Brian Bickell, Matthew discusses the exciting space of cloud-based technology at the 2021...
Another month, another roundup! In August, we published 14 new pieces of content and featured 20 contributors to the blog, including a couple first-time bloggers! Our team shares all kinds of data tidbits and new knowledge, from a mini-series on the emerging power of dbt...
The year 2020 produced a mass migration of business processes, enterprise software and internal workloads to AWS in a way that was previously unseen. In the world of data, organizations relied on the flexibility of the cloud to run infrastructure, authentication and analytic workloads at...
Visual analytics have emerged as a crucial business activity. Tableau is the best-in-class platform for this and has unlocked the ways businesses can see and understand their data. As a result, organizations are eager to do more and more with the platform. In this quest...
At InterWorks, we have always been a group of tinkerers. Near the end of last year, we had the opportunity to launch the Amazon SageMaker for Tableau integration, a production-ready open-source analytics extension that enables organizations to bring the power of machine learning into their...
If you’re attending our upcoming Transform Tableau with Machine Learning workshop, I’ve outlined the following instructions for you to check out before we get started. The interactive workshop is going to walk you through the process of deploying a SageMaker Model Endpoint trained using SageMaker...
As 2020 was coming to a close at InterWorks, we were approached with a unique problem from an organization we greatly respect. Amazon has been at the forefront of cloud computing for the better part of my career, and in recent years, they have been...
Welcome back to our mini-series on Snowflake External Functions with AWS Lambda. Before we proceed, please read the previous post on how to set up these functions and how Snowflake interacts with AWS Lambda. API Knowledge Disclaimer If you are unfamiliar with APIs and how they work,...
Recently, Snowflake implemented a new feature that allows its standard functionality to be extended through the use of external functions. Among several other capabilities is the ability to create AWS Lambda functions and call them within Snowflake. This has unlocked a whole new realm of...
It's certainly a weird time to be a human on the planet, but here at InterWorks, we're grateful for the opportunities to grow, stretch and challenge ourselves. We've also been making the most of the extra time on some of our hands—we published 28 new...
I had a situation with a client where they had a new AWS account and wanted to create an online storage folder area where a third party could upload JSON files, that could then later be ingested into Snowflake. They had no experience with AWS,...
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