Ved Bulsaravedbulsara.hashnode.dev·Apr 16, 2024Embracing the Cloud ☁️🤔What is Cloud Computing? Simply put, it's a game-changer in the tech landscape! Cloud computing is a technology that enables users to access and use computing resources (such as servers, storage, databases, networking, software) over the internet...Discuss·27 readsCloud
Constantin Lungudatawise.dev·Apr 11, 2024Comparing tables with FULL OUTER JOINDoes your Data Engineering project use a data-diffing tool? Say you're preparing to deploy a change to a prod table. You've changed the way some metrics are calculated and twisted some filters. How do you find out what's different between two table...DiscussPractical BigQuerySQL
Constantin Lungudatawise.dev·Apr 11, 2024Splitting a STRING in BigQuerySplitting a string in BigQuery works pretty much the same as in Excel. SPLIT works in a similar way as its Excel cousin TEXTSPLIT - taking a string to be split and a delimiter (can be multiple characters), and returns an array of elements. You ca...Discuss·26 readsPractical BigQuerybigquery
David Nguyeneplus.dev·Apr 7, 2024Analyze Sentiment with Natural Language API: Challenge Lab - ARC130Overview In a challenge lab you’re given a scenario and a set of tasks. Instead of following step-by-step instructions, you will use the skills learned from the labs in the course to figure out how to complete the tasks on your own! An automated scor...Discuss·50 readsTip & TricksAnalyze Sentiment
Constantin Lungudatawise.dev·Apr 6, 2024Search Indexes in BigQueryHere's something that might be interesting if you analyze large volumes of STRING or JSON data in BigQuery. Let's look at SEARCH indexes and what you need to know to get started. So, what are they used for? You have a big table (>10 GB) with STRING...Discuss·33 readsPractical BigQuerybigquery
David Nguyeneplus.dev·Apr 6, 2024Introduction to AI and Machine Learning on Google Cloud - QuizIntroduction This course introduces the artificial intelligence (AI) and machine learning (ML) offerings on Google Cloud that support the data-to-AI lifecycle through AI foundations, AI development, and AI solutions. It explores the technologies, pro...Discuss·64 readsTip & TricksAI
Constantin Lungudatawise.dev·Apr 4, 2024Extract all pattern occurrences in BigQueryIf you ever need to extract information based on a pattern in a BigQuery string, check out the REGEXP_EXTRACT_ALL function. This will return an array of all the occurrences matching the specified regular expression. With regards to the pattern it...DiscussPractical BigQuerySQL
David Nguyeneplus.dev·Apr 4, 2024Managing Machine Learning Projects with Google Cloud - QuizIntroduction Business professionals in non-technical roles have a unique opportunity to lead or influence machine learning projects. If you have questions about machine learning and want to understand how to use it, without the technical jargon, this...Discuss·38 readsTip & TricksBusiness professionals
David Nguyeneplus.dev·Apr 4, 2024Filtering Explores with LookML - GSP892Overview Looker is a modern data platform in Google Cloud that lets you analyze and visualize your data interactively. You can use Looker to do in-depth data analysis, integrate insights across different data sources, build actionable data-driven wor...DiscussTip & TricksLookML
David Nguyeneplus.dev·Apr 4, 2024Creating Derived Tables Using LookML - GSP858Overview Looker is a modern data platform in Google Cloud that lets business users analyze and visualize data interactively. LookML developers curate the data used by business users by creating new fields, tables, and views to customize and organize ...DiscussTip & TricksLookML