InData Engineer ThingsbyBrian Roepke·Feb 1, 2025Snowflake to SQLite or DuckDB: Data-Driven Apps Using Local DataExplore two popular embedded database options that can be an alternative to directly querying your data warehouse in high-read situationsA response icon1A response icon1
InTDS ArchivebyBrian Roepke·Jan 11, 2025Build Your First API with Python and AWSLearn how to create a simple, yet powerful REST API with FastAPI, DynamoDB, and AWS Lambda Functions.
InTDS ArchivebyBrian Roepke·Dec 14, 2024Let’s Learn a Little About Computer Vision via SudokuSolving Sudoku is a fun challenge for coding, and adding computer vision to populate the puzzle ties this with a popular ML techniqueA response icon3A response icon3
InTDS ArchivebyBrian Roepke·Nov 23, 2024Implementing Streamlit-Authenticator Across Multi-Page AppsStreamlit-Authenticator allows you to add a simple yet robust method for user authentication in a Streamlit application.
InTDS ArchivebyBrian Roepke·Nov 9, 2024Creating Dynamic Pivots on Snowflake Tables with dbtLeverage dbt and its advanced scripting functionality to generate dynamic pivot tables that adapt to changing pivot values
InData Engineer ThingsbyBrian Roepke·Oct 26, 2024Implementing Snowflake’s Latest Security RecommendationsSnowflake is starting to enforce stricter security policies by default; if you have an existing account, here is how to get ahead of these…
InTDS ArchivebyBrian Roepke·Oct 12, 2024Upgrading to Prefect Push Workers on AWS ECSUpgrade from Prefect 2.0 to 3.0 and use the new Push Work Pools that greatly simplify infrastructure management and reduce cost.
InTDS ArchivebyBrian Roepke·Jun 17, 2024Cheating at Wordle? A Python and Streamlit-Based SolverA fun and educational approach to programmatically solving the popular game Wordle
InData Knows AllbyBrian Roepke·Oct 14, 2023dbt: Codify and Automate Transformation of Data in Your Data Warehousedbt helps transform data in your warehouse all through SQL following software engineering best practices.A response icon1A response icon1
InTDS ArchivebyBrian Roepke·Apr 2, 2023Five Powerful Prioritization Techniques from Product ManagementHow Data Scientists can learn from how a Product Manager builds a product, thinks about customer-centricity, and ensures that the product…