Connect GX Cloud to Databricks SQL
Prerequisites
-
You have a GX Cloud account with Admin or Editor permissions.
-
You have a Databricks SQL catalog, schema, and table.
-
To improve data security, GX recommends creating a separate Databricks SQL service principal for your GX Cloud connection.
Connect to a Databricks SQL Data Asset
-
In GX Cloud, click Data Assets > New Data Asset > Databricks SQL.
-
Enter a meaningful name for the Data Source in the Data Source name field.
-
Enter a connection string in the Connection string field. The connection string format is
databricks://token:{token}@{host}?http_path={http_path}&catalog={catalog}&schema={schema}
.- Check the instructions to create a GX-specific user in your Databricks SQL catalog by clicking "See instructions"
-
Click Connect.
-
Select tables to import as Data Assets:
-
Check the box next to a table name to add that table as an asset.
-
At least one table must be added.
-
To search for a specific table type the table's name in the Search box above the list of tables.
-
To add all of the available tables check the box for All Tables.
-
-
Click Add Asset.
-
Create an Expectation. See Create an Expectation.