🔱 apc-metadata-copy - can we copy CaDeT Views to APC?

[tom-webber]

Context

The issue in this Slack thread was caused by Views not being copied over to APC.

The metadata-to-apc workflow triggered within the create-a-derived-table (CaDeT) repo copies the metadata to the destination account.
The terraform plan and apply workflow in the data-engineering-database-access repo runs on merged changes to the repo, and allocates permissions to databases and tables to quicksight users. That terraform apply is currently failing because it's trying to assign permissions to the analytical_platform_value_int database which it cannot find, *because the analytical_platform_value_int database consists of a single View, and so isn't picked up by the apc-metadata-copy workflow.
If you set up a workflow dispatch that calls the copy-metadata workflow and change the CaDeT code to include creating a Table within the analytical_platform_value_int database, it should create the database and the permissions assignment could then complete.

Proposal

Try adding views to the current metadata copy scripts (currently only looking at models matching the pattern model.mojap-derived-tables). See if that works?

Spike requirements

Data Engineer, 1 day

Definition of Done

• Try adding views to the current metadata copy scripts
• Test-run
• Create new issue to productionise and add tests if it works