Learning BI and Data Analytics Tools

 Here is the DBT basics and terminology in hand written notes I learnt from. I will share the additional information as per my learning. Please feel free to comment in case of any topics missed. This is a live document and will be uploading 

This python script lists out users , email and status from Informatica. You need to replace your username, password and informatica url. import requests import json import sys import datetime import smtplib, ssl from email.mime.base import MIMEBase from email.mime.text import MIMEText from email.mime.multipart import MIMEMultipart filename="userslist.txt" username = "" password = "" current_timestamp = datetime.datetime.utcnow().strftime('%Y-%m-%d %H:%M:%S') with open(filename, 'w') as f:   f.write(current_timestamp+'\n') username = username password = password url = "https://dm-us.informaticacloud.com/saas/public/core/v3/login" payload = json.dumps({   "username": username,   "password": password }) headers = {   'Content-Type': 'application/json',   'Accept': 'application/json' } response = requests.request("POST", url, headers=headers, data=payload) login=jso...

 I have written a  python script to pull list of groups and associated users in ICCS using API.  In script you need to replace url and Id and password that has admin access in your environment.  Here is the script import requests import json sid= '' url = "https:Infaurl/api/v2/user/login" payload = json.dumps({ "username" : "Adminuser" , "password" : "Adminpassword" }) headers = { 'Content-Type' : 'application/json' , 'Accept' : 'application/json' } response = requests.request( "POST" , url, headers =headers, data =payload) print (response.text) login=json.loads(response.text) for i in login: if i== "icSessionId" : sid=login[i] #print(sid) groupurl = "https://infaurl/public/core/v3/userGroups?limit=50" payload = {} grpheaders = { 'INFA-SESSION-ID' : sid } groupresponse = requests.request( "GET" , groupurl, headers =grphe...

 Terraform Written Notes.  I have used this notes to clear my Terraform Associate Certification