From the course: Google Cloud Associate Cloud Engineer Cert Prep

Unlock this course with a free trial

Join today to access over 24,800 courses taught by industry experts.

Executing queries to retrieve data from data instances

Executing queries to retrieve data from data instances - Google Cloud Tutorial

From the course: Google Cloud Associate Cloud Engineer Cert Prep

Start my 1-month free trial Buy for my team

Executing queries to retrieve data from data instances

“

- Executing queries to retrieve data from data instances. So to retrieve data from some of the data storage solutions in Google Cloud the approach will depend on which product we are talking about. So for Cloud Storage we can use, gsutil that's the cloud storage CLI utility. We can obviously also use the console or the client libraries, For a Cloud SQL managed database, any MySQL Postgres or SQL Server compatible client, depending obviously on which SQL engine you are running in Cloud SQL, those should work. Or client libraries, as well which typically have support for those. For BigQuery, there is bq. The BigQuery's command line interface utility. Also the console, you can go to the console and write your SQL queries in there. Or once again, the client libraries like Python, Java, et cetera. For Spanner, you can use GoogleSQL or PostgreSQL client via JDBC or R2DBC drivers. For Bigtable, you can use the HBase clients, so Bigtable is Hbase, API compatible. And you can also use the…

Contents