Let's cut the chase and make a series of mini posts 😊 to cover how to's? As of the time of writing this mini blog, we cannot use VENETS to bring data from snowflake. Option 1: use a On premise gateway that is running in same network as the snowflake....
When loading data into Power BI, it is often necessary to convert date columns to datetime columns. This is because Power BI uses datetime columns for its internal data storage for incremental load. There are a number of ways to convert date columns to datetime columns in M code. One...
In data warehousing, two main approaches to data modeling are Tabular and Multidimensional Cube. Each method has its own strengths and weaknesses, and the decision on which to use depends on the needs of the business. Tabular models are built on the relational database model and use the DAX (Data...
A Guide to Selecting between Snowflake and Star Schemas for Dimensional Modeling in Data Warehousing
In dimensional modeling, there are two main schema designs: Snowflake and Star. Each has its unique advantages and use cases, and the decision to use one over the other depends on the data and the requirements of the business. Snowflake schema is a normalized design that separates data into multiple...
Moving data from Databricks to Snowflake can be a bit tricky, but with the right tools and approach, it can be done relatively easily. In this blog post, we'll take a look at how to move data from Databricks to Snowflake, including a step-by-step guide and some best practices to...
PySpark is the Python library for Spark programming. It allows developers to interface with the powerful Apache Spark engine through Python, a popular language for data science and machine learning. PySpark enables data scientists to perform complex data manipulation and analysis tasks with minimal code and maximum efficiency. One of...