Snowflake is a cloud platform for data storage and analysis, offering a wide range of services for working with data – data warehouse, data lake, data science, and data...
In Dbt (data build tools), files are organized in a logical structure based on files/folder organization and configuration (dbt_project.yml). To navigate the project effectively as the codebase grows, it’s...
Is Dbt compatible with Snowflake? Definitely! And if you combine it with some ETL/orchestration tool like Keboola (cloud) or Mage.ai (on-premises), you’ve got yourself a decent data solution. Nowadays,...
Last time, we did a deeper dive into how Keboola Storage works, how applications process it, and how it stores data during a flow. Today, I’ll show you how...
In previous articles, I showed how easy it is to set up your first data flow in Keboola, and we took a closer look at the fundamental elements of...
In Keboola, components are blocks that make up the Data Flow (pipeline). They are elements in the ETL/ELT process used to connect to data sources (source) or data destinations...
In the previous part titled ETL | Keboola Free – Creating a Project, Basics, we did a basic introduction to the application. We went through the process of creating...
In the previous article, we introduced ourselves briefly – ETL | Keboola – Introduction, Pricing, Products – An Alternative to Fivetran. We know that Keboola offers a Freemium model,...
As part of data democratization and the transformation towards data-driven management, more and more companies are adopting solutions that support and strengthen this culture. Data is made accessible to...
Before, it was a common practice that the management and access to corporate data for internal customers (employees from different departments) were exclusively under control of the IT department....
In this guide, we will take a look at the features that Mage.ai offers for data analysis. While this tool is primarily used for ETL pipelines, it also includes...
In this guide, we will take a look at how to configure the io_config.yaml file in Mage.ai. We will also explore how to hide and encrypt access passwords so...
This article will be related to troubleshooting. Today, I managed somehow to write a comment that caused the entire Mage.ai instance to crash due to a UnicodeDecodeError. How did...
In the previous article – ETL | Mage.ai – Solid Alternative to Airflow – Intro and Installation we introduced the ETL tool Mage.ai as a lighter alternative to Apache...
In a recent article dedicated to introducing Mage.ai – a tool for creating and managing ETL processes, I promised at the end that we would try to create a...
BCP is a utility that is installed by default with SQL Server editions and is used for bulk import or export of a large volume of data in user-defined...
Table and index compression is a functionality that has been available in various SQL Server editions for a while. It has been available in all editions, including SQL Server...
In the past, I have written several tutorials on reporting services (you can find them in the reporting services – SSRS category). I have gone into great detail on...
Data masking is a feature that allows you to completely or partially mask selected data in a database. Access to unmask the data can also be granted or revoked...
Lately, I’ve been dedicating a lot of time to financial mathematics in Excel. I’ll try to leverage that and shift the focus from Excel to SQL Server. Perhaps someone...