Gregory Mirsky gmirsky

I hereby claim:

To claim this, I am signing this object:

	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

	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

	import pandas as pd
	import openpyxl
	from openpyxl import load_workbook

	workbook_name = './MyExcelWorkBook.xlsx'
	chars_to_remove = [
	'+',
	'&',
	'(',
	')',

	select current_user();
	select current_available_roles();