Mihai mieitza

Secure GCP infrastructure checklists

	import pandas as pd
	from scipy.cluster.hierarchy import fclusterdata
	from pymongo import MongoClient
	import numpy as np
	from datetime import *
	import json

	def saveToRelational(jsonPacket):
	"""
	save the received json packet to a relational database

	import pandas as pd
	from pandas.io.json import json_normalize
	from pymongo import MongoClient
	import matplotlib.pyplot as plt
	import re
	import time

	pd.set_option('display.expand_frame_repr', False)

	def _connect_mongo(host, port, db):

	SELECT
	AVG(trace_info.duration_us / 1000000) AS seconds_on_screen,
	AVG(trace_info.screen_info.slow_frame_ratio) AS slow_frame_ratio,
	AVG(trace_info.screen_info.frozen_frame_ratio) AS frozen_frame_ratio,
	event_name as screen,
	country
	FROM `friendly--pix.projectId.firebase_performance.YOUR_PACKAGE_NAME_ANDROID`
	WHERE _PARTITIONTIME > TIMESTAMP("2019-05-09")
	AND event_type = "SCREEN_TRACE"
	AND country = "FR"

	SELECT COUNT(distinct p.user_id)
	FROM `friendly--pix.projectId.firebase_predictions.YOUR_PACKAGE_NAME_ANDROID` p CROSS JOIN UNNEST (predictions)

	WHERE
	prediction_name = "churn"
	AND score > 0.7
	AND TIMESTAMP_TRUNC(p.prediction_time, DAY) = TIMESTAMP('2018-10-04')

	#standardSQL
	SELECT
	event_id, issue_id, blame_frame.file, blame_frame.line
	FROM
	`projectId.firebase_crashlytics.package_name_ANDROID`
	WHERE
	FORMAT_TIMESTAMP("%Y%m%d", TIMESTAMP_TRUNC(event_timestamp, DAY)) = '20190509'

	#!/usr/bin/env bash

	#####################################################################
	# REFERENCES
	# - https://cloud.google.com/secret-manager/docs/create-secret-quickstart
	# - https://cloud.google.com/secret-manager/docs/manage-access-to-secrets
	# - https://cloud.google.com/secret-manager/docs/creating-and-managing-expiring-secrets
	# - https://cloud.google.com/secret-manager/docs/secret-rotation
	# - https://cloud.google.com/compute/docs/access/create-enable-service-accounts-for-instances
	# - https://cloud.google.com/iam/docs/best-practices-service-accounts#single-purpose