In this article, we will delve into the concept of views in Snowflake, exploring their types and how they are employed within the platform. What is a View? A view in Snowflake is essentially a saved SQL query that is given a name and stored in your database. Think of it as a virtual table […]
Understanding Views in Snowflake: Types and Use Cases Read More »
When it comes to managing timestamps in Snowflake, understanding time zones is crucial. Snowflake stores time zone information by adding the offset at the end of each timestamp, providing a clear indication of the time zone associated with the data. By default, Snowflake uses the host server’s time zone, which is typically set to Pacific
How to Convert Time Zones in Snowflake Read More »
In Apache Airflow, an executor is a component responsible for executing tasks within a workflow. When you define a workflow in Airflow, you specify a set of tasks and the dependencies between them. Executors are responsible for executing these tasks according to their specified dependencies. Local and Remote Executors Apache Airflow has two types of executors: local and remote. Local Executors Local executors run tasks on
Apache Airflow Executors 101 Read More »
Apache Airflow is a “data orchestration” platform that data engineers use to schedule and coordinate steps in a data pipeline or data workflows. It’s one of the most popular open-source orchestration platform. Airflow helps define workflows in python code and provides a rich UI to manage and monitor these workflows. Airflow supports easy integration with a
What is Apache Airflow? An Overview Read More »