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" { |
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:
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(); |
import ldap3 | |
import json | |
server_password='Passw0rds123!' | |
server_ip='172.16.10.50' | |
server = ldap3.Server( | |
server_ip, | |
port=636, | |
use_ssl=True |
import pandas as pd | |
import openpyxl | |
from openpyxl import load_workbook | |
workbook_name = './MyExcelWorkBook.xlsx' | |
chars_to_remove = [ | |
'+', | |
'&', | |
'(', | |
')', |