aws kms encrypt --key-id '' --plaintext '' --query CiphertextBlob --output text
aws kms decrypt --ciphertext-blob fileb://<(echo '' | base64 -D)
aws kms decrypt --ciphertext-blob fileb://<(echo '' | base64 -D) --output text --query Plaintext | base64 -D
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Action | |
Adventure | |
Alien Invasion | |
Any | |
Biography | |
Comedy | |
Comedy-Drama | |
Crime | |
Cyberpunk | |
Disaster |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
aboutTurn Is... | |
Where: Skating Class | |
Judges Score: 2.7 | |
Some square confronts you and begins asking you questions that just don't seem important. | |
1. Q9K4 KRUXNLT K9ERA "HG MQNJ IULVI4" DK1 "RVRVLYB IS07V0 02HGI" (XIB TIRZNLF GNL QIS9 OYGEGC9E ASJ2VL)? | |
2. Q9K4 S9 K1KVH VPOC'9 C1RKW K5UEVLW? | |
3. 9K 9K4I9WI4 LVEFV GI1U, XI14 AI UIB 1EELVRAK4IA WVLO CNL "QIDKMI" (CI PJJPIVA WK "XI1OM LPWZ")? |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
SELECT | |
pg_database.datname, | |
pg_size_pretty(pg_database_size(pg_database.datname)) AS size | |
FROM pg_database; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
INSERT INTO {table_schema}.{table_name} ( | |
name, | |
city, | |
customer_id, | |
last_purchase, | |
nps, | |
value_tier, | |
customer_since | |
) | |
SELECT |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
CREATE EXTENSION IF NOT EXISTS postgres_fdw; | |
CREATE EXTENSION IF NOT EXISTS dblink; | |
CREATE SERVER {server_name} | |
FOREIGN DATA WRAPPER postgres_fdw | |
OPTIONS ( | |
host {src_host}, | |
port {src_port}, | |
dbname {src_db} | |
) |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
with contacts as ( | |
select cr.id as contact_record_id | |
, cr.customer_id | |
, cr.form_version_id | |
, r.key as question_id | |
, r.value#>>'{}' as question_response | |
from cx_snapshot.contacts_newcontactrecord cr | |
, jsonb_each(cr.fields::jsonb->'responses') r | |
) | |
, questions as ( |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
EXPLAIN ANALYZE SELECT COALESCE(src.key, dst.key) as key | |
, dst.key IS NULL as added | |
, src.key IS NULL as removed | |
, COALESCE(md5(src::text) <> md5(dst::text), false) as changed | |
, md5(src::text) as src_hash | |
, md5(src::text) as dst_hash | |
FROM "ab_two" as src | |
FULL OUTER JOIN "ab_one" as dst ON (src.key = dst.key) |
NewerOlder