Query-backed and Object-backed Data Sources

Audience: Data Owners

Content Summary: This section includes guides for creating query-backed data sources and object-backed data sources in Immuta.

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

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
• BigQuery
• Databricks
• ElasticSearch
• Greenplum
• HIVE
• IBM Netezza
• Impala
• MariaDB
• MemSQL
• MS SQL Server
• MySQL
• Oracle
• PostgreSQL
• Presto
• SAP HANA
• Snowflake
• Teradata
• Vertica

Object-backed Data Sources

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.

• Amazon S3
• Apache HDFS
• Azure Blob Storage
• Custom
• FTP
• Persisted