Ben (@bbgatch) 's Twitter Profile
Ben

@bbgatch

Analytics professional working in the hospitality industry. I like Python, SQL, data, hotels, and music.

ID: 1269997286739906560

linkhttps://www.bbgatch.com/ calendar_today08-06-2020 14:20:38

363 Tweet

315 Takipçi

4,4K Takip Edilen

Austen Allred (@austen) 's Twitter Profile Photo

You don’t need to learn how to code. You just need to be able to tell a computer what to do in a way that it will respond, understand what it’s doing and how to optimize that, and fix it when it’s not working.

Ben (@bbgatch) 's Twitter Profile Photo

I'm embarrassed to admit just how recently I realized that most terminals have tab autocompletion. So if you work in the terminal and haven't realized it yet, please know that you can start typing the first few letters of a folder/item name, hit tab, and it will likely fill in

Justin Skycak (@justinskycak) 's Twitter Profile Photo

The journey to developing a high level of talent occurs through a similar general process regardless of the specific talent domain. It can be roughly divided into 3 stages, and we all know people who have fallen into various failure modes.

The journey to developing a high level of talent occurs through a similar general process regardless of the specific talent domain. It can be roughly divided into 3 stages, and we all know people who have fallen into various failure modes.
nick.json.gz (@nickursa) 's Twitter Profile Photo

Today, MotherDuck released InstantSQL and it will change how you work with databases. See query results *as you type* for instant feedback and more. Watch below as I edit a query and errors and results change as I add predicates. Note I can click INTO a cte !

Ben (@bbgatch) 's Twitter Profile Photo

I recently encountered an interesting SQL issue. Suppose you have a CTE that assigns random row numbers. You then join that CTE to itself, referencing the row numbers two times. They should match, right? Since they're coming from the same CTE. Wrong! At least in BigQuery and

I recently encountered an interesting SQL issue.

Suppose you have a CTE that assigns random row numbers. You then join that CTE to itself, referencing the row numbers two times. They should match, right? Since they're coming from the same CTE.

Wrong!

At least in BigQuery and
Ben (@bbgatch) 's Twitter Profile Photo

"It is the gate which leads you to the state of mind, in which you live so close to your own heart that you no longer need a language. It is utterly ordinary. It is what is in you already. Your first, most primitive impulses are right, and will lead you to do the right thing, if

Ben (@bbgatch) 's Twitter Profile Photo

New DuckDB Blog Post: Maching Learning Prototyping with DuckDB and scikit-learn Have you incorporated DuckDB into any of your work with scikit-learn? If so, does it look like this blog post, or different? duckdb.org/2025/05/16/sci…