IBM has open contract positions for Bluemix

IBM has open contract positions for Bluemix in all of ASEAN (SG, MY, TH, ID, PH) for fresh graduates.

IBM Bluemix

IBM Bluemix

Candidate should fit 2-3 of the minimum requirements:
1. Minimum of 2 years in Web Application Development using NodeJS, Java or Go
2. Minimum of 2 years in Android or iOS application development
3. Familiar with Web stack – HTML, CSS and JavaScript.
4. Familiar with MongoDB or other NoSQL (Document-based)
5. Familiar with Relational Database
6. Familiar with Web Services (REST or SOAP) and OOP concept
7. Familiar with cloud environment (IaaS or PaaS)
Bonus points for:
1. Experience or knowledge in data analytics – especially social media analytics
2. Experience in web development framework – Angular JS, jQuery, Bootstrap
3. Skill in other programming language (Ruby, Python, Scala, C#, etc)
4. Conceptual knowledge in MVC or microservices
5. Past experience in using PaaS
6. Experience in IoT related development (Raspberry Pi, Arduino, etc)
7. Degree in Computer Science / Computer Engineer / AI
8. Experience in DevOps – i.e. Continuous Integration, Continuous Deployment is a plus
9. Experience or knowledge in Docker container technology.

To those interested, can send your resume to st.wissel@sg.ibm.com.

Copy existing an existing table in Google Cloud Big Query

Google Cloud Platform is a set of modular cloud-based services that allow you to create anything from simple websites to complex applications.

Reference: https://cloud.google.com/

Google Cloud Platform

Google Cloud Platform

This guide contains everything you need to know how to copy existing an existing table in Google Cloud Big Query.

Getting Started.

Download bq Command-Line Tool here, https://cloud.google.com/sdk/. (This tutorial focusing on Mac platform only). For Windows user can find it here, https://cloud.google.com/sdk/#windows.

Download and install Google Cloud SDK by running the following command in your shell or Terminal:

curl https://sdk.cloud.google.com | bash
Google Cloud SDK installation

Google Cloud SDK installation

Restart your shell using this command:

exec -l $SHELL

Authenticate to Google Cloud Platform by running gcloud auth login.

gcloud auth login
gcloud auth login

gcloud auth login

Choose your google account and accept the permission.

Google Cloud SDK ask your permission.

Google Cloud SDK ask your permission.

You will redirect to this page after you accept the permission.

Google Cloud SDK auth_success page.

Google Cloud SDK auth_success page.

Google Cloud SDK saved application default credentials.

Google Cloud SDK saved application default credentials.

Before you copy the table, make sure you enable your billing first (don’t worry, it won’t charge you for 14 days trial account). To copy a table, run the bq cp command:

bq cp <source_table> <destination_table>

For example, a sample copy command might look like the following:

bq cp dataset.mytable dataset2.mynewtable

You can also copy tables across different projects by specifying the project id in the source and destination path:

bq cp 123456789123:dataset.mytable 0987654321098:dataset2.mynewtable
Copy an Existing Table

Copy an Existing Table

You can see the results below. From this picture you can determine yourself which one is project id, dataset and table.

Google BigQuery

Google BigQuery

Have fun!!