Data warehouse imports

👍

Welcome note

Data hub is our new upgraded platform, which we rolled out in August 2025. It offers a single unified integration for passing your data through to your Bloomreach products.

You have access to Data hub if you've implemented with Bloomreach after August 2025.

Customers who have implemented before August 2025 should follow the existing documentation for Engagement, Discovery, and Clarity.

This guide covers how to import data directly from data warehouses: BigQuery, Snowflake, or Databricks. This type of import uses a direct connection to your data warehouse database and can execute SQL queries and read tables or (materialized) views directly.

Prerequisites

• Data hub permissions: Ensure you have the required permissions.
• Source preparation: Prepare your SQL query to read from existing tables or prepare a dedicated data table or (materialized) view. Grant read permissions to the account that you want Bloomreach to use when reading from the database.
• Integration: Under Data hub > Integrations, configure your BigQuery, Snowflake, or Databricks integration before you can select it as a database SQL integration option.

Configure data warehouse import

After creating a new import and selecting the import type, follow the steps below.

1. Select your SQL integration

Under the Database tab, click the SQL Integration dropdown and choose your data warehouse platform: BigQuery, Databricks, or Snowflake. If the options don’t appear, configure the integration first before proceeding.

2. Set up your source query

After selecting your SQL integration, the interface displays configuration options. Toggle between the Query and Table tabs to choose how you want to specify your data source:

• Query: Enter an SQL query request to retrieve specific data from your database. Ensure the query includes all necessary fields for your Item collection. This option is good for users who have the skills to write and modify the query from the Bloomreach user interface.

• Table: Select an existing table or (materialized) view directly from your database. This option is suitable for less technical users who have had their BI team or data engineers prepare the right datasets.

  

3. Test query

Click the Test query/Preview data button to verify your connection and the data.

Click Next and specify the data mapping.