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 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.
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:
- 1972 - SuperPort - Binary protocol
- 52773 - Internal WebServer, internal System Management Portal is available by http://localhost:52773/csp/sys/UtilHome.csp
docker-compose up -d
Default login and password _SYSTEM and SYS
.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