Creating a data product from SQL in Data Product Hub

You can use SQL statements to define a data product by creating an SQL asset in a project. You can create simple or complex queries, or create custom query templates with parameter sets that allow users to generate a custom view of the data.

• Creating a data product from a query
• Creating a data product from a customizable query

When creating a data product using SQL, you must use a connection that supports SQL assets. The following connections support SQL assets:

• Amazon Redshift

• Apache Cassandra

• Apache Hive

• Google BigQuery

• IBM Db2

• IBM watsonx.data Presto

• Microsoft SQL Server

• MySQL

• Oracle

• PostgreSQL

• Snowflake (version 5.0.1 and later.)

• Teradata