Skip to content

shannonlowder.com

Menu
  • About
  • Biml Interrogator Demo
  • Latest Posts
Menu

SQL Server to Databricks Profiler

Posted on January 26, 2023January 19, 2023 by slowder

Recently I had a client that expressed interest in migrating their data warehouse from Azure SQL DB to Databricks. They weren’t looking to move due to any performance issues in Azure SQL DB. They were running on the Hyperscale offering. They were looking to share a common data architecture between their data warehouse and data…

Continue reading

Delta Sharing – Data Recipients

Posted on January 24, 2023January 13, 2023 by slowder

Recently I was asked to look into Delta Sharing to learn what it’s all about and how it could be used. fter digging in a little bit, It appears that it’s a way to share data in parquet or Delta format. ou can build these shares on top of any modern cloud storage system like…

Continue reading

Metadata-Driven Python

Posted on January 19, 2023January 19, 2023 by slowder

You will manually build your ingestion code when you first learn to ingest data into any new engine.  This makes sense; you’re just getting started.  You want to learn how the engine will read the data and then write it back again. You want to learn how to log what’s happening during ingestion. You want…

Continue reading

Monolithic vs. Unit-of-Work

Posted on January 17, 2023January 6, 2023 by slowder

When we start developing in a new language or on a new platform, it’s easy to fall into the trap of monolithic design.  The free flow from idea to code leads to a single blob of functional code. This leads to quick prototype code that meets the functional requirements. The problem with this approach creeps…

Continue reading

Testing Ingest

Posted on January 12, 2023January 6, 2023 by slowder

Last time, we built a simple transform function in Python, but how do we know if it works? We need to build some tests to find out. I admit data engineering has be late to the practice of test development, but it’s not too hard to adopt. Let’s work through a simple data test, a…

Continue reading

Developing Datbricks Ingestion locally

Posted on January 10, 2023January 5, 2023 by slowder

Spark engines like Databricks are optimized for dealing with many small-ish files that have already been loaded into your Hadoop-compatible file system. If you want to process data from external sources, you’ll want to extract that data into files and store those in your Azure Data Lake Storage (ADLS) account attached to your Databricks Workspace….

Continue reading

Prepare VSC Local Databricks Development

Posted on January 5, 2023January 2, 2023 by slowder

Last time, we walked through how to perform analysis on Databricks using Visual Studio Code (VSC). This time, we will set up a local solution in VSC that will let us build out our data engineering solutions locally. That way, we don’t have to pay for development and testing time. We’d only pay for Databricks,…

Continue reading

Get Started with Databricks in VSCode

Posted on January 3, 2023December 30, 2022 by slowder

You’ve just received a new dataset, and you have to analyze it to prepare for building out the d ta ingestion pipeline. But first, we’ll need to create a cluster to run our analysis. Let’s run through a simple data analysis exercise using Databricks and Visual Studio Code (VSC). Create a cluster from the Web…

Continue reading

Connecting Visual Studio Code to Databricks

Posted on December 29, 2022December 29, 2022 by slowder

After you have your Databricks workspace, it’s time to set up your IDE. Head over to https://code.visualstudio.com/ to download the version for your operating system. It’s available for Windows, Mac, or Linux. During my most recent Databricks presentation, I was asked to point out that Visual Studio Code (VSC) is separate from Visual Studio. It…

Continue reading

Provisioning Databricks

Posted on December 27, 2022December 27, 2022 by slowder

Now that you’ve had an introduction let’s get started exploring Databricks. Head to https://community.cloud.databricks.com and click the sign up link at the bottom. The community edition is a completely free option. Fill in your contact information. It may help to use a ‘+’ email address to sign up; that way, you can later sign up…

Continue reading
  • 1
  • 2
  • 3
  • 4
  • …
  • 46
  • Next
  • Career Development
  • Data Engineering
  • Data Science
  • Infrastructure
  • Microsoft SQL
  • Modern Data Estate
  • Personal
  • Random Technology
© 2023 shannonlowder.com | Powered by Minimalist Blog WordPress Theme