/athena-utils

Utility functions for dbt projects running on Athena

[⚠️ Maintainer needed. Please contact if you're using this library in your project]

athena-utils

This dbt package contains macros that:

  • can be (re)used across dbt projects running on Athena
  • define Athena-specific implementations of dispatched macros from other packages

Notes on this fork

This repo contains several fixes and addons that are used by EPAM Anywhere Analytics team
Some of them are in the process of adding to the upstream
Changes and updates:

  • Fixed get_tables_by_pattern_sql

Installation Instructions

Add to your packages.yml

packages:
  - package: lalalilo/athena_utils
    version: 0.4.0

For dbt >= v0.19.2, , add the following lines to your dbt_project.yml:

dispatch:
  - macro_namespace: dbt_utils
    search_order: [athena_utils, dbt_utils]
  - macro_namespace: dbt_expectations
    search_order: [athena_utils, dbt_expectations]
  - macro_namespace: metrics
    search_order: [athena_utils, metrics]

For dbt < v0.19.2, add the following lines to your dbt_project.yml:

vars:
  dbt_utils_dispatch_list: ["athena_utils"]

Compatibility

This package provides compatibility "shims" for:

In the future more shims could be added to this repository.

Contributing

We welcome contributions to this repo! To contribute a new feature or a fix, please open a Pull Request with 1) your changes and 2) updated documentation for the README.md file.