---
title: Data Knows All | Brian Roepke
description: Machine Learning, Natural Language Processing, Data Engineering, and More
---

[Skip to content](https://dataknowsall.com/blog/author/brian-roepke#main-content)

[![Lambda with Text - Wide](https://dataknowsall.com/hs-fs/hubfs/Lambda%20with%20Text%20-%20Wide.png?width=3068&height=301&name=Lambda%20with%20Text%20-%20Wide.png)](https://dataknowsall.com)

- [Home](https://dataknowsall.com)
- [Blog](https://dataknowsall.com/blog/)
- [Services](https://dataknowsall.com/services)
- [Technologies](https://dataknowsall.com/technologies)

Open main navigation

Close main navigation

- [Home](https://dataknowsall.com)
- [Blog](https://dataknowsall.com/blog/)
- [Services](https://dataknowsall.com/services)
- [Technologies](https://dataknowsall.com/technologies)
- [Contact us](https://dataknowsall.com/contact)

[Contact us](https://dataknowsall.com/contact)

# Blog

Tips, Tricks, and Best Practices

[![](https://dataknowsall.com/hubfs/DuckDB.jpeg)](https://dataknowsall.com/blog/snowflaketosqliteduckdb.html)

[Data Engineering](https://dataknowsall.com/blog/tag/data-engineering)

## [Snowflake to SQLite or DuckDB: Data-Driven Apps Using Local Data](https://dataknowsall.com/blog/snowflaketosqliteduckdb.html)

 Feb 1, 2025 12:00:00 PM

Why a Local DB? We were working on a project that had a particular request. They wanted to server up...

[![](https://dataknowsall.com/hubfs/DynamoDB%20API.png)](https://dataknowsall.com/blog/dynamodbapi.html)

[Data Engineering](https://dataknowsall.com/blog/tag/data-engineering)

## [Build Your First API with Python and AWS!](https://dataknowsall.com/blog/dynamodbapi.html)

 Jan 14, 2025 12:45:46 AM

Introduction Today, we're going to take a small deviation from the normal Snowflake and Data Warehou...

[![Solving Sudoku](https://dataknowsall.com/hubfs/sudoku_easy.png)](https://dataknowsall.com/blog/solvingsudoku.html)

[Machine Learning](https://dataknowsall.com/blog/tag/machine-learning)

## [Let's Learn a Little About Computer Vision via Sudoku!](https://dataknowsall.com/blog/solvingsudoku.html)

 Dec 14, 2024 12:00:00 PM

Introduction This whole thing started out as a fun little experiment to write another puzzle solver,...

[![](https://dataknowsall.com/hubfs/AI-Generated%20Media/Images/Two%20people%20sitting%20at%20laptops%20using%20a%20browser%20based%20application%20in%20different%20offices.jpeg)](https://dataknowsall.com/blog/streamlitauthmultipage.html)

[Data Engineering](https://dataknowsall.com/blog/tag/data-engineering), [Business Intelligence](https://dataknowsall.com/blog/tag/business-intelligence), [User Experience](https://dataknowsall.com/blog/tag/user-experience)

## [Implementing Streamlit-Authenticator Across Multi-Page Apps](https://dataknowsall.com/blog/streamlitauthmultipage.html)

 Nov 23, 2024 12:00:00 PM

Introduction Streamlit is a widely used tool for creating quick web applications backed by data, but...

[![](https://dataknowsall.com/hubfs/Pivots.png)](https://dataknowsall.com/blog/dbtpivots.html)

[Data Engineering](https://dataknowsall.com/blog/tag/data-engineering)

## [Creating Dynamic Pivots on Snowflake Tables with dbt](https://dataknowsall.com/blog/dbtpivots.html)

 Nov 9, 2024 12:52:12 PM

What are Pivoted Tables? When dealing with tabular data, you often will have that data laid out in a...

[![](https://dataknowsall.com/hubfs/AI-Generated%20Media/Images/Snow%20covered%20server%20racks%20and%20databases.jpeg)](https://dataknowsall.com/blog/snowflakessecurity.html)

[Data Engineering](https://dataknowsall.com/blog/tag/data-engineering)

## [Implementing Snowflake's  Latest Security Recommendations](https://dataknowsall.com/blog/snowflakessecurity.html)

 Oct 26, 2024 12:00:00 PM

What is Changing? Snowflake recently sent an email to their customers regarding new default security...

First Prev [1](https://dataknowsall.com/blog/author/brian-roepke) [2](https://dataknowsall.com/blog/author/brian-roepke/page/2) [3](https://dataknowsall.com/blog/author/brian-roepke/page/3) [4](https://dataknowsall.com/blog/author/brian-roepke/page/4) [5](https://dataknowsall.com/blog/author/brian-roepke/page/5) [Next](https://dataknowsall.com/blog/author/brian-roepke/page/2) [Last](https://dataknowsall.com/blog/author/brian-roepke/page/9)

[![Lambda Google Workspace](https://dataknowsall.com/hs-fs/hubfs/Lambda%20Google%20Workspace.png?width=320&height=132&name=Lambda%20Google%20Workspace.png "Lambda Google Workspace")](https://www.dataknowsall.com)

Specialists in Data Engineering, Machine Learning, and Analytics Consultation

[linkedin-in icon](https://www.linkedin.com/in/broepke/) [twitter icon](https://twitter.com/broepke) [Follow us on Facebook](https://github.com/broepke)

**Pages**

- [Home](https://dataknowsall.com)
- [Blog](https://dataknowsall.com/blog/)
- [Services](https://dataknowsall.com/services)
- [Technologies](https://dataknowsall.com/technologies)

### Get Updates In Your Inbox

Copyright © 2026, Data Knows All