Swateek Jena swateek

USE information_schema;

DESC MV_DATA_DISK_USAGE;

SELECT * FROM MV_DATA_DISK_USAGE;

SELECT DATABASE_NAME, FORMAT(SUM(`BLOBS_B`) / 1024/1024, 0) MB
FROM MV_DATA_DISK_USAGE
GROUP BY DATABASE_NAME

jq

Print all of the JSON content in a key value pair, like in an environment file.

echo '{"key1":"value1", "key2": "value2", "key3": "value3"}'\
| jq -r 'to_entries|map("\(.key)=\(.value|tostring)")|.[]'

echo '{"key1":"value1", "key2": "value2", "key3": "value3"}'\
| jq -r 'to_entries[] | "\(.key)=\(.value | tostring)"'

Vagrant and VMWare Tech Preview on Apple M1 Pro

This document summarizes notes taken while to make the VMWare Tech preview work on Apple M1 Pro, it originated from discussions in hashicorp/vagrant-vmware-desktop#22

Installing Rosetta

First install Rosetta if not already done, this is needed to run x86 code:

	import { DBSQLClient } from "@databricks/sql";
	import IDBSQLSession from "@databricks/sql/dist/contracts/IDBSQLSession";

	interface DataBricksWareHouseConnect {
	token: string;
	host: string;
	path: string;
	}

	class DataBricksManager {

	from databricks import sql

	DATABRICKS_USE2_PAT = ""

	use2_workspace = sql.connect(
	server_hostname="<YOUR-SERVER-HOSTNAME>",
	http_path="<YOUR-HTTP-PATH>",
	access_token=DATABRICKS_USE2_PAT,
	catalog="<YOUR-CATALOG-NAME>",
	schema="<YOUR-SCHEMA-NAME>"

	bedrock_agent:
	role: >
	Bedrock AI Assistant
	goal: >
	Help users generate responses using AWS Bedrock's LLM.
	backstory: >
	You are an advanced AI assistant powered by AWS Bedrock. You excel at processing
	and generating meaningful insights from textual data.
	tools:
	- bedrock_tool

	#!/bin/bash

	current_time=$(date "+%Y_%m_%dT%H_%M_%S")
	rm -rf .my_job 2> /dev/null
	mkdir -p .my_job
	mkdir -p .my_job/{100,101,102,103,104,105,106,107,108,109,110}
	ls -d .my_job/* \| xargs -I {} bash -c "cd '{}' && touch sample_$random_$current_time.txt"
	curl -s -X GET https://filesamples.com/samples/document/csv/sample4.csv -o .my_job/sample_$current_time.csv
	curl -s -X GET https://filesamples.com/samples/document/pdf/sample2.pdf -o .my_job/sample_$current_time.pdf
	curl -s -X GET https://filesamples.com/samples/document/xls/sample3.xls -o .my_job/sample_$current_time.xls

	-- Delete a key from JSON Object
	-- INPUT: {"somekey":"somevalue", "meta": {"ui": false, "miscTest": {"unit": "kWh", "value": 10}}}
	UPDATE myTable
	SET meta=JSON_DELETE_KEY(meta, 'miscTest')
	WHERE id="85c8a446-fe24-11ed-8abf-af2f19c7e27f";
	-- RESULT: {"somekey":"somevalue", "meta": {"ui": false}}


	-- Update a key in JSON Object
	-- INPUT: {"somekey":"somevalue", "meta": {"ui": false}}

	@echo off
	echo %DATE% %TIME%>C:\Users\Swateek\Downloads\tmp\abc_%RANDOM%.txt

	If you'r using MAC Intel CPU you want to use VMware to virtual your desired OS such Windows or Ubuntu on the MAC OS you need to download VMware Fusion Player first then it has two version Pro and Player, the Player version is free for personal use but you need to create VM account to download and licence key.

	You can create account to download yourself here:
	https://customerconnect.vmware.com/group/vmware/evalcenter?p=fusion-player-personal

	If you don't want to create account to get license, you can try below original license key for VMware Fusion Player:

	COMPONENT:
	VMware Fusion Player – Personal Use