This feature is in Public Preview.
Infoworks DataFoundry is an automated enterprise data operations and orchestration system that runs natively on Databricks and leverages the full power of Databricks to deliver a easy solution for data onboarding—an important first step in operationalizing your data lake. DataFoundry not only automates data ingestion, but also automates the key functionality that must accompany ingestion to establish a foundation for analytics. Data onboarding with DataFoundry automates:
Data ingestion: from all enterprise and external data sources
Data synchronization: CDC to keep data synchronized with the source
Data governance: cataloging, lineage, metadata management, audit, and history
Here are the steps for using Infoworks with Databricks.
Infoworks authenticates with Databricks using a Databricks personal access token.
As a security best practice when you authenticate with automated tools, systems, scripts, and apps, Databricks recommends that you use OAuth tokens or personal access tokens belonging to service principals instead of workspace users. To create tokens for service principals, see Manage tokens for a service principal.
Infoworks will write data to an S3 bucket and the Databricks integration cluster will read data from that location. Therefore the integration cluster requires secure access to the S3 bucket.
To access AWS resources, you can launch the Databricks integration cluster with an instance profile. The instance profile should have access to the staging S3 bucket and the target S3 bucket where you want to write the Delta tables. To create an instance profile and configure the integration cluster to use the role, follow the instructions in Configure S3 access with instance profiles.
As an alternative, you can use IAM credential passthrough, which enables user-specific access to S3 data from a shared cluster.
Set Cluster Mode to Standard.
Set Databricks Runtime Version to a Databricks runtime version.
spark.databricks.delta.optimizeWrite.enabled true spark.databricks.delta.autoCompact.enabled true
Configure your cluster depending on your integration and scaling needs.
For cluster configuration details, see Create a cluster.
See Retrieve the connection details for the steps to obtain the JDBC URL and HTTP path.
To connect a Databricks cluster to Infoworks you need the following JDBC/ODBC connection properties:
Go to Infoworks to learn more and get a demo.