Practical lab

Now, let’s implement everything we’ve learned by going through some practical exercises.

Problem 1

Our teams have been requested to create a new database and table for the accounting departments’ BI tooling. The database should be called accounting_alpha and its location should be set to dbfs:/tmp/accounting_alpha. The table should be called returns_bronze. The schema of the table should be Date: Date, Account: String, Debit: Float, and Credit:Float.

Problem 2

Our team is now receiving data to be populated into the table. Perform an append using the new data provided:

[(datetime.strptime("1981-11-21", '%Y-%m-%d'), "Banking", 1000.0, 0.1), (datetime.strptime("1776-08-02", '%Y-%m-%d') , "Cash",0.1, 3000.2), (datetime.strptime("1948-05-14", '%Y-%m-%d'), "Land",0.5,10000.5)]

Problem 3

There has been a forced change to the table. Using Python...