BigQuery System Variables: How to Use Them in Multi-Statement Queries
12 days ago
System variables in BigQuery are special variables available in multi-statement queries, allowing us...
Constantin Lungu
Top Creator
Constantin Lungu is a Top BigQuery Creator. Part of Swipe Insight Select, a curated list of top creators.
Top BigQuery Creator
Romania
33 Swipes
About
Constantin is an experienced Data Engineer with a proven track record across multiple industries. He holds certifications as a GCP Professional Data Engineer and AWS Certified Data Analytics Specialist. Skilled in Python, C#, Scala, BigQuery, Spark, and Microsoft BI Stack, he excels in PowerBI, Tableau, and DataStudio. Proficient in SQL Server, MySQL, MongoDB, and DevOps tools like Airflow and Docker. Fluent in English, French, Romanian, and Russian, and conversational in German.
Top Topics
Achievements
Coming Soon 🤞
Swipes
BigQuery Job History: Retrieve, Analyze, and Manage Queries Effortlessly
24 days ago
BigQuery's job history feature saves every query, providing access to personal and project history. ...
Understanding SQL Anti-Joins: Retain Rows Not Found in Another Table
28 days ago
The SQL Anti-Join retains rows in one table not found in another. Achieved with LEFT JOIN + WHERE [k...
Understanding NULL in BigQuery SQL
NULL in SQL represents the absence of a value, distinct from an empty string or zero. Key points inc...
Differences Between FLOAT (FLOAT64) vs NUMERIC Data Types in BigQuery Explained
1 months ago
FLOAT (FLOAT64) is a double-precision floating-point number that can express a large array of values...
Showcasing Versatile BigQuery Aggregation Functions: LOGICAL_AND and LOGICAL_OR
1 months ago
LOGICAL_AND and LOGICAL_OR are versatile non-standard SQL aggregation functions in BigQuery. LOGICAL...
Using LIMIT in BigQuery: Save Time in Data Validation and Assumption Testing
1 months ago
Using LIMIT in BigQuery doesn't save costs as it doesn't reduce data processed, only the number of r...
Understanding the Use of NOT NULL Constraint in BigQuery
1 months ago
The NOT NULL constraint in BigQuery allows users to declare if a column should not be null when crea...
BigQuery Introduces New Feature for Simplified Row-Level Security Management
1 months ago
BigQuery has introduced a new feature, currently in preview, that simplifies row-level access securi...
Understanding the Difference: WHERE vs HAVING in SQL
In SQL, WHERE and HAVING differ in their application timing. WHERE is used before aggregation, while...