舉報 
會員
Learning Google BigQuery
最新章節：
Further reading
Ifyouareadeveloper,dataanalyst,oradatascientistlookingtoruncomplexqueriesoverthousandsofrecordsinseconds,thisbookwillhelpyou.NopriorexperienceofworkingwithBigQueryisassumed.
最新章節
- Further reading
- Summary
- Google Cloud Dataprep
- Importing message data into BigQuery
- Message output formats
- Cloud Pub/Sub pricing
品牌：中圖公司
上架時間：2021-07-02 18:38:18
出版社：Packt Publishing
本書數字版權由中圖公司提供，并由其授權上海閱文信息技術有限公司制作發行
- Further reading 更新時間：2021-07-02 21:24:32
- Summary
- Google Cloud Dataprep
- Importing message data into BigQuery
- Message output formats
- Cloud Pub/Sub pricing
- Cloud Pub/Sub via Google Cloud SDK
- Cloud Pub/Sub via Google Cloud Console
- Getting started with Cloud Pub/Sub
- Introduction
- Google Cloud Pub/Sub
- Summary
- Getting started
- Complex but with considerable flexibility – the R programming language
- Create a word cloud in Tableau
- Map charts in Tableau
- Getting started
- Simple fairly flexible but with a cost – Tableau
- Other features of Data Studio
- Making a map in Data Studio
- Making a scatterplot in Data Studio
- Getting started
- Simple yet basic – Google Data Studio
- Three tools for visualizing BigQuery data
- Making data visualization work for you
- The danger of summary statistics
- Why is data visualization important?
- Visualizing BigQuery Data
- Summary
- Roles and permissions
- Streaming insert of rows
- Execute query and copy results to a new table
- Executing a query and displaying the result
- Importing data from a file in Google Cloud Storage to a BigQuery table
- Creating a new table within a dataset
- Creating a new dataset in the project
- Listing all datasets and all tables in the project
- Programming with BigQuery API in Python
- Streaming insert of rows
- Executing the query and saving the result in a new table
- Executing a query and displaying the result
- Loading data from a file in Google Cloud Storage to a BigQuery table
- Creating a new table within a dataset
- Creating a new dataset in the project
- Listing all datasets and all tables in the project
- Authenticating the service account
- Programming with BigQuery API in C# .NET
- Creating a service account
- Getting credentials for API access
- Introducing Google APIs explorer
- Accessing Google BigQuery
- Google BigQuery API
- Further reading
- Summary
- Querying nested and repeated records
- Views
- User-defined functions
- Wildcard tables
- Querying data from external data sources
- Creating the table definition
- Querying external data sources using BigQuery
- Using partition tables in your projects
- Querying data in a partition table
- Creating a partition table using Google Cloud SDK
- Creating a partition table using a GUI
- Partition tables
- BigQuery SQL Advanced
- Further reading
- Summary
- Deleting data from a table
- Resetting a value
- Updating data in a table
- Inserting data to a table
- Creating a table
- Adding your own data in BigQuery
- UNION UNION ALL and UNION DISTINCT
- Cross join
- Full Outer join
- Right Outer join
- Left Outer join
- Inner join
- Joining tables in BigQuery
- ROLLUP
- OMIT RECORD IF
- WITHIN
- BigQuery SQL functions
- DISTINCT
- Qualifying tables in query
- HAVING
- ORDER BY
- GROUP BY
- WHERE
- FROM
- SELECT
- Commenting in BigQuery SQL
- Basic SQL syntax
- Querying public data
- Types of queries
- Querying in BigQuery
- Error checking
- The BigQuery interface
- BigQuery SQL Basic
- Further Reading
- Summary
- UDF format
- Some considerations when using UDFs
- Mastering transformation with User-Defined Functions
- Functions for transformation
- Regular Expression Functions
- String Functions
- Date Time Functions
- Comparison Operators
- Arithmetic Operators
- When to transform your data? Before or after loading to BigQuery?
- Sanitizing data
- Converting data
- Data type considerations
- Supported data types
- Google BigQuery Data Types
- Summary
- Deploying to Google App Engine
- Exporting Cloud SQL databases and tables
- Connecting using a proxy script
- Authorizing the client machine via Google Cloud Console
- Connecting to Cloud SQL using gcloud
- Using the gcloud utility
- Using the bq utility for BigQuery
- gsutil for Google Cloud Storage
- Installing Google Cloud SDK on Linux
- Installing Google Cloud SDK on macOS
- Installing Google Cloud SDK on Windows
- Installing Google Cloud SDK
- Google Cloud SDK
- Summary
- Google compute engine
- Google container engine
- App engine flexible environment
- App engine standard environment
- Google App engine
- Cloud Datastore
- Getting started with Cloud SQL
- BigQuery public datasets
- Running your first query
- Working with the browser
- Learning Google BigQuery
- Google Cloud storage and its features
- Overviewing Google Cloud Platform services
- Getting started with Google Cloud
- Google Cloud and Google BigQuery
- Questions
- Piracy
- Errata
- Downloading the example code
- Customer support
- Reader feedback
- Conventions
- Who this book is for
- What you need for this book
- What this book covers
- Preface
- Dedication
- Customer Feedback
- Why subscribe?
- www.PacktPub.com
- About the Reviewers
- About the Authors
- Foreword
- Credits
- 版權信息
- 封面
- 封面
- 版權信息
- Credits
- Foreword
- About the Authors
- About the Reviewers
- www.PacktPub.com
- Why subscribe?
- Customer Feedback
- Dedication
- Preface
- What this book covers
- What you need for this book
- Who this book is for
- Conventions
- Reader feedback
- Customer support
- Downloading the example code
- Errata
- Piracy
- Questions
- Google Cloud and Google BigQuery
- Getting started with Google Cloud
- Overviewing Google Cloud Platform services
- Google Cloud storage and its features
- Learning Google BigQuery
- Working with the browser
- Running your first query
- BigQuery public datasets
- Getting started with Cloud SQL
- Cloud Datastore
- Google App engine
- App engine standard environment
- App engine flexible environment
- Google container engine
- Google compute engine
- Summary
- Google Cloud SDK
- Installing Google Cloud SDK
- Installing Google Cloud SDK on Windows
- Installing Google Cloud SDK on macOS
- Installing Google Cloud SDK on Linux
- gsutil for Google Cloud Storage
- Using the bq utility for BigQuery
- Using the gcloud utility
- Connecting to Cloud SQL using gcloud
- Authorizing the client machine via Google Cloud Console
- Connecting using a proxy script
- Exporting Cloud SQL databases and tables
- Deploying to Google App Engine
- Summary
- Google BigQuery Data Types
- Supported data types
- Data type considerations
- Converting data
- Sanitizing data
- When to transform your data? Before or after loading to BigQuery?
- Arithmetic Operators
- Comparison Operators
- Date Time Functions
- String Functions
- Regular Expression Functions
- Functions for transformation
- Mastering transformation with User-Defined Functions
- Some considerations when using UDFs
- UDF format
- Summary
- Further Reading
- BigQuery SQL Basic
- The BigQuery interface
- Error checking
- Querying in BigQuery
- Types of queries
- Querying public data
- Basic SQL syntax
- Commenting in BigQuery SQL
- SELECT
- FROM
- WHERE
- GROUP BY
- ORDER BY
- HAVING
- Qualifying tables in query
- DISTINCT
- BigQuery SQL functions
- WITHIN
- OMIT RECORD IF
- ROLLUP
- Joining tables in BigQuery
- Inner join
- Left Outer join
- Right Outer join
- Full Outer join
- Cross join
- UNION UNION ALL and UNION DISTINCT
- Adding your own data in BigQuery
- Creating a table
- Inserting data to a table
- Updating data in a table
- Resetting a value
- Deleting data from a table
- Summary
- Further reading
- BigQuery SQL Advanced
- Partition tables
- Creating a partition table using a GUI
- Creating a partition table using Google Cloud SDK
- Querying data in a partition table
- Using partition tables in your projects
- Querying external data sources using BigQuery
- Creating the table definition
- Querying data from external data sources
- Wildcard tables
- User-defined functions
- Views
- Querying nested and repeated records
- Summary
- Further reading
- Google BigQuery API
- Accessing Google BigQuery
- Introducing Google APIs explorer
- Getting credentials for API access
- Creating a service account
- Programming with BigQuery API in C# .NET
- Authenticating the service account
- Listing all datasets and all tables in the project
- Creating a new dataset in the project
- Creating a new table within a dataset
- Loading data from a file in Google Cloud Storage to a BigQuery table
- Executing a query and displaying the result
- Executing the query and saving the result in a new table
- Streaming insert of rows
- Programming with BigQuery API in Python
- Listing all datasets and all tables in the project
- Creating a new dataset in the project
- Creating a new table within a dataset
- Importing data from a file in Google Cloud Storage to a BigQuery table
- Executing a query and displaying the result
- Execute query and copy results to a new table
- Streaming insert of rows
- Roles and permissions
- Summary
- Visualizing BigQuery Data
- Why is data visualization important?
- The danger of summary statistics
- Making data visualization work for you
- Three tools for visualizing BigQuery data
- Simple yet basic – Google Data Studio
- Getting started
- Making a scatterplot in Data Studio
- Making a map in Data Studio
- Other features of Data Studio
- Simple fairly flexible but with a cost – Tableau
- Getting started
- Map charts in Tableau
- Create a word cloud in Tableau
- Complex but with considerable flexibility – the R programming language
- Getting started
- Summary
- Google Cloud Pub/Sub
- Introduction
- Getting started with Cloud Pub/Sub
- Cloud Pub/Sub via Google Cloud Console
- Cloud Pub/Sub via Google Cloud SDK
- Cloud Pub/Sub pricing
- Message output formats
- Importing message data into BigQuery
- Google Cloud Dataprep
- Summary
- Further reading 更新時間：2021-07-02 21:24:32
