sql

The purpose for this document is to provide basic instructions on how to align the source files and get them prepared for loading into the Azure Blob, with further instructions on how to run the process (they requested that it not run automatically), and how to check the validation report […]

User Instructions and Load Process Plan for AFBDonorReceipts

The purpose of this stored procedure is to merge dbo.receipts (new receipts), tblStoreData (historical data), and source_mealconnect tables into receipts_vw table (converted from view – necessary for speed). Once the merge is completed, clean-up steps are run:Pre-step remove all records within last 6 months where [comment] = ‘Missing Contributor id […]

SQL example Stored Procedure update_receipt_vw

I worked on this for a government related agency – for their construction department. The need was to pivot source data- a very wide, hard to decipher column data – into hours data by craft, trade, gender, race and by a derived row key (a tall, narrow data table). There […]

SQL Example Workforce Grid

One of the things I am finding working more and more with Impala… specifically creating views and tables with impala sql… is that I have to be very specific when I am developing. Impala sql is case sensitive. This means that if you capitalize “RowCreateDateTime” initially, every time you refer […]

Impala SQL requirements