Create a Derived Table

⚠️ This service is in beta ⚠️

Create a Derived Table is a tool for creating persistent derived tables in Athena. Read on to find out more or get in touch at the #ask-data-modelling channel.

Overview

• What is Create a Derived Table

Getting Started

• Database Access
• RStudio Set Up
• Collaborating with Git

Planning Models

• Data Modelling Concepts
• Project Structure

Creating Models

• Models
• Source and Ref Functions
• Seeds
• Tests
• Macros

Linting

• Linting YAML files
• Linting SQL files

Deploying Models

• Deploying to Dev
• Scheduling to Prod

Further documentation

• Troubleshooting
• Quick Reference
• dbt-athena Upgrade Guidance

 Resources

• Learn more about dbt in the docs
• Check out Discourse for commonly asked questions and answers
• Join the chat on Slack for live discussions and support
• Find dbt events near you
• Check out the blog for the latest news on dbt’s development and best practices

 License

Unless stated otherwise, the codebase is released under the MIT License. This covers both the codebase and any sample code in the documentation.

The documentation is © Crown copyright and available under the terms of the Open Government 3.0 licence.

This page was last reviewed on 15 September 2022. It needs to be reviewed again on 15 September 2023 by the page owner #ask-data-modelling .

This page was set to be reviewed before 15 September 2023 by the page owner #ask-data-modelling. This might mean the content is out of date.