Query-backed and Object-backed Data Sources
Audience: Data Owners
For a discussion of the concepts and philosophies behind Immuta data sources, navigate to the data source entry in the Immuta Glossary.
Query-backed data sources are accessible to subscribed data consumers via our Immuta Query Engine and appear as though they are Postgres tables.
The storage technologies relevant to this tutorial are listed below. Hyperlinked technologies require special consideration.
- Amazon Athena
- Amazon Redshift
- Azure SQL Data Warehouse
- IBM DB2
- IBM DB2 for iSeries
- IBM Netezza
- MS SQL Server
- SAP HANA
- Sybase ASE
Schema Namespace Support
As a Data Owner, you can specify the schema in which to create the SQL-queryable table reference; this allows you to mirror the source schema name, incorporate the source database and source schema in the schema name, or organize data sources any way that you want.
If you do not specify the schema or the schema does not exist, the schema will be automatically created. If a data
source is deleted and there are no other tables in the schema, the schema will automatically be dropped (except for the
Object-backed data sources are data storage technologies that do not support SQL and can range from NoSQL technologies, to blob stores, to filesystems, to APIs.
The storage technologies relevant to this tutorial are listed below. Hyperlinks provide specific instructions for each technology.