Skip to content

Instantly share code, notes, and snippets.

View itsalljustdata's full-sized avatar

Jon Mills itsalljustdata

1 follower · 5 following
View GitHub Profile
@itsalljustdata
itsalljustdata / cols.sql
Last active December 20, 2023 06:38
Select columns for DBT from bronze_to_silver
WITH cols AS (
SELECT CASE WHEN data_type = 'varchar' and CHARACTER_MAXIMUM_LENGTH > 1000 THEN 1 ELSE 0 END cast_needed
,CASE
WHEN NOT (data_type = 'varchar' and CHARACTER_MAXIMUM_LENGTH > 1000) THEN ''
WHEN c.COLUMN_NAME = 'lastUpdateLogin' THEN 32
WHEN c.COLUMN_NAME LIKE '%tedBy' THEN 255
WHEN c.COLUMN_NAME LIKE 'addressLine%' THEN 255
WHEN c.COLUMN_NAME LIKE '%escription' THEN 255
WHEN c.COLUMN_NAME LIKE '%Instruction' THEN 255
WHEN c.COLUMN_NAME LIKE '%Reference' THEN 255
@coltenkrauter
coltenkrauter / fix-wsl2-dns-resolution.md
Last active March 14, 2026 13:41
Fix DNS resolution in WSL2

Permanent WSL DNS Fix (WSL 2.2.1+)

If you're encountering ping github.com failing inside WSL with a Temporary failure in name resolution, you're not alone — this has been a long-standing issue, especially when using VPNs or corporate networks.

This issue is now fixed robustly with DNS tunneling, which preserves dynamic DNS behavior and avoids limitations like WSL’s former hard cap of 3 DNS servers in /etc/resolv.conf.

DNS tunneling is enabled by default in WSL version 2.2.1 and later, meaning that if you're still seeing DNS resolution issues, the first and most effective fix is simply to upgrade WSL. Upgrading WSL updates the WSL platform itself, but does not affect your installed Linux distributions, apps, or files.

To upgrade WSL, follow these steps,