Defining the Schema - Apps Script | Episode 15.3 ~ Data Studio Service
Hey Coders! The schema is a critical component of any data set, and when it comes to building out BI Dashboards with Data Studio, defining your data's schema is crucial for Data Studio to show your data correctly. But what exactly is a schema? How I like to think of it is to imagine a Google Spreadsheet and all the data in row 1 of that Sheet is the schema. A schema defines the field titles as well as their data type. Furthermore, in terms of Data Studio, all fields must be classified as either a dimension or a metric in the schema. This is part 3 to building out a working community connector, and a required step, so be sure to watch the entire video!
Check out the source code on GitHub:
https://github.com/davidtheweiss/Apps...
❤️ Support the ongoing growth of this channel, get exclusive perks, and receive consultation on your projects! / davidweissprogramming
🧑💻 Apps Script Documentation: https://developers.google.com/apps-sc...
----------------------------------------------------------------------------------------------
🕒 Timestamps
0:00 Intro
0:17 What is a Schema?
2:39 Overview and Problem Statement
4:15 Building and Returning an Empty Schema
6:45 Analyzing the Nomics API Response Object
8:36 Adding Dimension Fields to Our Schema
11:58 Adding Metric Fields to Our Schema
14:27 Viewing the Schema From the Data Studio Dashboard
----------------------------------------------------------------------------------------------
Other playlists:
-------------------------------------
Google Cloud
-------------------------------------
App Engine:
• Google Cloud - Season 1 | App Engine
Google Cloud Orientation:
• Google Cloud - Season 0 | Orientation
-------------------------------------
Apps Script
-------------------------------------
Data Studio Service:
• Apps Script - Season 15 | Data Studio...
Maps Service:
• Apps Script - Season 14 | Maps Service
Utilities Service:
• Apps Script - Season 13 | Utilities S...
Properties Service:
• Apps Script - Season 12 | Properties ...
URL Fetch Service:
• Apps Script - Season 11 | URL Fetch S...
Drive Service:
• Apps Script - Season 10 | Drive Service
Forms Service:
• Apps Script - Season 9 | Forms Service
Lock Service:
• Apps Script - Season 8 | Lock Service
HTML Service:
• Apps Script - Season 7 | HTML Service
Document Service:
• Apps Script - Season 6 | Document Ser...
Slides Service:
• Apps Script - Season 5 | Slides Service
Calendar Service:
• Apps Script - Season 4 | Calendar Ser...
Script Service:
• Apps Script - Season 3 | Script Service
Gmail Service:
• Apps Script - Season 2 | Gmail Service
Spreadsheet Service:
• Apps Script - Season 1 | Spreadsheet ...
Apps Script Orientation:
• Apps Script - Season 0 | Orientation
----------------------------------------------------------------------------------------------