Skip to content

rachelgagnon/rgagnon-aef-dataform

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

7 Commits
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Dataform Repository

  • Houses your table definitions using a structure recommended for Dataform repositories.
  • Use the dataform.json file to provide parameters to be referenced by your *.sqlx files during Dataform operations.
├── dataform
│   └── definitions
│   │    └── landing_dataset
│   │        ├── raw_products.sqlx
│   │        └── ...
│   └── dataform.json

Using this Datafrom repository with aef-data-model

  • Define datasets in the dataform.json variables, if this repository is referenced, this parameters will be read by aef-data-model during terraform apply to create the datasets defined here.
  • It should include 3 variables for each dataset with next format:
{
  "defaultSchema": "default_dataset",
  "assertionSchema": "dataform_assertions",
  "defaultLocation": "<REGION>",
  "warehouse": "bigquery",
  "defaultDatabase": "<PROJECT>",
  "vars": {
    "dataset_id_<DATASET_IDENTIFIER>":"<DATASET_NAME>",
    "dataset_projectid_<DATASET_IDENTIFIER>":"DATASET_PROJECT>",
    "dataset_location_<DATASET_IDENTIFIER>":"<DATASET_LOCATION>",
    ...
  }
}

About

No description, website, or topics provided.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published