Giter Site home page Giter Site logo

dbt-postgres-utils's Introduction

Hi there πŸ‘‹

  • πŸ”­ Currently building data products around the future of 🏘️residential investment with Avenue One. Previously, I worked on virtual πŸ’³ payment services at Finexio, Healthcare Marketing at ARS as well as various other projects, personal and professional!
  • πŸ“š I'm currently learning terraform, BigQuery, dbt, Looker, and more!
  • πŸ‘― I'm looking to collaborate on projects related to data infrastructure and architecture abstraction!
  • πŸŽ“ I'm Salesforce certified both as an Administrator (ADM201) and as a Heroku Architecture Designer.
  • ❄️ I'm Snowflake certified for SnowPro Core (COF-C02) as of 2023.
  • πŸ’¬ Ask me about data stacks! 🚒SHPPT stack: (https://github.com/sgoley/SHPPT-Data-Stack)
  • ☁️ My current favorite cloud platform is GCP (https://cloud.google.com/)

dbt-postgres-utils's People

Contributors

sgoley avatar

Stargazers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

Watchers

 avatar  avatar

dbt-postgres-utils's Issues

Unable to use package with dbt 0.21

When running dbt run with dbt version 0.21.0, the following error occurs:

$ dbt run
Running with dbt=0.21.0
Encountered an error:
Runtime Error
  Failed to read package: Runtime Error
    This version of dbt is not supported with the 'dbt_utils' package.
      Installed version of dbt: =0.21.0
      Required version of dbt for 'dbt_utils': ['>=0.20.0', '<0.21.0']
    Check the requirements for the 'dbt_utils' package, or run dbt again with --no-version-check

When running with $ dbt run --no-version-check any models that use postgres_utils (say, to create an index in the post-hook), fail.

The only dependency of this project (fishtown-analytics/dbt_utils) has been deprecated for another (dbt-labs/dbt_utils) - and it looks like that's what's causing this issue. My guess is that a version fix the issue.

Support various index types in index Macros

Opening a ticket as I might work on this:

  • PgSQL supports a range of index types: B-tree, Hash, GiST, SP-GiST, GIN and BRIN
  • It might be worthwhile to expand the macro to include a type variable with the default being B-Tree / unset. A case statement could implement one of the index types inside of the macro based on the type.

My use case is applying a GIN index on some JSON data I'm storing, which I believe will speed up some of my dbt transformations downstream.

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    πŸ–– Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. πŸ“ŠπŸ“ˆπŸŽ‰

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❀️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.