exy02

sql_statement = """
SELECT column_name, data_type
FROM information_schema.columns
WHERE table_name = 'ey_test_table'
;
"""
query_df = pgres.query(db='database_name', query=sql_statement)
query_df
#returns the results of an sql statement as a pandas dataframe. 
#This example returns the column names and data types of table 'ey_test_table'.

exy02

import pandas as pd
import requests
import pickle
import base64
import getpass
import boto3
import json

def get_access_token():
    user_successful_login = False

exy02

Internal_Import_Format1 = pd.read_csv("Internal_Import_Format1.csv",dtype=str)
Internal_Import_Format2 = pd.read_csv("Internal_Import_Format2.csv",dtype=str)
Internal_Table_Format1 = pd.read_csv("Internal_Table_Format1.csv",dtype=str)

data = {'Internal_Import_Format1' : Internal_Import_Format1,
        'Internal_Import_Format2' : Internal_Import_Format2,
        'Internal_Table_Format1' : Internal_Table_Format1 }

airMap = airtableDataMapper(base_key,airAPI_key)
airMap.findMappingView("Project A - Client Summary").mapData(data)

exy02

airMap.findMappingView("Project A - Client Summary").viewMap()

exy02

exy02

exy02

import subprocess
import shutil
import boto3
import json
import os

def lambda_handler(event, context):
    #Parameters =============================
    pipPackage = "requests"
    packageVersion = "2.26.0"