I hereby claim:
- I am gmirsky on github.
- I am vanapagan (https://keybase.io/vanapagan) on keybase.
- I have a public key ASBjua-PhTAUtm8VOq70I_UYHE1NbI6ev52cXkjrfPmf1Qo
To claim this, I am signing this object:
| terraform { | |
| required_providers { | |
| assert = { | |
| source = "hashicorp/assert" | |
| version = ">= 0.14.0" | |
| } | |
| } | |
| } | |
| # | |
| provider "assert" { |
| data "http" "icanhazip" { | |
| url = "http://icanhazip.com" | |
| } | |
| output "my_terraform_environmnet_public_ip" { | |
| value = "${chomp(data.http.icanhazip.body)}" | |
| } |
| use role accountadmin; | |
| use warehouse systemadmin_wh; | |
| use database qa_mdm_db; | |
| -- | |
| WITH filtered_queries AS ( | |
| SELECT | |
| query_id, | |
| query_text AS original_query_text, | |
| -- First, we remove comments enclosed by /* <comment text> */ | |
| REGEXP_REPLACE(query_text, '(/\*.*\*/)') AS _cleaned_query_text, |
| import sys as sys | |
| import logging as logging | |
| import platform as platform | |
| import boto3 as boto3 | |
| import argparse as argparse | |
| import requests as requests | |
| from botocore.exceptions import ClientError | |
| logger = logging.getLogger(__name__) |
| #Inventory-RT53-Zone-Records.ps1 | |
| #Get a Full List of all records from all RT53 Zones, OR only for a targeted Zone set by Variable | |
| #Also can get list for a single targeted Record Type, example TXT, MX etc | |
| # ****** This WILL NOT export any records with "_domainkey" in the Name (url) for security reasons. | |
| #Version: 1.5 | |
| #Tested with Windows Powershell: 5.1, 7.0.3 | |
| #Tested with MacOS PowerShell : 7.0.3 | |
| #Date 10/23/2020 | |
| #Modified 8/03/2022 | |
| #Created: Ed Walsh |
I hereby claim:
To claim this, I am signing this object:
This document will guide you through building a Amazon Linux 2 Server to serve as a docker host for a Grafana container that will power your server.
| use role accountadmin; | |
| -- | |
| -- create warehouse ddl | |
| -- | |
| show warehouses; | |
| -- | |
| CREATE temporary TABLE temp_warehouses as SELECT * FROM TABLE(RESULT_SCAN(LAST_QUERY_ID())); | |
| -- | |
| select 'CREATE OR REPLACE WAREHOUSE ' || t."name" || '\n' || | |
| ' INITIALLY_SUSPENDED = TRUE \n' || |
| use role accountadmin; | |
| -- | |
| show users; | |
| -- | |
| CREATE temporary TABLE temp_users as SELECT * FROM TABLE(RESULT_SCAN(LAST_QUERY_ID())); | |
| -- | |
| select 'CREATE USER ' || t."name" || '\n' || | |
| ' PASSWORD=' || '''Ch@ng3MeN0W!''' || '\n' || | |
| ' COMMENT = ' || '''' || | |
| case |
| select current_user(); | |
| select current_available_roles(); |