Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Create Table Schema and register #1194

Closed
5 of 6 tasks
Tracked by #1583 ...
PriyaBasker23 opened this issue Aug 18, 2023 · 0 comments · Fixed by #1873 or ministryofjustice/modernisation-platform-environments#3629
Closed
5 of 6 tasks
Tracked by #1583 ...
Assignees

Comments

@PriyaBasker23
Copy link
Contributor

PriyaBasker23 commented Aug 18, 2023

User Story

As a data producer
I want to define a schema for my data product table and register it with the data platform.
So that best i can ensure conformance against that schema in future uploads, and supply useful information to the data platform catalogue for consumers of my data product.

Proposal

  1. Write a python function/class that will allow to create a schema, plus unit tests
  2. Create an api end point , where schema can be send and created
  3. Metadata information about the file extension type and load type should be included Create a schema and store in folder eg: /data-product-bucket/scheme/databasename=x/table_name=x/schema.json

( No Schema Versioning)

Definition of Done

  • will use glue schema format and have a schema file for the schema to validate table schema against (using pythons jsonschema.validate)
  • define the spec of the schema object in a json schema
  • create new shared ecr repo for each version of the lambda container - modernisation-platform repo.
  • create new lambda container in data-platform repo, with the code api calls to execute the required actions.
  • make all infra in modernisation-platform-environments. api-gateway, lambda, iam
  • Once above tasks complete, add documentation for api endpoint.
@PriyaBasker23 PriyaBasker23 changed the title Api for Table Schema Registration Create Table Schema Aug 30, 2023
@PriyaBasker23 PriyaBasker23 changed the title Create Table Schema Create Table Schema and register Aug 30, 2023
@PriyaBasker23 PriyaBasker23 added api and removed compute labels Sep 26, 2023
@LavMatt LavMatt moved this from To Do to In Progress in Analytical Platform Oct 2, 2023
@LavMatt LavMatt moved this from 💨 In Progress to 👀 In Review in Analytical Platform Oct 11, 2023
@LavMatt LavMatt moved this from 👀 In Review to 💨 In Progress in Analytical Platform Oct 11, 2023
@LavMatt LavMatt moved this from 💨 In Progress to 👀 In Review in Analytical Platform Oct 11, 2023
@YvanMOJdigital YvanMOJdigital moved this from 👀 In Review to 💨 In Progress in Analytical Platform Oct 12, 2023
@LavMatt LavMatt moved this from 💨 In Progress to 👀 In Review in Analytical Platform Oct 12, 2023
@github-project-automation github-project-automation bot moved this from 👀 In Review to ✨ Done ✨ in Analytical Platform Oct 13, 2023
@LavMatt LavMatt moved this from ✨ Done ✨ to 👀 In Review in Analytical Platform Oct 13, 2023
@YvanMOJdigital YvanMOJdigital moved this from 👀 In Review to 💨 In Progress in Analytical Platform Oct 16, 2023
@LavMatt LavMatt moved this from 💨 In Progress to 👀 In Review in Analytical Platform Oct 16, 2023
@LavMatt LavMatt moved this from 👀 In Review to ✨ Done ✨ in Analytical Platform Oct 16, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
Archived in project
2 participants