Home Applications dbt-iris

dbt-iris

This application is not supported by InterSystems Corporation. Please be notified that you use it at your own risk.
3.5
1 reviews
0
Awards
316
Views
0
IPM installs
1
0
Details
Releases
Reviews  (1)
Issues
dbt is the T in ELT, now with IRIS support

What's new in this version

upgraded to dbt-core==1.5.6
added support for Python 3.11

dbt logo

dbt enables data analysts and engineers to transform their data using the same practices that software engineers use to build applications.

dbt is the T in ELT. Organize, cleanse, denormalize, filter, rename, and pre-aggregate the raw data in your warehouse so that it’s ready for analysis.

InterSystems IRIS

InterSystems IRIS is a data platform that provides advanced technologies for building and deploying data-intensive applications. It is a high-performance, multidimensional database that is optimized for complex data and real-time analytics. It is designed to support a wide range of data management, analysis, and integration tasks, and provides features such as a high-performance database engine, a powerful analytics engine, and support for building and deploying microservices. InterSystems IRIS is used by organizations in a variety of industries, including healthcare, finance, and government, to support their data-intensive applications and business processes.

Start InterSystems IRIS Locally with Docker Compose

docker-compose.yml

version: '3'
services:
  iris:
    image: intersystemsdc/iris-community
    command:
      - -a
      # by default it starts with a requirement to change passwords for system users
      - iris session iris -U %SYS '##class(Security.Users).UnExpireUserPasswords("*")'
    ports:
      - 1972:1972
      - 52773:52773

Ports:

docker-compose up -d

Default login and password _SYSTEM and SYS

Configure dbt

.dbt/profiles.yml

...
    iris:
      type: iris
      host: localhost
      port: 1972
      user: _SYSTEM
      pass: SYS
      namespace: USER
      schema: dbt

Required parameters:

  • type = iris
  • host | hostname | server
  • port
  • namespace | database
  • user | username
  • pass | password
  • schema

Useful Links

Made with
Version
1.5.626 Sep, 2023
Python package
dbt-iris
Category
Developer Environment
Works with
InterSystems IRIS
First published
22 Aug, 2023