Advanced Search
Search Results
14 total results found
Analytics
IT/tech tooling for all things related to analytics.
HomeLab
Miscellaneous
DuckDB
The free and open source column based OLAP embedded database. Single exe with no dependencies and blazing fast. https://duckdb.org/
Metabase
Powerful open-source BI tool. Free to use if self-hosted.
DBA to Databricks
This book gives the perspective of a (SQL Server) DBA making the transition to databricks.Databricks is a loud based data platform for lakehouse in the big three (Azure, Amazon, GCP). Based on the open source Delta table format.About me: briandill.com (opens ...
The Book of Misc
A random collection of wisdom that I find worthy of preserving. Links/credits to author when known.
Cookbook Recipes
Glossary
Glossary of Terms associated with databricks ADLS2 - Azure Data Lake Storage Gen2; hierarchical namespace–enabled blob storage used for analytics.autoloader - Databricks feature that incrementally ingests new files from a cloud storage path.autoscaling - auto...
Bookstack code markdown
Bookstack Markdown Languages These languages are available to use for bookstack code blocks SELECT * FROM Foo WHERE name = 'bar'; Language Keywords you can use after SQL sql JavaScript javascript, js, node JSON json HTML html Python python, py ...
Baby Names - SSA database
Social Security Administration's baby names database In this cookbook recipe, you will: Download the full babynames_yob data from the Social Security Administration website. ingest all the CSV files at once using DuckDB. Create and populate rank and pop...
How To Install DuckDB
Watch my short YouTube video on Getting Started with DuckDB Installing DuckDB is fairly quick and easy since it is a single ~36MB file with no dependencies. Installing the command line in Windows The direct download link for x64 and arm64 is on the duc...
Building SELECT lists with SQL
If you are using SQL for ingestion and you want to rename columns PascalCase to snake_case -- PascalCase to snake_case -- , OtherNFLStats AS other_nfl_stats SELECT CONCAT(', ', column_name, ' AS ', LOWER( REGEXP_REPLACE( REGEXP_REPLA...
How to Remember Everything You Read
Author's post on twitter Author's website post Encoding & Comprehension Heuristics Preview First (Survey the Structure) Begin any book or paper with a quick overview. Skim the table of contents, headings, introduction, and summary to grasp the outline befo...