March 22

New Features

Databricks Integration: BYOV (Bring Your Own Vendor)

With this release, admins can now import and manage their existing Databricks instance from 5X. Users can integrate their existing Databricks account within 5X to store data and manage user access along with other vendors from the 5X Platform.

Here are the following key features:

• Initiate Databricks BYOV integration: To use your Databricks account on 5X, admins can view the Databricks vendor tile on Integrations.

  • Click Data Warehouse from Categories. Alternatively, you can find Databricks listed on Store data in a central warehouse of the Explore vendors based on your needs section.

  • Click Add vendor, and select Bring my own account.
• Set up your Databricks integration: The Setup Guide helps admins configure and test your Databricks source on 5X.

• Manage Databricks member access on Team: Admins can manage their team member access to Databricks from Team.

• View and manage from Platform: After successfully provisioning your Databricks account instance on 5X, users can view their cluster details on the Databricks vendor tile on Platform.

Note: 5X currently only supports AWS Cloud for Databricks. Please reach out to [e-mail] to request Databricks support for other cloud accounts.

Databricks integration support on 5X Managed dbtCore

5X Managed dbt Core now supports Databricks integration for your dbt Core projects and helps users handle large amounts of data more efficiently. Users can add and configure the Databricks project environment on 5X Managed dbt Core, and run required SQL or Python transformations on the dbt Core Console. The Complete Project Setup guide helps users set up their Databricks project.

Python support for 5X dbt Core Console

With this release, 5X Managed dbt Core now supports Python on the dbt Core Console to enhance flexibility and ease for data transformation and analysis use cases needing Python. The dbt Core Console supports both Python and SQL, extending dbt Core capabilities, vendor ecosystem support and user experience to help accomplish complex data transformation.

Here are the following supported features:

• Support for .py file extensions: The dbtCore Console editor supports the .py extension for your Python files.

• Run dbt commands for Python: Successfully run dbt commands for your Python transformations using the dbt command console on the dbtCore Console editor.

Python Support for 5X Managed dbt Core

Introducing Data Lineage for 5X Managed dbt Core

Introducing Data Lineage for 5X Managed dbt Core, the data visualization tool designed to empower data engineers and analysts to efficiently manage and understand data model dependencies within a hosted 5X Managed dbt Core environment.

Data Lineage supports the following functions:

• Lineage boosts user productivity and the decision-making process as it enables users to perform root cause analysis more efficiently.

• Lineage supports capabilities to trace dashboard issues to their source models to help users assess the downstream impact of changes.

• Lineage is built with an intuitive user experience and promotes integrity and efficiency for the data modeling processes.

Lineage for 5X Managed dbt Core

Data Lineage on 5X Managed dbt Core supports the following functions:

• Access Lineage on the dbt Core Console of 5X Managed dbt Core to view the entire model and its highlighted lineage.

• Hide/ show parent and hide children nodes of the model.

• Navigate the layout and customize the viewing screen with an expanded view, zoom in/ out and reset the view.

• Search for models in your repository as required and use tags to include/exclude models during the search.

• Download Lineage diagrams in PNG format.

Introducing Brandwatch Connector on Gravity Unified IDE

With this release, Gravity Unified IDE supports a new Brandwatch connector for marketing analytics use cases. Users can utilize the Brandwatch connector to pull social media analytics data into a data warehouse to track brand health and campaigns across social platforms. Create Syncs using Brandwatch as a Source and run Jobs for your required analytics use case.

Duplicate Jobs within a Sync

Gravity Unified IDE users can now duplicate Jobs within a required Sync to extend flexibility in managing Jobs. Select the required Jobs in your Sync and use the Duplicate Jobs function to replicate the selected Jobs.

Duplicated Jobs require the following conditions:

• Rename the Jobs you are replicating to prevent errors. Renamed Jobs cannot be edited once replicated.

• The duplicate Jobs will share the original Jobs Target DB schema and table name. Users can update the duplicated Jobs to prevent data duplication or loss.

• The duplicated Jobs are paused by default.

Enhancements

Copy Results on 5X Snowflake SQL Editor

The 5X Snowflake SQL Editor has an added enhancement where users can copy the SQL query Results on the editor to update the user experience. The enhancement allows users to have access to copy and paste required rows of their query results.

5X Platform mailing address update

The mailing address for 5X Platform communications is updated to [e-mail] with this release.