Create table definitions in the data schema of the DACPAC for the three datasets, based on last year's source spreadsheets:
data.AllProjectsdata.ActiveProjectsdata.AssistanceListingNumbers (ALN)
Source spreadsheets: https://ucdavis.app.box.com/folder/344023713312
Each spreadsheet's columns become the table's columns, with types/nullability inferred from the data. Rename headers to clean SQL column names, consistent with project conventions. Add each as a .sql table-definition file so they build into the DACPAC and deploy through the pipeline.
These are domain input data the sprocs join against, so they live in data (DACPAC-owned), not app — see #8.
Depends on: #8 (the .sqlproj and data schema must exist first).
Create table definitions in the
dataschema of the DACPAC for the three datasets, based on last year's source spreadsheets:data.AllProjectsdata.ActiveProjectsdata.AssistanceListingNumbers(ALN)Source spreadsheets: https://ucdavis.app.box.com/folder/344023713312
Each spreadsheet's columns become the table's columns, with types/nullability inferred from the data. Rename headers to clean SQL column names, consistent with project conventions. Add each as a
.sqltable-definition file so they build into the DACPAC and deploy through the pipeline.These are domain input data the sprocs join against, so they live in
data(DACPAC-owned), notapp— see #8.Depends on: #8 (the
.sqlprojanddataschema must exist first).