The Query Acceleration Service (QAS) is now generally available to all Snowflake Accounts — Enterprise edition and up. It is a feature that allows Snowflake virtual warehouses to have essentially boundless amount of resources as it needs to accelerate parts of queries. What is Query Acceleration Service? It’s a common situation where a virtual warehouse…

Take your efficiency to the next level with these Pandas and Python Tricks! — Motivation This blog regroups all the Pandas and Python tricks & tips I share on a basis on my LinkedIn page. I have decided to centralize them into a single blog to help you make the most out of your learning process by easily finding what you are looking for. The…

Pure SQL and SQL within Python In this post, we will explore some SQL code using the SQLite3 flavour. We will also code the same SQLite3 flavour in Python with Python3 and SQLite3. By the end of this post you will be able to: Create a local database on your machine Add tables to your database …

A comparison between different topic modeling strategies including practical Python examples — Table of contents Introduction Topic Modeling Strategies 2.1 Introduction 2.2 Latent Semantic Analysis (LSA) 2.3 Probabilistic Latent Semantic Analysis (pLSA) 2.4 Latent Dirichlet Allocation (LDA) 2.5 Non-negative Matrix Factorization (NMF) 2.6 BERTopic and Top2Vec Comparison Additional remarks 4.1 A topic is not (necessarily) what we think it is 4.2 …