Welcome to our journey into the world of AWS automation! In this blog post, we'll be exploring how to automate the start and stop times of Amazon EC2 instances using a combination of AWS services: Lambda, EventBridge and Simple Notification Service (SNS). Managing EC2 instances...
Assist by InterWorks has been helping hundreds of InterWorks clients for years now. Assist got its beginnings as an on-demand, Tableau assistance offering connecting users directly with our consultants. Tableau users could easily hop on a call, wherever they are in the world, and chat...
Securely Loading Data into Snowflake In a previous article, I wrote about how to configure AWS PrivateLink to work with Snowflake so that your employees can access your favourite data warehouse in a secure manner. In this article, we’ll go one step further: loading data. But let’s...
Last month, Matillion launched the Data Productivity Cloud (DPC). In our introductory blog post, we highlighted how this new SaaS product simplifies managing multiple data sources and performing transformations — all from a single pipeline and right within your web browser. This was made possible...
Snowflake, a leading cloud-based data warehousing platform, has become instrumental in modern data analytics and processing. However, when you connect to Snowflake, your data traverses the public internet before reaching its destination. This can raise significant security and performance concerns, particularly in sensitive industries like...
Launching Your Serverless Expedition If you are utilising or planning to migrate to Tableau Cloud and have your data or corporate infrastructure hosted on AWS and are seeking to deploy a containerised cluster of Tableau Bridge clients on a CentOS distribution, then you’re reading the right...
In the dynamic realm of data analytics, making the right platform choice can significantly impact your business outcomes. With two powerful options on the table, namely Tableau Server and Tableau Cloud (formerly Tableau Online), the decision might seem daunting. Fear not, as we're here to...
Welcome, everyone, to the recap of our August blogs. You may look at your calendars and say, "Mark, my friend, it's September 12. We're almost halfway through September. Why is this recap so late?" That, my dear reader, is an astute question. It actually has...
As modern applications expand in complexity, effectively managing workflows can become a significant challenge. AWS Step Functions provides a comprehensive solution for orchestrating multi-step workflows in the cloud. Whether it's invoking Lambda functions in Task states, separating branches of execution with Parallel states or running...
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...
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