Steve Henderson stevehenderson

Sometimes you need to troubleshoot and inspect the details of jobs (load, query etc.) in BigQuery. Inspecting the job history in the BigQuery web UI will only show the jobs that you have run. This is also true when you run run bq ls -j on the command line.

But, what if you need to get all jobs that have been run? An example would be auotmated jobs run by service accounts. A quick tip is to use the --all flag:

-a,--[no]all: Show all results. For jobs, will show jobs from all users. For datasets, will list hidden datasets. For transfer configs and runs, this flag is redundant and not necessary.

bq ls -j --all

(this tip originated from a question on Stack Overflow: https://stackoverflow.com/questions/47583485/bigquery-history-of-jobs-submitted-through-python-api)

Partition, format, and mount a drive on Ubuntu

Reference:

https://www.howtogeek.com/106873/how-to-use-fdisk-to-manage-partitions-on-linux/

List logical disks and partitions

sudo fdisk -l

Partition the disk

#GoPro HERO4 (A tale of firmware leaks and marketing)

Written by /u/konrad-iturbe (Konrad Iturbe) and with help of /u/OverByThere's leaked firmware.

The GoPro HERO4 Black Adventure edition is 4x times more powerful than ever.

HERO4 cameras:

HERO4 Black (BANZAI)

	package main

	import(
	"log"
	"net/url"
	"net/http"
	"net/http/httputil"
	)

	func main() {

	Only really tested on Ubuntu 16.04

	Requirements:
	* Two Linux systems (one to send traffic, one to receive)
	* Network connectivity over UDP 4789

	Sender Setup
	* Install daemonlogger (sudo apt install daemonlogger)
	* Save systemd service config as /etc/systemd/system/[email protected] (replace X.X.X.X with IP of receiver)
	* Reload systemd (sudo systemctl daemon-reload)

	<!DOCTYPE html>
	<html>
	<head>
	<meta name="description" content="basic paygrade">
	<script src="https://code.jquery.com/jquery-1.6.4.js"></script>
	<meta charset="utf-8">
	<title>JS Bin</title>
	<script>
	var myArr = $.parseJSON('["E1","E2","E3","E4","E5","E6","E7","E8","E9","E10","O1","O2","O3","O4","O5","O6","O7","O8","O9","O10","O1E","O2E","O3E","W1","W2","W3","W4","W5"]');
	console.log(myArr[0])